Get in Touch

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

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories