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.
