Power BI - Transforming data models with DAX - Training Courses | Afi U.

Back to catalogue

New

Power BI - Transforming data models with DAX

Learn how to use the Data Analysis Expression (DAX) language to perform transformations and calculations.

Microsoft Partner

Upcoming sessions

No date suits you?

Notify me when a session is added.

Duration: 1 day
Regular price: $500
Preferential price: $440

No date suits you?

Notify me when a session is added.

Course outline

Duration : 1 day

© AFI par Edgenda inc.

The aim of this training course is to enable advanced users of Microsoft Excel and Microsoft Power BI to use the DAX (Data Analysis Expression) language to perform transformations and calculations to adapt their data sets to produce reports and dashboards.
Audience	Data analysis professionals and BI experts who want to deepen their knowledge of Microsoft Excel and Power BI data models with the DAX language to transform data and optimize data models within their organization.
Prerequisites	Completion of at least the Logic and Time Functions course or equivalent for Excel Adapting the data model with DAX in the Power BI course
Objectives	Modify data models using the DAX language Learn more about basic DAX functions
Teaching method	Lectures - Demonstrations - Guided and individual exercises
Contents	Chapter 1 - Confirming fundamental concepts DAX Use the DAX (Data Analysis eXpression) language Discover the differences between Excel and Power BI Understanding the DAX context Review calculated measures and columns Setting up naming conventions Using variables
	Chapter 2 - Reviewing the main functions Handling text Set up logic functions Using time functions Exploiting information functions Creating data tables Manipulating table structures Formatting operation blocks
	Chapter 3 - Setting up filters and sorting Setting up a filter Learn how to cancel filters Apply calculations with filters Track existing relationships between tables Understand how to set up filter tests
	Chapter 4 - Counting with DAX Using counting functions Counting table rows Use unique counting functions
	Chapter 5 - Using loops Understanding the use of iterative functions Building complex iterative functions Creating measurements with DAX Handling filters with the CALCULATE function Working with time functions
	Chapter 6 - Optimizing the data model Review data model performance Using variables to improve performance Reduce cardinality
	Chapter 7 - Applying best practices Using error functions Applying the right references Define your best practices

Surround yourself with the best

Marwa Attafi

Marwa Attafi

Trainer

I accumulated more than 10 years of experience in IT before coming to Quebec. I have taught computer science and have been in charge of several business intelligence projects and computer science projects to help with decision support. I have a strong experience as an analyst of business intelligence solutions, ranging from the specification and analysis of needs to the generation of dashboards. My passion for this job, my great technical skills and my sharp analytical mind add to my skills to make me a valued and precious resource for my organization.

Sofiane Bounif

Sofiane Bounif

Trainer

Sofiane is an experienced consultant in data analysis and visualization, specializing in harnessing the power of Microsoft Power BI to help businesses leverage their data effectively.