Created by Fitria Dwi Wulandari – October, 2022
XYZ shop, a goods delivery expedition distributor in a remote city, serves as a third party to determine the most suitable expedition service for sending customer's goods to other cities. The shop wants to understand the characteristics of each delivery service company, including transportation modes, weight of goods sent, and various performance metrics.
This project seeks to enhance the quality of goods delivery expeditions by:
- Evaluating the performance of five delivery service companies based on shipment mode, customer rating, number of customer calls, and delivery status.
- Identifying the best delivery service company for each province.
- Analyzing factors that influence delivery time.
- Source: Data obtained from the Business Intelligence Courses at Rakamin Academy, which includes historical shipment data.
- Actions: Ensuring data quality for accurate analysis.
- Purpose: Discover patterns, spot anomalies, and gain a deeper understanding of the data's characteristics.
- Techniques: Use of various visualization techniques to explore and understand the data.
- Purpose: Present data in a clear and approachable way to facilitate decision-making.
- Database Management: PostgreSQL for storing and querying data.
- Data Visualization: Tableau for creating dashboards and visual representations of the data.
This analysis will provide valuable insights to:
- Improve Delivery Service Selection: Understand the most efficient and reliable delivery service companies for each province.
- Enhance Efficiency: Understand factors influencing delivery time to optimize shipment processes.
- Boost Customer Satisfaction: Ensure better overall performance and customer satisfaction by choosing the best delivery services.
- Extended Analysis: Include more variables and data sources for a comprehensive understanding of delivery service performance.
- Model Improvement: Explore more advanced analytical techniques.
- Dashboard: Tableau dashboards visualizing the key insights and metrics.