Power BI Intermediate
Duration: 1 day
Course Overview
This course builds on the Introduction to Power BI one day course and is aimed at Power BI users seeking to explore reporting elements more in-depth. The course maintains a balanced look at the four main areas that make up Power BI and includes the Power Query Editor, DAX formulas, data modelling, and enhanced dashboard visuals.
Prerequisite
Our assumption is that you have either attended the introduction course or are a Power BI user and now want to move beyond the basics. If not, we recommend attending the Power BI Introduction course first.
Course Content
Module 1: Importing Files
1.1. Importing a folder of files
1.2. Methods of connecting to data
1.3. Managing file connections
Module 2: Power Query Editor
2.1. Cleaning imported files
2.2. Adding a custom column
2.3. Appending tables together
2.4. Hiding tables in reports
2.5. Fixing data error issues
2.6. Math calculations
Module 3: Merging Queries
3.1. Query join types
3.2. Combining tables
Module 4: Power Query Formulas
4.1. Add a conditional column
4.2. Add a custom column
4.3. Working with text functions
4.4. Insert an IF formula
4.5. Creating group folders
Module 5: Pivoting tables
5.1. Clean tables by pivoting
5.2. Pivot but don’t aggregate
Module 6: Data Modelling
6.1. The concept of data models
6.2. Relationship properties
Module 7: DAX New Columns
7.1. Creating DAX columns
7.2. The SWITCH function
Module 8: DAX measures
8.1. Anatomy of DAX measures
8.2. Insert a DISTINCTCOUNT
8.3. Insert a CALCULATE
Module 9: The SUMX measure
9.1. What is an iterator?
9.2. Insert a SUMX iterator
9.3. When to use X-functions
Module 10: Time Intelligence
10.1. Importance of a date table
10.2. Time intelligence functions
10.3. Insert a TOTALYTD function
10.4. Compare historical data
10.5. Insert a DATEADD function
10.6. Time intelligence in charts
Module 11: Drilling into Data
11.1. Setting up a visual hierarchy
11.2. Drilling into layers of data
Module 12: Group Data
12.1. Compare data in groups
12.2. Groups in visualisations