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 them into Power Pivot
- Creating relationships between tables for complex models
- Introduction to the DAX (Data Analysis Expressions) language for calculations and KPIs
- Aggregating and calculating 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 high 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
- Calculating advanced KPIs and analyzing production line performance
- Integrating data models into Excel and dashboards for efficient reporting
- Implementing 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
- Topics covered: creation and management of complex data models in Excel
- Topics covered: calculation of KPIs and production performance analysis
- Topics covered: integration of data models into dashboards for decision-making
14 Hours
Testimonials (2)
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