Data Analysis Expressions (DAX) are a library of functions and operators that can be combined to build formulas and expressions in Power BI. In this intermediate level course, participants will explore how to use DAX to analyse their data. We will explore how to analyse trends over time, create moving averages and moving totals, as well as the art of static grouping to organise and analyse data on predefined categories. On completion of their training, participants should be ready to start harnessing the capabilities of DAX for better insights.
This course is designed for intermediate to advanced Power BI users who are looking to use DAX to create new information from their existing data.
By actively participating in this course, you will learn about the following:
Calculate and visualise percentages relative to the total.
Smooth data fluctuations, identify trends, and make informed decisions by calculating moving averages.
Proficiently track cumulative data progression over time.
Unlock the potential of time-based analysis with dedicated time intelligence functions.
Use static grouping based on predefined criteria to segment and interpret information.
Use parameter tables to introduce flexibility and dynamic behaviour into your Power BI models.
As this is an intermediate course, participants should have a fundamental understanding of Power BI, including the ability to navigate the Power BI interface, load data, and create basic visualisations. A basic understanding of data modelling concepts, including relationships between tables is also required.
We recommend that you attend our Microsoft Power BI Fundamentals Part 1 course or have equivalent skills and knowledge.
Participants should also be familiar with the basics of Data Analysis Expressions (DAX), as the course will delve into advanced DAX functions for calculations and analysis.
Software Requirements for Virtual Classroom
If you are attending our Virtual Classroom training, you will need a laptop or PC with a working microphone and two screens. A webcam is also recommended for the best experience! You will also need to have both Power BI Desktop and Power BI Service (part of Microsoft 365 Apps), available on your device.
PowerBI Service is what Microsoft call the version of PowerBi found in their M365 subscription list of apps. It wont be there as a default and is something your Microsoft 365 administrator would have to enable. It is free of charge and literally just a tick box. They will need access to this as this is where reports are published to and the only place where Dashboards can be created. Plus, all of the sharing and collaboration options are to be found here.
We strongly recommend that delegates also check that their PC meets the Minimum Requirements as outlined on the Microsoft Website in order to run Power BI effectively. Please note however that although Microsoft recommend 4GB of memory (RAM), in our experience it is advisable to have at least 8GB available to reduce slow upload times and the possibility of a PC crashing during the course.
This course is not suitable for MAC users.
Percent of Total
Data Analysis Expressions covered include: