Delivery slip
The data model comprises measures for Total delivery orders, On-time delivery orders, Late delivery orders, Closed orders, Orders in progress, Shipped orders, Unshipped orders, Service delivery rate, Volume of goods, Weight of goods, and Number of parcels. Additionally, it includes views for Number of packages per delivery slip, Count of late shipments, and Service rate based on timely deliveries. Various deadlines are captured for generic routes throughout the week.
Benefits of This Data Model
- Enhanced Delivery Performance: The data model allows tracking and analysis of on-time delivery orders, late delivery orders, and service delivery rate, enabling optimization of delivery operations for improved performance.
- Data-driven Decision Making: By providing measures such as volume of goods, weight of goods, and number of parcels, the data model empowers stakeholders to make informed decisions based on accurate and reliable data.
- Operational Efficiency: Through insights gained from measures like orders in progress, shipped orders, and unshipped orders, the data model supports enhancing operational efficiency by identifying bottlenecks and optimizing processes.
- Improved Customer Satisfaction: Utilizing the data model to monitor closed orders and service delivery rate helps in ensuring timely and accurate deliveries, leading to enhanced customer satisfaction and loyalty.
Key Performance Indicators (KPIs)
- Ordre de livraison Total: Total number of delivery orders.
- Ordre de livraison À temps: Number of delivery orders delivered on time.
- Ordre de livraison À temps (%): Percentage of delivery orders delivered on time.
- Ordre de livraison En retard: Number of delivery orders delivered late.
- Ordre de livraison En retard (%): Percentage of delivery orders delivered late.
- Ordre de livraison Fermé: Number of closed delivery orders.
- Ordre de livraison En cours: Number of delivery orders currently in progress.
- Tournée générique Heure limite du lundi: Deadline time for generic route on Mondays.
- Tournée générique Heure limite du mardi: Deadline time for generic route on Tuesdays.
- Tournée générique Heure limite du mercredi: Deadline time for generic route on Wednesdays.
- Tournée générique Heure limite du jeudi: Deadline time for generic route on Thursdays.
- Tournée générique Heure limite du vendredi: Deadline time for generic route on Fridays.
- Ordre de livraison Expédié: Number of delivery orders shipped.
- Ordre de livraison Non-expédié: Number of delivery orders not yet shipped.
- Ordre de livraison Taux de service: Service delivery rate.
- Volume: Total volume of delivered goods.
- Poids BL: Weight of goods in delivery orders.
- Nombre de Colis: Total number of parcels in delivery orders.
Available Visualizations
| View Name | Description |
|---|---|
| Number of packages | Number of packages shipped in each delivery slip. |
| Nbre OL expédié en retard | Count of delivery slips with late shipment. |
| Service rate | Percentage of delivery slips delivered on time. |