High Level Design
Overview
Ecommerce companies are constantly thinking of ways to improve service to their customers, especially avoid delays when delivering products. Therefore, it is crucial for these companies to identify reasons for delays to minimize them as much as possibleDashboard Example (sample data)
Click on the image to open and interact with the dashboard:
Goals
Improve service to customers
Objectives
- Minimize delivery delays
KPIs Architecture
| Objective | KPI’s | Measures | Data source |
| Minimize delivery delays
|
On time delivery rate | ([# of Late/OnTime],[Late/OnTime])/count([Order ID]) | Orders |
| Break by Reasons for delay | ([# of Late/OnTime],[Late/OnTime]) | Orders, DelayReason | |
| Delivery Rate by Origin | ([# of Late/OnTime],[Late/OnTime])/count([Order ID]) | Orders, Warehouse | |
| Delivery Rate by Destination | ([# of Late/OnTime],[Late/OnTime])/count([Order ID]) | Orders, Customers | |
| On time delivery rate by Delivery Provider | ([# of Late/OnTime],[Late/OnTime])/count([Order ID]) | Orders, DeliveryProvider | |
| On time delivery rate by Period | ([# of Late/OnTime],[Late/OnTime])/count([Order ID]) | Orders | |
| % Deliveries on time | ([# of Late/OnTime],[Late/OnTime])/count([Order ID]) | Orders, DeliveryType | |
| Avg delay (days) | ([Average DayDifference],[DayDifference1]) | Orders, DeliveryType |
Entities Relationship Diagram
