Skip to content

Dashboard templates

Manufacturing · Data & analytics

A plant whose data team loads machine shift reports and downtime from MES, production and sales orders from ERP, and quality inspection records into the warehouse. A key KPI board (output, OEE, scrap, inspection defects, on-time delivery, downtime) plus pipeline reliability, data quality, analysis requests, dashboard usage and the share of output falling on days with late data.

Free plan with no time limit · No card required · Sample workspace ready in minutes

For factory data teams loading machine shifts, downtime, production orders, sales orders and quality inspections. The "KPI board" dashboard brings together output, OEE, scrap rate, inspection defects, on-time delivery and downtime, plus the share of output that falls on days with late data, so readers know which numbers are still incomplete. The "Data reliability" and "Requests and usage" dashboards measure run success rate, test pass rate, freshness violations and request delivery time. Needs machine, item, production order, machine shift and pipeline run log data.

Use this template to

  • Flag months where a lot of output falls on late-data days before closing OEE.
  • Pick which pipeline to fix first by failure count and number of affected tables.
  • Give plant managers one KPI board instead of many hand-built summary files.

3 ready-made dashboards

KPI board

Key factory production metrics next to the reliability of the data behind them.

  • Good output
  • Output value
  • OEE (overall equipment effectiveness)
  • Scrap rate
  • Inspection defect rate
  • On-time completion rate
  • Downtime minutes
  • Output share on late-data days
  • Run success rate
  • Check pass rate

Data reliability

Are pipelines running reliably, is data as fresh as promised, and how many quality checks pass.

  • Run success rate
  • Freshness breaches
  • Check pass rate
  • Average run duration (minutes)
  • By data table
  • Weekly failed runs by domain
  • Failed checks by type

Requests and usage

How many analysis requests departments send, how fast the data team delivers, and how often dashboards are viewed.

  • Analysis requests
  • Average request lead time (days)
  • Dashboard views
  • Departments viewing dashboards
  • By department
  • Views by dashboard
  • Weekly new analysis requests

Ask Si as soon as the build finishes

  • “How did output share on late-data days change compared with last month?”
  • “What is driving output recorded on late-data days this quarter?”
  • “Show departments viewing dashboards by month for the last six months.”
  • “Where is average request lead time (days) highest this month, and why?”

27 defined metrics

Versioned definitions, shared by dashboards, Si, reports and MCP.

MetricDefinitionUnit
Output share on late-data daysOutput of machine shifts falling on days whose data missed the freshness commitment divided by total output in the same period. Shows how much of the production figures on the KPI board arrived late or were incomplete when viewed.= Output recorded on late-data days / Total outputRatio (%)
Output recorded on late-data daysTotal output (including scrap) of machine shifts falling on days with at least one data load later than the freshness commitment. Figures for these days may have been viewed while incomplete and should be rechecked.Count
Departments viewing dashboardsNumber of distinct departments with at least one dashboard view in the period.Count
Average request lead time (days)Average days from when a department submits a request to when the data team delivers it, for requests delivered in the period.= da_request_lead_days_total / Delivered requestsNumber
Average run duration (minutes)Average minutes from start to finish of successful runs in the period.= da_run_minutes_total / da_successful_runsNumber
Check pass ratePassed checks divided by all data quality checks in the period.= (Data quality checks - Failed checks) / Data quality checksRatio (%)
Dashboard viewsTotal dashboard views by users across departments in the period.Count
Delivered requestsDelivered requests with a delivery date in the period (by delivery date).Count
Failed checksData quality checks with a standardized result of fail in the period.Count
Failed runsPipeline runs with a standardized status of failed (including errors and timeouts), by start date.Count
Freshness breachesSuccessful runs where the gap since the previous successful load of the same table exceeds that table's freshness commitment (freshness_sla_hours).Count
Pipeline runsData loading pipeline runs started in the period, including successful, failed and skipped runs.Count
Data quality checksData quality checks run in the period (freshness, completeness, uniqueness, validity).Count
Analysis requestsAnalysis and report requests that departments submitted to the data team in the period (by submission date).Count
Run success rateSuccessful runs divided by runs with an outcome (successful plus failed). Skipped runs are excluded.= da_successful_runs / (da_successful_runs + Failed runs)Ratio (%)
AvailabilityRun minutes divided by planned minutes. The first component of OEE.= mfg_run_minutes / mfg_planned_minutesRatio (%)
Completed work ordersWork orders completed in the period, by completion date.Count
Inspection defect rateDefective samples divided by inspected samples across the inspection lots in the period.= mfg_defect_qty / mfg_inspected_qtyRatio (%)
Downtime minutesTotal machine downtime minutes recorded in the period, for every reason (including changeovers and scheduled maintenance).Number
First pass yield (FPY)Good output divided by total output. The quality component of OEE.= Good output / Total outputRatio (%)
OEE (overall equipment effectiveness)Availability x performance x first pass yield, computed on the period totals.= (mfg_run_minutes / mfg_planned_minutes) * (Total output / mfg_ideal_output) * (Good output / Total output)Ratio (%)
On-time completion rateWork orders completed on time divided by work orders completed in the period.= mfg_on_time_work_orders / Completed work ordersRatio (%)
Good outputGood units (total output minus scrap) produced in the period's shifts, by shift date.Count
Output valueGood output multiplied by the item's standard selling price, by machine shift date.Currency
PerformanceTotal output divided by the ideal output for the run time. The second component of OEE.= Total output / mfg_ideal_outputRatio (%)
Total outputTotal units produced in the period's shifts, including both good units and scrap.Count
Scrap rateScrap units (total output minus good output) divided by total output.= (Total output - Good output) / Total outputRatio (%)

Data you need

Required

machine, item, work_order, machine_shift, da_pipeline_run

Add if you have it (unlocks more metrics)

downtime_event, quality_inspection, da_dataset, da_quality_check, da_request, da_dashboard_view

Three steps to this dashboard

  1. 1

    Connect your data

    Upload an Excel file or connect a source with: machine, item, work_order, machine_shift, da_pipeline_run.

  2. 2

    Approve Si's proposal

    Si proposes how to read your tables and map them to the industry's standard model; you fix anything highlighted and approve.

  3. 3

    Dashboards and Q&A

    The build gives you 3 dashboards and 27 metrics; ask Si anytime.

Related templates

Build Manufacturing · Data & analytics with your own data

Free plan with no time limit · No card required · Sample workspace ready in minutes