Power BI Advanced
2-day course
Course Overview
This course takes a deep dive into creating advanced visuals that incorporate AI to greatly enhance data analysis . It looks at the Analytics pane to spot trends and configuring anomaly detection, which helps you to understand whether you have quality issues in your data. It includes key influencer visuals, allowing you to understand the factors that drive a metric that you’re interested in.
Learn how to use parameters to ask ‘what if’ questions about your data and to consolidate multiple tasks. The course also looks at forecasting features to predict future behaviour patterns in and looks at using UDFs (User Defined Functions) to consolidate multiple DAX queries. It also include custom power KPI visuals to predict outcomes.
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 inserting visuals. If not, then we recommend taking the 2-day Power BI Intermediate course before attending this one.
Course Content
Day one
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 visual
7.6. The narrative visual
7.7. Explaining differences
Day two
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
Lesson 10. Power KPI Visual
10.1. KPI indicators
Lesson 11. Power KPI Matrix
11.1. Core fields
11.2. Core measures
11.3. Indicator measure
11.4. Hyperlink field
Lesson 12. DAX Query View
12.1. Query View environment
12.2. Simplifying measures
Lesson 13. UDF Functions
13.1. What are UDFs?
13.2. Why UDFs matter
Lesson 14. Composite models
14.1. Why they matter
14.2. Build a composite model