Updated YTD summary. Replaced
| elements. Wrote new SQL queries and improved how data is sent to front end.
chartJS / Data Analytics / Flickerbook / SQL / Web development
Added new charts to Flickerbook YOY sectionAdded 6 new charts to Flickerbooks YOY charts page. For the time being I believe this will be the last charts for this page.
chartJS / Data Analytics / Flickerbook / Web development
Calculating Hourly and daily costs to employer on FlickerbookAdded employer’s daily and hourly costs to daily and hourly averages tables. Also included these costs in the YOY charts.
Data Analytics / Flickerbook / PHP / SQL / Web development
Adding new column to Flickerbooks payments DB and generating values for it from existing dataA quick example of how I filled a newly created column in database table, using already existing data and PHP to calculate and insert new values into new column.
chartJS / Data Analytics / Flickerbook / HTML5 / javacsript / jQuery / PHP / SQL / Web development
Still Working On FlickerbookFor the last two months was continuing work on Flickerbook. Have done a lot of changes! Wont go trough all the code and queries I have written, but in this post I showcase new tables and charts I have created for my work related data 😉
charts / CHEP Pallets / Data Analytics / Excel / Logistics Administrator / PivotTable
Using Excel PivotTable to analyse CHEP pallet transfersIn this post I demonstrate how using excel pivot tables and excel charts I created a chart that displays the same data as the monthly transfers by supplier chart from CHEP pallet report website.
canvasJS / CHEP Pallets / CSS / Data Analytics / Excel / github / javacsript / Logistics Administrator / PHP / SQL / Uncategorized
CHEP Pallets Monitoring And Report. Step 22 – Finishing touch and final summary.I feel like this project is finished. In this post I discuss last work done on this project, show an example of how it did what it was designed to, and write a summary of what I learned and what I could have done better 😉
canvasJS / CHEP Pallets / Data Analytics / github / javacsript / Logistics Administrator
CHEP Pallets Monitoring And Report. Step 21 – Rendering chart 4Scripting the last chart! As this chart by it’s idea is very similar to chart 1 I just showcase a quick brief of how it was coded. And this means that this project is reaching it’s end 🙂
canvasJS / CHEP Pallets / CSS / Data Analytics / github / HTML5 / javacsript / Logistics Administrator / PHP / SQL
CHEP Pallets Monitoring And Report. Step 20 – Rendering chart 2 and chart 3I finish coding Chart 2 and Chart 3 for my project. Also fixed a few bugs and did some changes to styling. I can feel this project reaching it’s final shape! 😉
canvasJS / CHEP Pallets / CSS / Data Analytics / HTML5 / javacsript / Logistics Administrator
CHEP Pallets Monitoring And Report. Step 19 – Last bits for chart 1Finishing touches on chart 1. Before I can declare chart 1 completed there are a few little tings that needs tidying up. I go trough them in this post. |