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 😉
CHEP Pallets / Data Analytics / Excel / Logistics Administrator / Uncategorized
CHEP Pallets Monitoring And Report. Step 12 -Mid summary
In this post I summarize what has been done so far. Explain what charts will be drawn at front end and create sample charts with excel as a guidance.
CHEP Pallets / Data Analytics / Excel / github / Logistics Administrator / PHP / SQL
CHEP Pallets Monitoring And Report. Step 11
After running some queries against the database I decided to change what second chart is going to show and also came up with idea for a one more chart (so there will be a total of 4 charts).
CHEP Pallets / Data Analytics / Excel / Logistics Administrator
CHEP Pallets Monitoring And Report. Step 8
In this post I explain why an excel file that should contain 6 months worth of transfers only has 4. Also came up with idea for a new chart.
CHEP Pallets / CSS / Data Analytics / Excel / github / HTML5 / javacsript / Logistics Administrator / PHP / SQL
CHEP Pallets Monitoring And Report. Step 4
Started coding CHEP pallets report. Already created a website where you upload the transaction report and then upload the chosen columns to database for SQL querying.
CHEP Pallets / Data Analytics / Excel / Logistics Administrator
CHEP Pallets Monitoring And Report. Step 3
Let’s examine the Transaction report excel file from my.chep.com website and determine which columns with data will be used to create the chart.