---
alias: user-guide-business-intelligence-dashboard-step-overview
grafana_json: /Library/Build/ConfigFiles/Grafana/MES/dashboards/StepOverview.json
tags:
- dashboards
- step
- performance
description: "This dashboard analyzes production step performance, revealing inefficiencies and correlating yield with cycle time data"
---

# Step Overview

## Overview

The **Step Overview** dashboard provides performance and loss analysis for a specific production step. It helps identifying inefficiencies, frequent failure causes, and correlations between yield and cycle performance.

## Folder

Performance folder.

## Database

- **CDM** (queried via OData).
- **DWH** (queried via Cube using GraphQL).

## Data

- **Yield**
- **Loss**
- **Unit Cycle Time** (UCT)

## Example

![Example of the Step Overview dashboard](../images/step_overview_dashboard_1.png)
![Example of the Step Overview dashboard](../images/step_overview_dashboard_2.png)

## Data Breakdown

| KPI | Description | Formula | Datasource |
| --- | ----------- | ------- | ---------- |
| **Yield (%)** | Share of processed material that becomes usable output for the current step. | (Good units ÷ Total units) × 100 | `material_movement` from [[user-guide-materialcube]] |
| **Loss** | Material losses grouped by reasons or product group and ranked by absolute loss quantity. | Sum of loss (`Change_PrimaryQty`) grouped by reason or product group. | `MaterialLossBonus` table in [[dataplatform-dataset-materiallossbonus]] |
| **Unit Cycle Time** | Average processing time per unit of material in the step. | Time the material was in the process / Processed quantity (`Sum(In-Process Duration) ÷ Sum(Processed Quantity)`). | `material_movement.in_process_duration` and `material_movement.processed_primary_quantity` from [[user-guide-materialcube]] |

## Data Visualization

| Panel | Description | Threshold Values | Datasource |
|-------|-------------|------------------|------------|
| **Yield** | KPI card displaying the yield value for the current step and filters. | Red <80%, Yellow 80–90%, Green >90%. | `material_movement` in [[user-guide-materialcube]]|
| **Unit Cycle Time** | KPI card showing average unit processing time at the step. | As low as possible. | `material_movement` from [[user-guide-materialcube]]  |
| **Top Loss Reasons** | Bar chart showing top loss reasons. | Highest loss reason highlighted in red. | `MaterialLossBonus` table in [[dataplatform-dataset-materiallossbonus]] |
| **Losses Over Time by Product Group** | Line chart of losses by product group over time. If no product groups are in use, it will display losses grouped in a single "no product group" line. You can also select which product groups to see. | Higher lines represent greater losses. | `MaterialLossBonus` table in [[dataplatform-dataset-materiallossbonus]] |
| **Yield and UCT Correlation Analysis** | Dual-axis time series comparing yield (%) and UCT (s/unit). | Yield should be high, UCT should be low. | `material_movement` from [[user-guide-materialcube]] |

## Filters and Settings

Single selection:

- Enterprise
- Site
- Step
- Material Units
- Show Top (10, 20, 50, 100)- pertains to how many materials and reasons are presented in the graphs.

Multiple/All selection:
  
- Facility  
- Area  
- Product Group  
- Product Type  
- Product  
- Step Type  

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