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
- Key metrics (big numbers)
- Trends (charts)
- Details (tables)
- 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