Microsoft Power BI
Introduction Training
Our two-day intermediate Power BI training course is designed for professionals seeking to deepen their understanding of data analysis and reporting. Building upon foundational skills, this course delves into advanced techniques using Power Query Editor and DAX (Data Analysis Expressions) to transform and model data effectively.
From £199 per person
Discounts for groups of 6+
Discounts for groups of 6+
Onsite
Live online
2 day
This intensive two-day course is designed for professionals seeking to deepen their expertise in Microsoft Power BI. Participants will engage in advanced data modelling techniques, leveraging DAX to create complex calculations and enhance report functionality. The course delves into sophisticated data transformation using Power Query, including handling inconsistent data and implementing fuzzy matching. Additionally, attendees will explore the creation of dynamic, interactive dashboards and gain insights into best practices for report design and performance optimisation.
By the end of this course, participants will possess the skills to develop comprehensive Power BI reports that provide actionable insights and support data-driven decision-making within their organisations.
Prerequisite
Prior to attending this advanced two-day Power BI training course, you should be proficient in using Power BI Desktop to connect to and transform data from various sources, as well as in creating and formatting reports. If you’re new to Power BI or need a refresher, we recommend completing our two-day introductory Power BI course first.
12 lesson covers:
Power Query Editor Techniques
Delve into advanced data transformation methods using the Power Query Editor. Learn to group data, split columns into rows, perform date calculations, and utilise the advanced query editor for complex data shaping.
Fuzzy Matching
Understand how to match and transform inconsistent data entries using fuzzy matching techniques, ensuring data consistency and reliability.
Logical Functions in DAX
Master the creation of logical functions such as FIND, IF, AND, and OR. Learn to nest functions for complex calculations, enhancing report interactivity and decision-making.
Editing DAX
Enhance the readability of DAX formulas by adding comments and using Quick Measures. Explore the integration of AI features within Power BI to automate and optimise data analysis.
Mastering CALCULATE
Delve into the CALCULATE function to modify filter contexts and perform advanced calculations. Learn to apply filters and thresholds within CALCULATE for precise data analysis.
The ALL Measure
Understand the ALL function’s role in removing filters, enabling comprehensive data analysis. Learn to use ALL for calculating percentages and applying filters effectively.
Iterator Measures
Explore iterator functions like SUMX and RANKX to perform row-by-row calculations. Learn to use RELATED and ALL within iterators for advanced data manipulation.
Date Functions
Gain proficiency in DAX date functions such as DATEDIFF. Understand the differences between calculated columns and measures, and learn to apply date functions for time-based analysis.
Day Two: Advanced Visualisation & Security
Time Intelligence
Learn to compare historical and monthly data using DAX time intelligence functions. Create rolling totals and cumulative charts to analyse trends over time.
Enhanced Visualisations
Discover techniques to import custom visuals, apply conditional formatting, and create interactive reports. Learn to use navigation buttons, slicers, and group data for effective visual storytelling.
Dynamic Content
Master the creation of dynamic KPIs, visual titles, and customised tooltips. Learn to add navigation buttons, bookmarks, and slicers to enhance user interaction and report functionality.
Row-Level Security (RLS)
Understand the principles of row-level security to control user access to data. Learn to set up RLS roles, add permissions, and test security configurations to ensure data confidentiality.
