Registration and Welcome Coffee 

Start of Workshop Day 1

Power Pivot Introduction

  • Creating your first Power Pivot Model 
  • Mapping tables 
  • Joining multiple tables together and understanding relationships 

Morning Break

Power Pivot Introduction

  • Creating a Calendar Table
  • Utilizing a Calendar Table
  • Advanced PivotTable Reporting
  • Pivot Charts
  • Power Map

Networking Lunch

In-depth Power Pivot Models 

  • Creating more complex Power Pivot models 
  • Calculated Columns 
  • Introducing DAX formulas and Calculated Fields (Measures) 
  • Filters and Slicers 
  • Improve the user experience through Hiding and Hierarchies 
  • Pitfalls to avoid 

Afternoon Break

In-depth Power Pivot Models 

  • How to build in checks to detect new data or imbalances 
  • Creating useful time based measures with more advanced DAX formulas 
  • CALCULATE explained
  • CUBE formula
  • KPIs

End of Workshop Day 1 

Welcome Coffee 

Start of Workshop Day 2

Power Query 

  • Exploring the User Interface 
  • Power Query techniques 
  • How to “un-pivot” data 

Morning Break

In-Depth Power Query 

  • How to merge multiple sources into one table
  • Using variables for query parameters
  • Introduction to the Advanced Editor and M language
  • Creating re-usable custom functions
  • Calendar Creator

Networking Lunch   

Power BI Desktop & POWERBI.com 

  • Power BI Desktop 
  • A comparison with Excel 
  • An overview of the graphical interface 
  • Custom Visualizations 

Afternoon Break

Power BI Desktop & POWERBI.com 

  • Power BI.com. 
  • Publishing and Sharing your dashboards

End of Workshop 

Registration and Welcome Coffee 

Start of Workshop Day 1

Power Pivot Introduction

  • Creating your first Power Pivot Model 
  • Mapping tables 
  • Joining multiple tables together and understanding relationships 

Morning Break

Power Pivot Introduction

  • Creating a Calendar Table
  • Utilizing a Calendar Table
  • Advanced PivotTable Reporting
  • Pivot Charts
  • Power Map

Networking Lunch

In-depth Power Pivot Models 

  • Creating more complex Power Pivot models 
  • Calculated Columns 
  • Introducing DAX formulas and Calculated Fields (Measures) 
  • Filters and Slicers 
  • Improve the user experience through Hiding and Hierarchies 
  • Pitfalls to avoid 

Afternoon Break

In-depth Power Pivot Models 

  • How to build in checks to detect new data or imbalances 
  • Creating useful time based measures with more advanced DAX formulas 
  • CALCULATE explained
  • CUBE formula
  • KPIs

End of Workshop Day 1 

Welcome Coffee 

Start of Workshop Day 2

Power Query 

  • Exploring the User Interface 
  • Power Query techniques 
  • How to “un-pivot” data 

Morning Break

In-Depth Power Query 

  • How to merge multiple sources into one table
  • Using variables for query parameters
  • Introduction to the Advanced Editor and M language
  • Creating re-usable custom functions
  • Calendar Creator

Networking Lunch   

Power BI Desktop & POWERBI.com 

  • Power BI Desktop 
  • A comparison with Excel 
  • An overview of the graphical interface 
  • Custom Visualizations 

Afternoon Break

Power BI Desktop & POWERBI.com 

  • Power BI.com. 
  • Publishing and Sharing your dashboards

End of Workshop 

Related events

Share this page

TOP