Deliveries
The data model captures key delivery performance metrics such as total lines, net weight, and volumes for deliveries, as well as quantities ordered, delivered, and to be delivered. It also includes invoicing and margin details in different currencies, delivery timeliness analysis, and insights on pending deliveries by customer. The model enables tracking of delivery status, product-wise delivery volumes, customer-specific delivery breakdowns, and proactive management of pending and on-time deliveries.
Benefits of This Data Model
- Improved Delivery Performance Tracking: Enhances monitoring of delivery status and product-wise volumes for better insights into delivery efficiency.
- Enhanced Customer Relationship Management: Provides detailed breakdowns of deliveries by customer, aiding in improving service levels and strengthening client relationships.
- Proactive Pending Delivery Management: Enables proactive management of pending deliveries, late orders, and expected delivery times to minimize delays and optimize operations.
- Facilitates Timely Coordination: The model's insights on today's scheduled deliveries ensure smooth and timely coordination for efficient operations.
Key Performance Indicators (KPIs)
- Delivery Count: Total number of deliveries made.
- Number of Lines: Total number of lines in the deliveries.
- Net weight: Total weight of delivered items in the deliveries.
- Volume: Total volume of delivered items in the deliveries.
- Quantity Returned: Total quantity of items returned.
- Quantity Stock Unit: Total quantity of items in stock.
- Quantity Returned Stock Unit: Total quantity of returned items in stock.
- Quantity Ordered: Total quantity of items ordered.
- Quantity Delivered: Total quantity of items actually delivered.
- Quantity Shipped: Total quantity of items shipped.
- Quantity To Be Delivered: Total quantity of items yet to be delivered.
- Quantity % Delivered: Percentage of items delivered compared to items ordered.
- Quantity % Shipped: Percentage of items shipped compared to items ordered.
- Invoice Amount (without taxes) Global: Total invoice amount without taxes in the global currency.
- Trans. Currency Invoice Amount (without taxes): Total invoice amount without taxes in the transactional currency.
- Trans. Currency Total Cost: Total cost in the transactional currency.
- Trans. Currency Total Margin: Total margin in the transactional currency.
- Reporting Currency Invoice Amount (without taxes): Total invoice amount without taxes in the reporting currency.
- Reporting Currency Total Cost: Total cost in the reporting currency.
- Reporting Currency Total Margin: Total margin in the reporting currency.
- Global Currency Total amount (without taxes): Total amount without taxes in the global currency.
- Global Currency Total Cost: Total cost in the global currency.
- Global Currency Total Margin: Total margin in the global currency.
- Order Delivery Days Delayed: Total number of days delayed in delivery.
- Delivery (Delayed) Count: Total count of delayed deliveries.
- Delivery (On-Time) Count: Total count of on-time deliveries.
- Delivery On-Time %: Percentage of deliveries that are on-time.
- Delivery % On-Time In-Full Count: Percentage of deliveries that are both on-time and in full.
- Delivery Average Lead Time: Average lead time for deliveries.
Available Visualizations
| View Name | Description |
|---|---|
| Deliveries Follow-up | Offers insights on delivery status, updating times, and potential delays for follow-up actions. |
| Deliveries by Product | Shows the volume of deliveries per product, aiding in product demand analysis and forecasting. |
| Deliveries by Customer | Provides a breakdown of deliveries by customer, assisting in customer relationship management and service improvement. |
| Remains to be Delivered / Customer late & Expected | Highlights pending deliveries, late orders, and expected delivery times for proactive management. |
| Today Deliveries | Displays deliveries scheduled for the day, ensuring timely coordination and smooth operations. |