New

Power BI - Discover Power Query and dynamically connect your data

Get to know better Microsoft Excel and Power BI data models with the M fornula language reference.

Upcoming sessions

Show all sessions

Guaranteed to run

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

Course outline

Duration : 1 day

© AFI par Edgenda inc.
This training course is aimed at data analysis professionals and BI experts who want to deepen their knowledge of Microsoft Excel and Power BI data models using the M language to connect different data sources, transform data and optimize data models within their organization.
Audience	This training course is aimed at data analysis professionals and BI experts who want to deepen their knowledge of Microsoft Excel and Power BI data models using the M language to connect different data sources, transform data and optimize data models within their organization.
Prerequisites	Completion of at least Excel or Power BI training.
Objectives	Transforming data with Power Query Use the M language Combining data from different sources Explaining data refreshment Learn how to use relationships effectively Distinguish between the effects of active and inactive relationships.
Teaching method	Lectures - Demonstrations - Guided and individual exercises
Contents	Chapter 1 - Confirming fundamental M concepts Using the M language Discover the differences between Excel and Power BI Understanding the Power Query editor Learn how to document Power Queries Set up a naming convention Using variables
	Chapter 2 - Querying data sources Understanding data access functions Discovering the impact on data refreshing Optimizing data querying
	Chapter 3 - Editing queries Using the M language and the advanced editor Using the main binary functions Using the main association functions Using the main comparison functions
	Chapter 4 - Using advanced queries Using date and time functions Using DateTimeZone functions Using duration functions Learn to use error functions
	Chapter 5 - Using query parameters Creating parameters in your queries Learn how to use the Power BI model with parameters Discover how to diagnose errors
	Chapter 6 - Creating a date table Use variables to define bounds Use functions to create references Apply the necessary transformations Properly document your code
	Chapter 7 - Optimizing the relationship diagram Understanding the impact of active and non-active relationships Understand the meaning of filtering and how to use it Learn how to define an optimal relationship model
	Chapter 8 - Applying best practices Applying the right references Define your best practices

Related courses
Excel - Discover Power Query and dynamically connect your data \| AFI Expertise		.

Surround yourself with the best

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.

Nicolas Georgeault

Trainer

My presence among the Microsoft community over the last 25 years has earned me the title of MVP 13 times by Microsoft. I particularly appreciate the space that's offered to explain things in a simple way and to ensure that knowledge is updated according to transformations. After all these years, I can say that my great understanding of the platforms enables me to anticipate their evolution while keeping a pragmatic eye on the challenges that come with this modernization. For these reasons, I am pleased to be part of our Microsoft training program.

Benjamin Ejzenberg

Trainer

Benjamin has over 8 years of experience in different institutions in Canada and Europe as an expert in data analytics. Besides having an expertise in the Power Platform (Power BI, Power Apps and Power Automate), he masters Python, SQL and data science's tools. He holds several certifications such as PL-300 (Microsoft Power BI Data Analyst).

Frédéric Paradis

Certified Trainer and Cloud Architect

As a certified Microsoft trainer, Frédéric describes himself as a Cloud magician who easily navigates the mythical space between technology and reality.