Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Day 1 – Fundamentals and Data Modeling
- Introduction to Power Pivot and the importance of data models in manufacturing
- Connecting to multiple data sources and importing into Power Pivot
- Creating relationships between tables for complex models
- Introduction to the DAX (Data Analysis Expressions) language for calculations and KPIs
- Aggregation and calculation of performance indicators in Power Pivot
Day 2 – Advanced Analysis and KPI Reporting
- Creating advanced measures and calculated columns using DAX
- Analyzing production performance and calculating complex KPIs
- Building integrated data models for reporting and dashboards
- Optimizing models for large data volumes
- Best practices for data-driven decision-making in manufacturing processes
Expected outcomes:
- Ability to create complex data models in Power Pivot for production
- Calculation of advanced KPIs and analysis of production line performance
- Integration of data models into Excel and dashboards for efficient reporting
- Implementation of data models for data-driven decisions in industrial processes
Requirements
- Understanding of: data models, table relationships, and complex analyses in manufacturing
- Experience with: Excel, Power Pivot, KPI analysis, and industrial data management
- Programming experience: basic knowledge of DAX (Data Analysis Expressions) – optional
- Target audience: production engineers, data analysts, operational managers, process specialists
- Covered topics: creation and management of complex data models in Excel
- Covered topics: KPI calculation and production performance analysis
- Covered topics: integration of data models into dashboards for decision-making
14 Hours
Testimonials (3)
Practical and hands on labs on report developmemt using Power BI The labs were excellent and the trainer offered very good hands on sessions
Sinzala Sichaanji - Bank of Zambia
Course - Mastering Power Platform: Power Apps, Power Automate, DataVerse, Power BI, and Power Virtual Agents
We did quite complex examples, so we could get a feeling of how the real work with Power Automate Desktop can look like in the real world scenario.
Michal Strnad - MicroNova AG
Course - Microsoft Flow/Power Automate
Dynamic, adaptive, and informative