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
Lesson 1. Importing Files
1.1. Importing a folder of files
1.2. Methods of connecting to data
1.3. Managing file connections
Lesson 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
Lesson 3. Merging Queries
3.1. Query join types
3.2. Combining tables
Lesson 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
Lesson 5. Pivoting tables
5.1. Clean tables by pivoting
5.2. Pivot but don’t aggregate
Lesson 6. Data Modelling
6.1. The concept of data models
6.2. Relationship properties
Lesson 7. DAX New Columns
7.1. Creating DAX columns
7.2. The SWITCH function
Lesson 8. DAX measures
8.1. Anatomy of DAX measures
8.2. Insert a DISTINCTCOUNT
8.3. Insert a CALCULATE
Lesson 9. The SUMX measure
9.1. What is an iterator?
9.2. Insert a SUMX iterator
9.3. When to use X-functions
Lesson 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
Lesson 11. Drilling into Data
11.1. Setting up a visual hierarchy
11.2. Drilling into layers of data
Lesson 12. Group Data
12.1. Compare data in groups
12.2. Groups in visualisations