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

Autre(s) cours dans cette catégorie

→ The Most Comprehensive Power BI Training

→ Excel Dashboard Training

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

Préalables :

Data professionals and business intelligence practitioners who want to learn how to accurately perform data analysis using Power BI. This course is also intended for individuals who develop reports and visualize data from data platform technologies that exist both in the cloud and on-premises.

Objectifs :

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

Price on request

Interested in this training course?

Please specify your request clearly!

Name *

Desired period

Comments

Enter the code

Click the image to generate a new one.

Free quote without obligation

Check if you are:
You work for a government organization or a nonprofit (NPO)

Select the location and date:

Name *

Company

Number of participants

Comments

Enter the code

Click the image to generate a new one.

Registration with credit card payment

Check if you are:
You work for a government organization or a nonprofit (NPO)

Select the location and date:

Name *

Company

Number of participants

I have read and agree to the terms and conditions of sale

Enter the code

Click the image to generate a new one.

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, Gouvernement du Canada/ Government of Canada

“ I want to thank you both for providing my resources some excellent training(Cobol) 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 customised and personalised training course. We’ll look forward to continuing our partnership for future training needs. “

Maryse Duguay - Analyste fonctionnelle Base de donnée - Montréal

“J’ai grandement apprécié les méthodes d’enseignement du prof. Le fait que nous soyons un petit groupe a grandement facilité les apprentissages. Il s’adapte à son audience et les exercices sont formateurs. Je recommande fortement. “

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!“