The "Mastering Power BI Desktop" training is an exceptional opportunity to develop a deep understanding and practical mastery of Power BI Desktop, Microsoft’s data visualization and analysis tool.

This intensive two-day course is designed for beginner and intermediate professionals eager to take full advantage of Power BI Desktop’s features. No prior experience with Power BI Desktop is required, although a basic familiarity with Excel and data concepts is beneficial for optimal learning.

Throughout this training, you will learn how to import data from various sources, transform and clean it to create reliable and actionable datasets. You will discover how to build dynamic visualizations and interactive reports that highlight key insights for your organization. In addition, you will become familiar with advanced Power BI Desktop functions such as DAX (Data Analysis Expressions) to create complex measures and calculations, and Power Query for automating data transformations.

Through hands-on exercises, detailed demonstrations, and real-world case studies, you will gain solid expertise in using Power BI Desktop. You will learn how to design visually appealing reports, leverage complex data models, and effectively share your analyses with both internal and external stakeholders.

By the end of this training, you will be able to design and deploy interactive dashboards, perform in-depth data analyses, and make informed decisions thanks to the powerful capabilities of Power BI Desktop.

Don’t miss this opportunity to master Power BI Desktop and transform your data into strategic insights to support your company’s objectives. Register now for this comprehensive training and dive into the world of advanced data analysis with Power BI Desktop.

Registration Details

Course details

Introduction to the Power BI Training

Review of Power BI Fundamentals

Power BI Desktop principles and workflow
Connecting to data with Power BI
Preparing data in the Power Query editor
Transformations in the Power Query editor
Creating folders / organizing in Power BI
Merging / combining queries in Power BI
Hands-on workshop: transforming imported data

Importing a Pivot Table (Excel)

Removing totals
Merging cells
Unpivoting columns

Modeling in Power BI

Relationships
Option configurations
Understanding cardinality

Data Model in Power BI

Flat table
Star schema
Relational model
Table layout
Workshop: create a star schema from an Excel file
Workshop: manage a relational model in Power BI

Date Table (Calendar) in Power BI

Why add a date table
Create a date table in DAX
Configure the date table in DAX
Sort columns
Mark as date table
Manage multiple date columns

DAX Data

Introduction to DAX
Measures and columns
DAX formulas

Visualization in Power BI

Principles of Power BI visualization
Creating visuals
Creating a report – ergonomics
Creating a report – setup
Histograms
Line charts
Pie charts
Simple table
Conditional formatting
Creating a matrix (pivot table)
Interaction between visuals / customization

Other course(s) in this category

→ Training in Statistical Analysis and Data Preparation with R

→ The Most Comprehensive Power BI Training

→ Python and Data Science Training – Complete Tour

Create clear and impactful dashboards with Power BI. From data import to DAX to visualizations—this complete training is available online or in person in Montreal and Quebec City.

This course is designed for data analysts, financial controllers, marketing professionals, project managers, and anyone who wants to harness the power of Power BI for smarter decision-making.

You will learn how to import and transform data with Power Query, create DAX measures, design interactive dashboards, and publish your reports on Power BI Service.

This training is available both in person and online with a live instructor, giving you the flexibility to choose the format that best fits your schedule.

Benefits:

A course material for each participant.
Coaching available after the training.
We offer you in public session:
- Tea, coffee
- Dinner at a nearby restaurant
- Wireless internet connection

Prerequisites:

Objectives:

Reminder: Import / Prepare Data with Power Query
Model Data in Power BI
Analyze Data with the DAX Language
Visualize Data

- 19/02/2026
- 20/02/2026
- 04/06/2026
- 05/06/2026

Pricing

Preferential rate

849

$ / participant

Public orgs, NPOs

Public price

999 $ / participant

Practical information

Duration: 2 day(s)
Schedule: 9:00 a.m. to 4:30 p.m. (2 coffee breaks + 1-hour lunch)
Format: - Online (live virtual classroom)
- Or in person, depending on availability

