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 / github / Logistics Administrator / PHP / SQL
CHEP Pallets Monitoring And Report. Step 10
In this post I show how I orginize data for my third chart. As I tried a different approch of forming and array, I noticed that I need to reorder my chart 1 data as well.
CHEP Pallets / Data Analytics / github / javacsript / Logistics Administrator / PHP / SQL
CHEP Pallets Monitoring And Report. Step 9
I queried database to get sum of pallets that were transferred in and sum of pallets returned, as these are the quantities I need for my second chart. Also added some security against SQL injection.
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 / Data Analytics / github / Logistics Administrator / PHP / SQL / Uncategorized
CHEP Pallets Monitoring And Report. Step 7
I managed to achieve the array structure layed out in previuos post, and it can be sent over to front end. I also learn some new things about arrays and updated my previuos PHP code.
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.
CHEP Pallets / Data Analytics / Logistics Administrator
CHEP Pallets Monitoring And Report. Step 2
After some consideration I decided that one way to do it is by coding a website to upload an excel file and generate a chart.
CHEP Pallets / Data Analytics / Logistics Administrator / Protean
CHEP Pallets Monitoring And Report. Step 1
Been assigned a task to figure a way to monitor discrepancies in CHEP pallets, but I’m running into quite a few issues.