Power BI Advanced

One day course

Course Overview

This advanced course takes a deep dive into creating visualisations that incorporate AI to greatly enhance your data analysis experience. Works with the Analytics pane to spot trends, and looks at configuring anomaly detection, that helps you understand whether you have quality issues in your data. It includes key influencer visuals, as the name suggests, the key influencers allows you to understand the factors that drive a certain 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 that allow you to predict future behaviour patterns in your data, and explains how to use DAX to generate a date tables that gives you greater control over Power BI’s built-in time intelligence features

Prerequisite

The assumption is that you are already using Power BI on a regular basis, and have an understanding of the process of analysing data, writing DAX, and building dashboards. If not, then we recommend taking the 2-day Power BI Intermediate course before attending this one.

Course Content

Lesson 1. Dataset Design

1.1. Data profiling

1.2. Dataset planning

1.3. Data transformations

Lesson 2. Using Parameters

2.1. Configuring parameters

2.2. Using parameters

Lesson 3. Field 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. Configuring 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. Customising Q&A

7.1. Tweak your data for Q&A

7.2. Sharing Q&A synonyms

Lesson 8. AI Capabilities

8.1. Generate insights

8.2. The analyse feature

8.3. Key influencer visual

8.4. Decompression visual

8.5. The narrative visual

Lesson 9. AI Features in Charts

9.1. Distribution differences

9.2. Explain differences

Lesson 10. DAX Date Tables

10.1. Controlling time intelligence

10.2. Generating date tables

10.3. CALENDAR function

10.4. CALENDARAUTO function