Logistics Company Operations
Project at Glance
In this project, i will try to demonstrate an end-to-end data analyst/business intelligence project from a Brazilian Logistics company. The user of this project is an Operations Manager who want to evaluate the company’s operation for the e-commerce logistics business segment.
Business Request & Demand Overview
In every data analytics/business inteliigence project, there must be a business request and demand overview from the user who will take advantage of the result/output. The user request for this project can be seen as below:
Hence, below is the business demand overview for the requested and additional information:
Database ER Diagram
The database’s entity-relationship (ER) from which the data is taken can be seen below:
Data Cleansing & Transformation
We must clean and transform the data required from database. Below is the SQL query for the data:
Data Involved
The data involved for the input to Power BI can be seen as below:
Dashboard Overview
The dasboard result:
*Delivery Packages Overview
*Delivery Route Overview
Full Interactive Dashboard : Dashboard