Power BI Intermediate Training

Lesson 1. Importing Files, Importing a database, Import vs. Direct Query vs. Live Connection, Import a folder of files, Managing imported file connections

Lesson 2. Shape Data in the Query Editor, Add a custom column, Appending tables together, Prevent tables loading in reports, Fixing error issues, Perform math calculations

Lesson 3. Merge Queries, Table join kinds, Merging tables

Lesson 4. Conditional and Custom Columns, The M functions, Adding conditional columns, Custom column formulas, Merging columns, Creating text functions, Creating IF functions, Query group folders

Lesson 5. Pivoting Tables, Pivot a table, Pivot data but don’t aggregate, Appending mismatched headers

Lesson 6. Data Modelling, Data model relationships, Marking calendar tables

Lesson 7. DAX New Columns, Creating DAX columns, The SWITCH function, Including TRUE within SWITCH

Lesson 8. Writing DAX Measures, The COUNT measures, The DIVIDE measure, DAX rules

Lesson 9. The CALCULATE Measure, Understanding CALCULATE filters, Add Context to CALCULATE with FILTER, Controlling field summarisation

Lesson 10. The SUMX Measure, The “X” iterator functions, Anatomy of SUMX, Create a SUMX measure, When to use “X” functions

Lesson 11. Time Intelligence Measures, Importance of a calendar table, Changing financial year end in TOTALYTD, Viewing date calculations in charts, Compare historical data with DATEADD

Lesson 12. Dashboard Visualisations, Utilising report themes, Filtering across dashboards, Data mining with hierarchies, Compare data in groups, Adding conditional formatting

Lesson 13. Power BI Service, Getting quick insights, What is Q&A?, Publish reports in SharePoint