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.
Hi there,
I’d like to be considered for your project position.
I have read your job description and it has a great fit to me. I am very clear will all instruction which you have described.
I would also like to mention that we have experts working over here and they will provide you 100% result.
We are ready to give an assurance regarding our work whether it is a question of quality or time or anything else.
Once you message me, I will provide you link which explores my work.
I’m glad to answer any questions you may have!
Thanks.
$133 USD in 3 days
4.5 (49 reviews)
5.2
5.2
8 freelancers are bidding on average $125 USD for this job
Hello,
Greetings of the day!
I have gone through the job description carefully and you’d be glad to know that the skills you are looking for are right up my alley and i am very much well equipped to do data analysis task for you.
I have analysed the attached spreadsheet you provided and i can provide you excellent dashboard built from it.
About US:
I am Expert in Data entry work, Microsoft excel, Office, virtual assistant, SEO, Social Media, Online Marketing. I have 5+Years of Experience in this field. I have proven results of such type of achievements for various websites.
I would like to highlight that I can communicate fluently in English and can easily be contacted through Skype, Phone or Email
With Warm Regards
Lucky
I am Gretchen and I already had experience working in Amazon as Data Entry in their product to create a keyword and I am also expert in MS Excel, PP and Publisher, I am also expert in Adobe Photoshop for making a Wedding invitation and photo editing.
Hi
I am new to freelance, so I do not have reviews here yet, but if you hire me, i will be happy to provide a discount for a review.
i have over 8 years of PHP development experience.
i can complete your task in 2 days.