Operational Dashboard Generator

Overview

The Operational Dashboard Generator skill provides comprehensive capabilities for creating real-time operational performance dashboards. It supports KPI definition, visual management displays, trend analysis, and alert configuration.

Capabilities

• KPI definition and calculation
• Real-time data integration
• Visual management displays
• Trend analysis
• Alert threshold configuration
• Drill-down reporting
• Mobile dashboard access
• Executive summary generation

Used By Processes

• CI-001: Operational Excellence Program Design
• SIX-002: Statistical Process Control Implementation
• QMS-003: Quality Audit Management

Tools and Libraries

• Power BI
• Tableau
• Grafana
• Real-time data platforms

Usage

skill: operational-dashboard-generator
inputs:
  dashboard_type: "operations_center"  # executive | operations_center | shop_floor
  kpis:
    - name: "OEE"
      target: 85
      warning_threshold: 75
      critical_threshold: 65
      calculation: "(availability * performance * quality)"
    - name: "On-Time Delivery"
      target: 98
      warning_threshold: 95
      critical_threshold: 90
      calculation: "(on_time_orders / total_orders) * 100"
  data_sources:
    - type: "mes"
      connection: "mes_api"
    - type: "erp"
      connection: "sap_bapi"
  refresh_rate: 60  # seconds
outputs:
  - dashboard_definition
  - visualization_specs
  - alert_configuration
  - data_model
  - mobile_view

KPI Categories

Production KPIs

KPI	Definition	Target
OEE	Equipment effectiveness	>85%
Throughput	Units per hour	Per plan
Yield	Good units / Total units	>99%
Cycle Time	Time per unit	At takt

Quality KPIs

KPI	Definition	Target
First Pass Yield	Pass first time	>98%
Defect Rate	Defects per million	<1000
Scrap Rate	Scrap cost %	<1%
Customer Complaints	Per period	Trending down

Delivery KPIs

KPI	Definition	Target
On-Time Delivery	% shipped on time	>98%
Lead Time	Order to ship	Per commitment
Schedule Attainment	Actual vs. plan	>95%
Backlog	Past due orders	Zero

Dashboard Design Principles

Information Hierarchy

1. Key metrics (big numbers)
2. Trends (charts)
3. Details (tables)
4. Drill-down (links)

Visual Best Practices

• Use color meaningfully (RAG status)
• Minimize clutter
• Consistent layout
• Clear labels
• Real-time updates

Alert Configuration

Level	Threshold	Action
Info	Near target	Monitor
Warning	Below target	Investigate
Critical	Significantly below	Immediate action

Dashboard Layers

Executive Dashboard

• High-level summary
• Company-wide view
• Weekly/monthly trends
• Strategic KPIs

Operations Center

• Site-level view
• Daily/hourly trends
• Operational KPIs
• Resource status

Shop Floor Display

• Real-time status
• Line-level view
• Visual management
• Immediate feedback

Integration Points

• Manufacturing Execution Systems
• ERP systems
• Quality Management Systems
• IoT/sensor data