Power BI - intermediate (2 day) (In-House)

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