Illustration: The Most Comprehensive Power BI Training course

The Most Comprehensive Power BI Training

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.

2 days 9:00 a.m. to 4:30 p.m. Online, Montreal, Quebec City, Gatineau / Ottawa

Updated on

The The Most Comprehensive Power BI Training course at a glance

Length
2 days
Schedule
9:00 a.m. to 4:30 p.m.
Format
Live virtual class or in person in Montreal and Quebec City and Gatineau / Ottawa
Audience
Tous
Price
$885 per participant, or $752 for public bodies and non-profits (plus taxes)
Language
French or English

Doussou Formation and The Most Comprehensive Power BI Training: key facts

Upcoming The Most Comprehensive Power BI Training sessions

Online

  • Select
  • Select
  • Select
  • Select
  • Select
  • Select

Quebec City

  • Select

The Most Comprehensive Power BI Training course outline

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

Your The Most Comprehensive Power BI Training trainer

Portrait of Danny

Danny

A graduate in Software Engineering from ÉTS, Danny has several years of experience in software development, web development, and technical training. As a full-stack developer, he works with a variety of technologies related to programming, databases, APIs, and web application…

View full profile

Prices and practical information

Preferred rate

$752 / participant

Public bodies and non-profits · plus taxes

Standard price

$885 / participant

Businesses and individuals · plus taxes

Practical information

  • Length: 2 days
  • Schedule: 9:00 a.m. to 4:30 p.m.
  • Format: Live virtual class or in person in Montreal and Quebec City and Gatineau / Ottawa
  • Payment: online (PayPal or card) when registering, or by invoice for organizations
  • Funding: Doussou Formation is a training organization accredited by the CPMT. For Quebec employers subject to the Act to promote workforce skills development (payroll over $2M), this course can count toward their 1% training obligation.

Corporate The Most Comprehensive Power BI Training training

Train your whole team as a private group, on your own documents, at your premises or in a virtual class, on the dates that suit you.

Request an offer

Participant reviews

97% satisfaction (end-of-course evaluations, 120 evaluations) · Read all testimonials

Frequently asked questions about the The Most Comprehensive Power BI Training course

What is the Power BI 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.

Who is this training for?

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.

What topics are covered?

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.

Is the training online or in person?

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.

How do I register for the training?

Register directly on our website:
Power BI Training Registration
or contact us by email or phone.

Why take this The Most Comprehensive Power BI Training course

Objectives: what you will be able to do

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

What is included

  • Course materials and exercise files for each participant
  • Certificate of attendance
  • Optional personalized coaching after the course
  • In public in-person sessions:
    • Tea and coffee
    • Lunch at a nearby restaurant
    • Parking (in some cities)
    • Wi-Fi access

Interested in the The Most Comprehensive Power BI Training course?