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

Marwa Atafi has over ten years of experience in IT, including several strategic projects in business intelligence and decision support systems. Before arriving in Quebec, she taught a wide range of IT subjects and led complex projects, from needs assessment to the implementation of analytical solutions. She has in-depth expertise in Business Intelligence, covering all stages: requirements analysis, data modeling, design, and deployment of interactive dashboards. She is proficient with tools and technologies such as Power BI, Power Apps, Power Automate, SQL Server, ETL (SSIS), and advanced Excel, as well as results-oriented project management methods. Responsible, motivated, and passionate about her field, Marwa stands out for her technical skills and analytical mindset, making her a sought-after and strategic resource.

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.

Emna Labidi

Trainer

Emna Labidi holds a bachelor’s degree in management information systems. She has an international background, having led digital transformation projects in eight countries and supported over 500 organizations in adopting technological solutions. She began her career teaching and training others in digital tools before moving into leadership roles in information technology and project management related to educational technology. Certified as a “trainer of trainers” in 2022, she stands out for her ability to design and facilitate innovative educational programs tailored to diverse contexts, using a human-centered, structured, and impactful approach. A specialist in digital tools and an expert in Microsoft 365, Power BI, and learning management systems (LMS), she now works at AFI École des organisations. She leverages her expertise to help teams and organizations by delivering training that encourages technology adoption, enhances collaboration, and strengthens operational efficiency.

Nour Khalifa

Trainer

With a solid background in management IT and holding a Bachelor’s degree in IT Management as well as a Master’s in Artificial Intelligence and Information Technologies, Nour Khalifa supports organizations in developing the digital skills of their teams. She leverages her technical and pedagogical expertise to design and deliver practical, engaging, and learner-centered training programs. Before joining Afi U., Nour held strategic roles such as database administrator, business analyst, and project manager, working in complex technological environments. This experience enables her to offer practical solutions and effectively connect theory to practice. Recognized for her rigor and ability to simplify technical concepts, Nour favors interactive approaches that encourage the adoption of digital tools and skills development. She firmly believes that mastering management technologies is a key driver for performance and professional fulfillment.

Human

Digital Tools

Technology

Data Science

Organizational Strategy

Project Management

Change region

Power BI - Discover Power Query and dynamically connect your data

Upcoming sessions

Course outline

Surround yourself with the best