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

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 - Transforming data models with DAX

Upcoming sessions

Course outline

Surround yourself with the best