Part 2: Power BI Advanced Features

Jump to dates


1 Days


Learning Objectives
After successfully completing our Part 1 Power BI Essentials course.


Delegates will learn how to:

  • Power Query – Transform Data     
  • Data Model – Manage        
  • DAX Formulas        
  • Building Dynamic Reports  
  • Visualisations          
  • Power BI Service


Part 1: Power BI Essentials

1. Power Query – Transform Data    

  • More Transformations
  • Merge Queries, Append Queries
  • Connect to other Data Sources

2. Data Model – Manage       

  • Using Calendar Tables to enable Time Intelligence
  • Group Items (Group/Bin)

3. DAX Formulas       

  • Popular DAX Functions (COUNTROWS, RELATED…)
  • Override Filters (CALCULATE, ALL etc.)
  • Time Intelligence (YEAR-TO-DATE etc.)

4. Building Dynamic Reports 

  • Filtering and Slicers
  • Interactions between Visuals, Drill-Down
  • Other Visual Elements (Text Box, Shape, Image etc.)

5. Visualisations         

  • Formatting Visuals
  • Conditional Formatting
  • Custom Visuals

6. Power BI Service   

  • Workspaces and Sharing
  • Handling Datasets, Reports and Dashboards


Your Recommended Dates

GTR = Guarenteed to Run

Find out more about this course

Interested in alternative dates? Would like to book a private session of this course for your company? Or for any other queries please simply fill out the form below.