Description
Power BI Training Course Specification – Advanced Level
- The Best Practises for using Power BI.
- Data Model Designing
- Recap on the schema layouts.
- The advantages of a star schema.
- How to reduce your model down to a star schema.
- Data Model Optimisation.
- How Power BI stores data and how to use this to optimise your model.
- What is Query folding and its advantages.
- Advanced Data Transformations.
- Merging and Appending Data.
- Grouping data and Aggregations.
- Transposing vs Pivoting tables.
- Creating Custom Columns from scratch using M Query.
- Using AI Insights, including Text Analytics.
- Reducing the number of applied steps to a table.
- Mixed Mode Modelling
- Keeping your model tidy.
- Datasets and Data Flows
- What is a Data Flow?
- How to create a data flow and its advantages.
- Measure Optimisation
- When should we reference measures and when not?
- If vs Switch statements and Memory limitations.
- Calculating Columns using DAX vs Adding Columns in Power Query.
- Calculated Columns vs Measures and when should each be used.
- Using the Performance Analyzer effectively.
- Advanced Dax
- Creating and using variables.
- Date functions in measures.
- Creating tables inside your model. How to use CalculateTable(), Summarize() and SummarizeColumns() functions.
- Calculating tables inside your measures.
- Creating Ranking columns.
- Creating Ranking measures.
- Creating formatting and navigation measures.
- How to use Calculation Groups
- How to use New Parameters
- Can AI help me to write measures?
