---
alias: user-guide-business-intelligence-dashboard-product-delivery
grafana_json: /Library/Build/ConfigFiles/Grafana/MES/dashboards/ProductDelivery.json
tags:
- dashboards
- product delivery
description: "This dashboard monitors production order delivery performance, identifies bottlenecks, and tracks key fulfillment metrics"
---

# Product Delivery

## Overview

The **Product Delivery** dashboard provides insights into the performance of production order execution and delivery timeliness. It helps monitoring delivery performance, identifying bottlenecks, and ensuring commitments are met on schedule.

## Folder

Performance.

## Database

- **CDM** (queried via OData).
- **DWH** (queried via OData).

## Data

- **On Time Delivery**  
- **Volume Fulfillment**  
- **Production Orders**

## Example

![Example of the Product Delivery dashboard](../images/product_delivery_dashboard.png)

## Data Breakdown

| KPI | Description | Formula | Datasource |
| --- | ----------- | ------- | ---------- |
| **On Time Delivery (%)** | Percentage of completed production orders finished before their due date. | `(On-time completed POs ÷ Total completed POs) × 100` | `Production.ProductionOrder` table in CDM from [[dataplatform-ioteventdefinition-dataset-productionorder]] |
| **Volume Fulfillment (%)** | Overall percentage of completed quantity vs. planned quantity. | `(Sum of Completed Quantity ÷ Sum of Planned Quantity) × 100` | `Production.ProductionOrder` table in CDM from [[dataplatform-ioteventdefinition-dataset-productionorder]] |
| **Production Orders** | Overview of orders across states: completed, in progress, or overdue. | Count by state (`Completed`, `InProgress`, `Released`) | `Production.ProductionOrder` table in CDM [[dataplatform-ioteventdefinition-dataset-productionorder]] and `ProductionOrdersInProgress` and `PendingLateProductionOrders` tables in DWH [[dataplatform-dataset-productionordersinprogress]] and [[dataplatform-dataset-pendinglateproductionorders]]|

## Data Visualization

| Panel | Description | Threshold Values | Datasource |
|-------|-------------|------------------|------------|
| **On Time Delivery** | KPI card showing percentage of orders delivered before due date. | As high as possible. | `Production.ProductionOrder` table in CDM from [[dataplatform-ioteventdefinition-dataset-productionorder]] |
| **Volume Fulfillment** | KPI card showing percentage of completed and planned orders, considering released, in-progress, and completed production orders. | As high as possible. | `Production.ProductionOrder` table in CDM from [[dataplatform-ioteventdefinition-dataset-productionorder]] |
| **Completed Production Orders** | KPI card showing the total number of completed orders. | N/A | `Production.ProductionOrder` table in CDM |
| **Total Production Orders** | KPI card showing the number of total orders (released, in progress, completed). | N/A | `Production.ProductionOrder` table in CDM from [[dataplatform-ioteventdefinition-dataset-productionorder]] |
| **Production Orders in Progress** | Horizontal bar chart showing progress of each ongoing production order. | Orders in green are on time; red indicates overdue. | `ProductionOrdersInProgress` table in DWH [[dataplatform-dataset-productionordersinprogress]] |
| **Pending Late Production Orders** | Breakdown of overdue production orders, including Order, Product, Description, Quantity, Units, Customer, Due Date, and Delay. | N/A | `PendingLateProductionOrders` table in DWH [[dataplatform-dataset-pendinglateproductionorders]] |

## Entity Filters

Single selection:

- Enterprise  
- Site  
- Facility  

Multiple/All selection:

- Production Order  
- Product Group  
- Product  

{% include-markdown 'includes/pages/dashboards_filter_options.md' %}