About this project


The purpose of this project is to showcase my skills and knowledge in Tableau Data Visualization and Excel spreadsheet.

tableau_logo excel_logo

Scenario

You oversee the North American logistics operations for a naton-wide retailer selling various imports products. The congestion at ports, and skyrocketing fuel and transportation costs, has created the need for your company to rethink how your're currently importing and distributing your products throughout the US to continue to meet the demands of your customers.
You have been given the raw datasets and have been asked to clean, analyze the data and transform them into meaningful insights, trends, and patterns and present to company's executives.

- Tableau Dashboard -

Logistics Demand by State/City

dashboard


Container Shipping Rate

dashboard

Worksheets

worksheet_1
worksheet_2
worksheet_3
worksheet_4
worksheet_5
worksheet_6

Dataset Information & Download

Total of 1,263 records - DemandData.xlsx
[Download raw xlsx-file (86KB) here]
[Download cleaned xlsx-file (110KB) here]

Total of 623,809 records - RateData.xlsx
[Download raw xlsx-file (31.5MB) here]
[Download cleaned xlsx-file (38.8MB) here]