Power BI Fundamentals Workshop Agenda

Brisbane | Thursday, 10th - Friday, 11th May 
Melbourne | Monday, 21st - Tuesday, 22nd May 
Sydney | Thursday, 24th - Friday, 25th 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

Brisbane | Thursday, 10th - Friday, 11th May 
Melbourne | Monday, 21st - Tuesday, 22nd May 
Sydney | Thursday, 24th - Friday, 25th 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