Power BI - Discover Power Query and dynamically connect your data - Training Courses | Afi U.

Back to catalogue

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.

Microsoft Partner

Upcoming sessions

Guaranteed to run

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.

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

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.