Course description
This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations.
Upcoming start dates
Suitability - Who should attend?
Managers and others who need to use or create reports and tables to support business management and decision-making.
Our assumption is you are already a Power BI Desktop user and are comfortable with the fundamentals. If not, we recommend attending the 2-day Introduction to Power BI course first.
Outcome / Qualification etc.
Training Course Content
1 The Query Editor
- Grouping rows in a table
- Split row by delimiter
- Add days to determine deadlines
- The query editor
2 Fuzzy Matching Joins
- Matching inconsistencies by percentage
- Matching with transformation table
3 The Query Editor M Functions
- Adding custom columns
- Creating an IF function
- Nested AND logics in an IF function
4 DAX New Columns Functions
- Including TRUE with SWITCH
- Using multiple conditions
- The FIND DAX function
- The IF DAX function
- Logical functions IF, AND, OR
5 Editing DAX Measures
- Making DAX easier to read
- Add comments to a measure
- Using quick measures
6 The Anatomy of CALCULATE
- Understanding CALCULATE filters
- Add context to CALCULATE with FILTER
- Using CALCULATE with a threshold
7 The ALL Measure
- Anatomy of ALL
- Create an ALL measure
- Using ALL as a filter
- Use ALL for percentages
8 DAX Iterators
- Anatomy of iterators
- A closer look at SUMX
- Using RELATED with SUMX
- Create a RANKX
- RANKX with ALL
9 Date and Time Functions
- Overview of functions
- Create a DATEDIFF function
10 Time Intelligent Measures
- Compare historical monthly data
- Create a DATEADD measure
- Creating cumulative totals
- Creating cumulative measures
- Visualising cumulative totals
11 Visualisations In-Depth
- Utilising report themes
- Applying static filters
- Group data using lists
- Group numbers using bins
- Creating heatmaps
- Comparing proportions
- View trends with sparklines
12 Comparing Variables
- Visualising trendlines as KPI
- Forecasting with trendlines
- Creating a scatter plot
- Creating dynamic labels
- Customised visualisation tooltips
- Export reports to SharePoint
Course delivery details
A very practical, interactive two-day session for a maximum group size of 8. Comprehensive materials provided, including exercise files and a unique step-by-step guide developed by the trainer specifically for this programme.
This course can be run remotely online or face-to-face onsite.
Request info
The In-House Training Company
We offer top-quality in-house training, in a wide range of subjects, at sensible prices. All of our programmes are delivered by independent subject specialists who also have outstanding training skills. We have rigorous standards and only work with the very...