.jpg)
About this course
This training is ideal for individuals who already have a basic understanding of Power BI and want to deepen their knowledge of data modelling, transformation, and advanced analytics. Learn how to optimise your datasets, build efficient data relationships, and create insightful reports using advanced DAX functions.
- Explore advanced data transformation techniques with Power Query.
- Learn how to model data effectively using star schema principles.
- Master DAX functions to create complex calculations and measures.
- Enhance reports with advanced filtering, slicers, and interactive visuals.
- Learn best practices for structuring and optimising Power BI reports.
The Microsoft Power BI - Intermediate Course is designed to take your skills beyond the basics, helping you become proficient in data structuring, performance optimisation, and in-depth analysis. Whether you're looking to enhance your reporting capabilities or develop advanced analytics, this course will provide you with the tools and techniques needed to create powerful, data-driven insights.
Key Highlights:
✔ Hands-on learning with real-world scenarios.
✔ Step-by-step guidance from industry experts.
✔ Covers Power Query, Data Modelling, DAX, and Best Practices.
Suggested by top companies
Top companies suggest this course to their employees and staff.
.png)
Requirements
Have a Windows PC (Power BI does not work on Mac)
Have a stable internet connection
Have the latest version of Power BI installed on your computer
Related Courses
FAQ
Comments (0)
Kick-Off & Introduction: Overview of training objectives.
Data Importation: Exploring data connectors, Direct Query vs. Import Mode.
Power Query & Data Cleaning:
Applied steps and transformations.
Using headers, changing data types, sorting, and filtering.
Removing duplicates, errors, and unwanted columns.
Adding and splitting columns, merging and appending queries.
Data Modelling & Relationships:
Understanding star schema (fact and dimension tables).
Creating relationships and managing filter propagation.
Implementing date tables and handling column visibility.
Practical Exercises: Hands-on application of learned concepts.
Filters, Slicers & Visual Interactions: Managing filters, Top N analysis, synchronising slicers, and enhancing visual organisation.
Tables, Columns & Measures:
Introduction to DAX (Data Analysis Expressions).
Creating new columns, tables, and quick measures.
Best practices in organising calculations.
Advanced DAX Calculations:
Aggregations (SUMX), logical functions (IF, SWITCH).
Filtering (CALCULATE, ALL, FILTER).
Time intelligence (DATEDIFF, DATEADD, DATESYTD).
Practical Exercises: Applying DAX functions in real-world scenarios.
Best Practices & Power BI Resources
.png)
