Power BI: Advanced

Take your Power BI skills to the highest level in our two-day, instructor led course. A deep dive into the advanced aspects of Power BI.
We can deliver this course on-line or in-room and for private courses we're happy to customise the content to ensure you get the training you need.

DAX

• Evaluation Context; understanding Row and Filter context
• Working with iterators (SUMX, AVERAGEX)
• The CALCULATE function
• Working with Table Functions: FILTER
• ALL & ALLSELECTED Functions
• Time Intelligence functions
• The SELECTEDVALUE Function
• Creating Dynamic Titles and Cards

Visualisations

• Enabling consumer personalization on visualisations
• The Decomposition Tree visual
• The Key Influencers visual
• The Smart Narrative visual
• Dynamic Tooltips and Tootltip pages
• Introduction to Charticulator
• Introduction to Deneb

Row Level Security (RLS)

• What RLS does
• Creating basic Row Level Security
• Dynamic Row Level Security based on User Login
• Advanced RLS patterns
• Power BI Administration

Power BI Governance

• Power BI Administration
• Security restrictions in Governance
• Statistics and Audit

Power Query

• Custom columns (writing your own M code)
• De-mystifying M in the Advanced Editor
  • Let, In, each

Power BI Dataflows

• What is a DataFlow ?
• Generating and using DataFlows
• Maintaining & Refreshing DataFlows
• Using Dataflows in Power BI Datasets
• Preview of Power BI DataMarts

Power BI Resources

• Power BI community resources
• Power BI Book, Videos, Blogs and other resources

Ideally, you’ll have taken our Power BI: Intermediate course or have used Power BI extensively for a year or more. You’ll have found times when you just can’t find what you want in the visualisations gallery OR in the custom visualisations. You’re confident with DAX and want to progress into advanced DAX areas. You’ll know what Row Level Security (RLS) is for and might have put it to use. You’ll be adept at massaging your data in Power Query and be looking to understand it on a deeper level before levelling up your data collection using Dataflows.