1.6 Sample Project | Food delivery startup
Title: Analyzing Delivery Times at a Food Delivery Startup
Overview: In this project, we used data analytics to understand delivery times at a food delivery startup. We collected data on delivery times for each order, including the order time, delivery time, and distance traveled. We used SQL and Excel to analyze the data and identify trends and patterns. Our goal was to improve delivery efficiency and reduce delivery times.
Data table:
| Order ID | Order Time | Delivery Time | Distance (km) |
|---|---|---|---|
| 1 | 2021-01-01 12:00:00 | 2021-01-01 12:30:00 | 3 |
| 2 | 2021-01-01 12:15:00 | 2021-01-01 13:00:00 | 5 |
| 3 | 2021-01-01 12:30:00 | 2021-01-01 12:45:00 | 2 |
| 4 | 2021-01-01 12:45:00 | 2021-01-01 13:15:00 | 7 |
| 5 | 2021-01-01 13:00:00 | 2021-01-01 13:30:00 | 4 |
SQL query:
SELECT AVG(DATEDIFF(minute, order_time, delivery_time)) as Average Delivery Time
FROM orders
WHERE delivery_time BETWEEN '2021-01-01' AND '2021-01-31';
This query calculates the average delivery time for the month of January 2021 (assuming the orders table includes columns called order_time and delivery_time).
Business metrics:
- Average delivery time: We can use the average delivery time as a measure of efficiency. A shorter average delivery time indicates that orders are being delivered more quickly.
- Distance traveled: The distance traveled can be used as a measure of the efficiency of our delivery routes. A shorter distance traveled may indicate that we are able to deliver orders more efficiently.
Key tasks and responsibilities:
- Collect and cleaned data on delivery times using SQL
- Creat visualizations in Excel to explore patterns and trends in delivery times
- Used regression analysis to identify factors that influence delivery times
- Present findings to the management team and made recommendations for improving delivery efficiency
Tools and technologies used: SQL, Excel, regression analysis
Key achievements:
- Identified key factors that influence delivery times, including distance traveled and order time
- Recommended changes to delivery routes and scheduling to reduce delivery times by 15%
- Presented findings to the management team, leading to the adoption of new policies and practices that improved delivery efficiency and customer satisfaction.
This project demonstrates your ability to collect and analyze data, identify trends and patterns, and use your findings to make recommendations for business improvement. It also showcases your technical skills in SQL and Excel, as well as your ability to apply statistical analysis techniques to real-world data.