Power BI Intermediate
Two day course
Course Overview
This course builds on the Microsoft Power BI Introduction two-day course and is aimed squarely at users seeking to explore the more advanced elements of Power BI Desktop. The course maintains a balanced, yet in-depth look at data analysis that includes working with inconsistent data in the Power Query Editor. It takes a deep dive into writing DAX formulas to enhance reports, followed by a look at creating dynamic, interactive dashboards that aid users to better understand the data they are analysing.
The aim of this course is to provide a more comprehensive understanding of the analytical process by working with business examples that will equip participants with the necessary skills to enhance reports and explore Power BI’s capabilities in more depth.
Prerequisite
Before attending this course, you should already be working with Power BI Desktop and understand its reporting capabilities. If not, then we suggest taking the 2-day introductory course before attending this one.
Course Content
Day one
Lesson 1. Power Query Editor
1.1. Grouping data
1.2. Split columns into rows
1.3. Date calculations
1.4. Advanced query editor
Lesson 2. Fuzzy Matching
2.1. Matching inconsistent data
2.2. Transform inconsistent data
Lesson 3. Logical Functions
3.1. Create a FIND function
3.2. IF, AND, OR functions
3.3. Nesting functions
Lesson 4. Editing DAX
4.1. Making DAX easier to read
4.2. Add comments to measures
4.3. Using Quick Measure
4.4. AI in Power BI
Lesson 5. CALCULATE
5.1. Anatomy of CALCULATE
5.2. CALCULATE filters
5.3. CALCULATE and FILTER
5.4. CALCULATE with thresholds
Lesson 6. The ALL Measure
6.1. Anatomy of ALL
6.2. Using ALL as filter
6.3. Using ALL for percentages
Lesson 7. Iterator Measures
7.1. Anatomy of iterators
7.2. SUMX iterator
7.3. RELATED in SUMX
7.4. Rank items with RANKX
7.5. RANKX with ALL
Lesson 8. Date Functions
8.1. Overview of date functions
8.2. DAX columns vs. measures
8.3. DATEDIFF function
Day two
Lesson 9. Time Intelligence
9.1. Compare historical data
9.2. Compare monthly data
9.3. DATEADD function
9.4. Creating a rolling total
9.5. Historical cumulative totals
9.6. Charting cumulative totals
Lesson 10. More Visualisations
10.1. Import custom visuals
10.2. Scale formats in themes
10.3. Conditional formatting
10.4. Navigation buttons
10.5. Applying static filters
10.6. Group text with Lists
10.7. Group numbers with Bins
10.8. Create a scatter chart
10.9. Analyse chart trends
Lesson 11. Dynamic Content
11.1. Create dynamic KPIs
11.2. Dynamic visual titles
11.3. Adding navigation buttons
11.4. Adding bookmarks
11.5. Customised tooltips
11.6, Customised slicers
Lesson 12. Row Level Security
12.1. Control user access
12.2. Setting up RLS
12.3. Adding permissions
12.4. Testing RLS
