In 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.
Excel / Logistics Administrator / Shortage Report
Work to improve Shortage Report
In this post I discuss what work needs to be done to improve shortage reporting. My main objective is to create a feature that would allow to add destination or order name to the shortage report in case multiple orders have been requested in one email.
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 4
Scripting 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 3
I 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 1
Finishing 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.
canvasJS / CHEP Pallets / Data Analytics / javacsript / Logistics Administrator
CHEP Pallets Monitoring And Report. Step 18 – Adding coloured suppliers names (Labels)
In this post I showcase how I added coloured suppliers name for each month to chart 1.
canvasJS / CHEP Pallets / Data Analytics / javacsript / Logistics Administrator
CHEP Pallets Monitoring And Report. Step 17 – Colouring stripLines for every second supplier
To make it easier to distinguish individual suppliers the chart 1, I coloured the background of every second suppliers bar charts. In this post I explain how I’ve done this.
canvasJS / CHEP Pallets / Data Analytics / javacsript / Logistics Administrator
CHEP Pallets Monitoring And Report. Step 16 – Colouring chart 1 bars
In this post I explain how I colour bar charts for chart 1. Every unique suppliers gets assigned a color for its bar charts, to make it easy to distinguish the supplier inside the chart.
canvasJS / CHEP Pallets / Data Analytics / javacsript / Logistics Administrator
CHEP Pallets Monitoring And Report. Step 15 – Adding bars to chart 1
In this post I explain how the bar charts have been rendered for chart 1 and demonstrate the code responsible for it.