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 within 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 and takes a deep dive into writing DAX formulas to greatly improve a reports capability.
It includes creating dynamic, interactive dashboards and includes features that aid a user to better understand the data they are analysing. The aim is to provide a more comprehensive understanding of the analytical process by working with business examples that will equip you with the necessary skills to build more enhanced reports.
Prerequisite
Before attending this course, you should already be working with Power BI and understand the concept of creating reports. 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. Match Inconsistent Data
2.1. Match mismatched 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 Measure
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 measure
Day two
Lesson 9. Time Intelligence
9.1. Compare monthly data
9.2. DATEADD function
9.3. Creating a rolling total
9.4. Historical cumulative totals
9.5. 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