Microsoft Power BI
Intermediate Training
Microsoft Power BI is an essential tool for creating impactful data visualisations, whether for business reports, financial analysis, or performance dashboards. With the right training, your team can fully leverage Power BI’s features, producing engaging and professional visuals that effectively communicate insights and captivate their audience.
From ÂŁ199 per person
Discounts for groups of 6+
Discounts for groups of 6+
Onsite
Live online
1 day
Explore Microsoft Power BI training courses tailored for all skill levels, from beginner to advanced and specialised topics. Our flexible onsite and live online sessions accommodate groups as small as 2 participants and up to 20, providing a personalised learning experience for all.
What you will learn
Learn to use the Power Query Editor for tasks like grouping tables, splitting columns, and applying date functions, as well as advanced techniques in the Query Editor.
Master fuzzy matching joins to fix data inconsistencies, apply logical column functions, and build relationships within your datasets.
Gain proficiency in editing and simplifying DAX measures, including the CALCULATE function, and learn to use logical functions and iterators like SUMX and RANKX.
Explore advanced visualisations by importing custom visuals and creating dynamic content, while also implementing row-level security for data access management.
Prerequisite
Before joining this course, you should have hands-on experience with Power BI Desktop and a solid understanding of its reporting features. If you’re new to Power BI, we recommend completing the 2-day introductory course first.
7 lesson covers:
Power Query Editor and Data Preparation
Gain proficiency in the Power Query Editor, focusing on techniques such as grouping tables, splitting columns into rows by delimiters, and applying date functions. Learn to navigate the Advanced Query Editor for more complex data manipulations.
Data Matching and Transformation
Understand fuzzy matching joins to resolve data inconsistencies, including matching by percentage and using transformation tables to standardize data entries.
Logical Functions and Database Relationships
Explore logical column functions using sample datasets like Contoso, and learn to create and manage database relationships. Develop skills in constructing logical functions (IF, AND, OR) and nesting conditions for advanced data analysis.
Mastering DAX Measures
Learn to edit DAX measures to enhance readability and functionality, including adding comments and using quick measures to streamline calculations.
Advanced DAX Functions
Delve into the CALCULATE measure, understanding its anatomy and how to apply filters. Explore the ALL measure for filtering and percentage calculations, and how to use CALCULATE with thresholds for context-specific analysis.
Date Functions and Time Intelligence
Discover DAX date and time functions, including creating the DATEDIFF function. Learn to implement time intelligence measures to compare historical data, create DATEADD measures, and visualise cumulative totals effectively.
Enhanced Visualisations and Security Measures
Explore advanced visualisation techniques, including importing custom visuals and utilising report themes. Learn to create dynamic content, such as KPIs and visual titles, while implementing row-level security to manage data access across user profiles.
