Power BI Fundamentals Workshop Agenda

Auckland | Monday, 14th - Tuesday, 15th May  
Wellington | Thursday, 17th - Friday, 18th May 

  • Creating your first Power Pivot Model 
  • Mapping tables 
  • Joining multiple tables together and understanding relationships 
  • Creating a Calendar Table
  • Utilizing a Calendar Table
  • Advanced PivotTable Reporting
  • Pivot Charts
  • Power Map
  • 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 
  • 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

Auckland | Monday, 14th - Tuesday, 15th May  
Wellington | Thursday, 17th - Friday, 18th May 

  • Exploring the User Interface 
  • Power Query techniques 
  • How to “un-pivot” data 
  • 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
  • Power BI Desktop 
  • A comparison with Excel 
  • An overview of the graphical interface 
  • Custom Visualizations 
  • Power BI.com. 
  • Publishing and Sharing your dashboards