📄 Download course outline (PDF)

Registration details

Interested in this training?

Free quote with no obligation

Check if you are: You work for a government organization or a non-profit (NPO)

Select location and date

Name *

Email *

Company (optional)

Number of participants

I have read the terms and conditions

Enter the code

Registration with credit card payment

Check if you are: You work for a government organization or a non-profit (NPO)

Select location and date

Name *

Email *

Company (optional)

Number of participants

I have read the terms and conditions

Enter the code

Why Choose Power BI?

Business Intelligence (BI) has become essential in today’s data-driven world, where information is often too vast for traditional spreadsheets to handle. Microsoft Power BI goes beyond Excel, offering self-service access and lightning-fast connections to your data sources. It is the go-to tool for transforming massive volumes of information into clear, actionable insights.

Our Power BI training empowers Excel users and data professionals alike to take their analytics skills to the next level. Whether you’re building reports, modeling data, or sharing insights across your organization, Power BI provides the flexibility and power you need. Database specialists will also discover how easily Power BI integrates with multiple platforms to unlock the full potential of their data.

Throughout this course, you’ll gain hands-on experience with industry best practices for data modeling, visualization, and analysis. You’ll learn how to connect to diverse data sources—both relational and non-relational—while applying robust security standards and strategies. You’ll also master the deployment of reports and dashboards, ensuring your insights reach the right stakeholders at the right time.

By the end of the training, you’ll know how to design stunning, interactive dashboards, publish and share your reports across teams, and even create professional paginated reports in the Power BI service. With Power BI, you’ll transform raw data into strategic intelligence that drives smarter decisions and business success.

Mark Plouffe, Government of Canada

« Je tiens à vous remercier tous les deux d’avoir offert à mes ressources une excellente formation COBOL au cours des trois derniers jours. Mamadou, merci d’avoir été si accommodant malgré le court préavis et d’avoir envoyé votre formateur à Gatineau pour ce cours personnalisé. Nous avons hâte de poursuivre notre collaboration pour de futurs besoins de formation. »
(Traduit de l’anglais)

“I want to thank you both for providing my resources with excellent COBOL training over the past 3 days. Mamadou, thank you for being so accommodating on such short notice and for sending your facilitator to Gatineau for this customized and personalized training course. We look forward to continuing our partnership for future training needs.”

René-Claude Bouchard | Chargé de projets | STM

« Mamadou est venu nous aider à réorganiser notre panneau d’arrêt via un outil de rapport, Crystal Reports. Mamadou a réussi avec succès le travail de précision, au pixel près, puisque nous voulions un rapport similaire au design graphique original. Il nous a aidés à découper le projet par cycle et à intégrer le rapport à notre logiciel corporatif. La qualité que nous avons appréciée était le souci du détail et la constance. Mamadou a été très professionnel et connaît plusieurs autres technologies. Merci. »

“Mamadou helped us reorganize our stop panel using a reporting tool, Crystal Reports. He successfully delivered precise, pixel-perfect work, as we needed a report that matched the original graphic design. He helped us break the project down into cycles and integrate the report into our corporate software. What we appreciated most was his attention to detail and consistency. Mamadou was very professional and is knowledgeable in many other technologies. Thank you.”
(Translated from French)

Martin Côté – Analyste Assurance Qualité – Travailleur autonome – Montréal

« Ce fut un plaisir de faire affaires avec Doussou Formation. Ce qui fait LA différence est le service personnalisé totalement à l'écoute des participants ainsi que l'adaptation aux besoins de formation. Flexibilité / Adaptabilité / Professionnalisme / Courtoisie. Merci ! »

“It was a pleasure doing business with Doussou Formation. What truly makes THE difference is the personalized service, fully attentive to participants, as well as the ability to adapt the training to their needs. Flexibility / Adaptability / Professionalism / Courtesy. Thank you!”
(Translated from French)