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 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

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories