Power BI Advanced
Duration: 1 day
Course Overview
This course explores advanced visuals that use AI to enhance data analysis. You’ll learn how to spot trends with the Analytics pane, configure anomaly detection, and use key influencer visuals to identify what drives important metrics. It covers using parameters to simplify how you work with connected source data and “what‑if” analysis parameter. Incorporate forecasting tools predict future outcomes and creating UDFs (User Defined Functions) to streamline repeated DAX logic.
Prerequisite
The assumption is that you are already using Power BI on a regular basis and understand the processes of analysing data, writing DAX and creating visuals. If not, then we recommend taking the 2-day Power BI Intermediate course before this one.
Course Content
Lesson 1. Data Model Design
1.1. Data profiling
1.2. Data model planning
1.3. Data transformations
Lesson 2. Using Parameters
2.1. Configuring parameters
2.2. Inserting parameters
Lesson 3. Dynamic Parameters
3.1. Numeric parameters
3.2. Field parameters
Lesson 4. Group, Bin & Cluster
4.1. Creating groups
4.2. Creating bins
4.3. Creating clusters
4.4. Multivariate cluster
Lesson 5. Forecast Charts
5.1. Configure forecast charts
5.2. Assigning forecast units
5.3. Confidence intervals
Lesson 6. The Analytics Pane
6.1. Finding anomalies
6.2. Detecting outliers
Lesson 7. AI Capabilities
7.1. Generate insights
7.2. The Analyse feature
7.3. Power BI AI Visuals
7.4. Key Influencer visual
7.5. Decompression Tree
7.6. The Narrative visual
7.7. Explaining differences
Lesson 8. AI in Charts
8.1. Distribution differences
8.2. Explaining differences
Lesson 9. Visual Calculations
9.1. Insert a Visual Calc
9.2. Built in templates