I have a data analysis task. I need a dashboard built from the attached spreadsheet. This sheet is received daily. I want the dashboard to include the following metrics:
1. container counts in route by carrier, by origin to which destination. (i.e. Containers in route via APL, CMA, form origin SZX, SGN, etc). This metric should also have the total count in route.
2. Container counts in route for each destination (Dest) Englewood, Thornton, Firestone, Gilbert, Glendale, Grand Junction. This count does not need to include carrier or origin. Only totals.
3. Top 10 vendors with highest container counts in route
4. Top 5 vessels with the highest number of containers.
5. Containers received MTD
6. Average transit times from Actual Dept Date (COB) to Off Loaded Vessel for inbound shipments to Gilbert and Glendale, AZ. Average transit times for Englewood, Thornton, Firestone and Grand Junction must be calculated from Actual Dept Date (COB) to Arrived Dest Rail.
Note that duplicate container numbers must be removed before the dashboard is generated. The duplicates are included to indicate the POS associated with a container. The final destination is the same on these containers. This dashboard is to count containers, not POS.
9 freelancers are bidding on average $118 for this job
Hi, After reviewing the project description I know that I'm an excellent fit for this [login to view URL]'s discuss and start right now. Awaiting for your positive reply thanks.