Basic understanding of databases
Laptop with required software installed
Course Deliverables
1. Understanding of data modeling for manufacturing
2. Mastery of dashboard design principles
3. Advanced tool-specific skills (Tableau or Power BI)
4. Best practices documentation
5. Project templates and examples
6. Integration guidelines
Day 1: Data Modeling and Visualization Foundations
Morning Session (8:00 AM - 12:00 PM)
Introduction to Data Visualization in Manufacturing
o Role of data visualization in production decisions
o Understanding stakeholder needs
o Key visualization principles for manufacturing data
o Industry benchmarks and standards
Data Modeling Fundamentals
o Understanding Star Schema
o Fact and Dimension tables in production context
o Data warehouse concepts
o ETL processes overview
Afternoon Session (1:30 PM - 5:00 PM)
Advanced Data Modeling
o Snowflake Schema
o Handling slowly changing dimensions
o Best practices for production data modeling
o Hands-on Exercise: Creating a data model
Data Quality and Governance
o Data validation techniques
o Quality control measures
o Data refresh strategies
o Governance policies and compliance
o Error handling and logging
Day 2: Dashboard Design and Integration
Morning Session (8:00 AM - 12:00 PM)
Dashboard Design Principles
o Layout and composition
o Color theory and accessibility
o Visual hierarchy
o Mobile responsiveness
KPI Development for Company
o Production line efficiency metrics
o Quality control indicators
o Material usage and waste metrics
o Labor efficiency metrics
o Inventory turnover visualization
o Supply chain performance indicators
Afternoon Session (1:30 PM - 5:00 PM)
Advanced Dashboard Techniques
o Interactive filtering strategies
o Drill-down capabilities
o Cross-filtering
o Performance optimization
o Hands-on Exercise: Creating an interactive prototype
Systems Integration
o Connecting with ERP systems
o MES (Manufacturing Execution System) integration
o Real-time data processing
o API connectivity patterns
o Error handling and failover strategies
Day 3: Specialized Tracks
Track A: Tableau Advanced Implementation (8:00 AM - 5:00 PM)
Morning Session:
Advanced Tableau Features
o Custom calculations and LOD expressions
o Advanced mapping for facility visualization
o Parameter actions
o Advanced dashboard interactivity
Tableau Collaboration and Version Control
o Team development workflow
o Version control best practices
o Documentation standards
o Change management procedures
Afternoon Session:
Tableau Server and Enterprise Features
o Publishing and sharing
o Row-level security
o Automated refreshes
o Monitoring and maintenance
o Final Project: Complete production monitoring system in Tableau
Track B: Power BI Advanced Implementation (8:00 AM - 5:00 PM)
Morning Session:
Advanced Power BI Development
o DAX calculations
o Power Query transformations
o Custom visuals
o Advanced filtering and bookmarks
Power BI Collaboration and Version Control
o Workspace collaboration
o Version control strategies
o Documentation standards
o Change management procedures
Afternoon Session:
Power BI Service and Enterprise Features
o Gateway configuration
o Workspace administration
o Incremental refresh
o Monitoring and maintenance
o Final Project: Complete production monitoring system in Power BI