Contenu – Power BI (level 3)

GENERAL INFORMATION

This Power BI advanced training course is conducted exclusively in Power BI Desktop (software available for free download from the Microsoft website). Throughout this training, the trainee will import unstructured data from various sources and will transform, merge and analyze it. The trainee will work with data over 3 years and will build DAX measures in order to calculate year-to-date values, differences vs previous year, etc. The training business case is very close to what professionals will need to do in their professional “real-life” situation. It also provides an introduction to advanced Power BI functionalities such as scenario parameters and a deeper dive into the DAX language.

  • Buid a dynamic date table
  • Build a data model using multiple fact and dimension tables
  • Use DAX Time Intelligence measures to create advanced visuals and charts
  • Use advanced DAX language formulas and allow for in-depth data analysis

    • How to transform a complex text file
      • Add custom and conditional columns, extract information and more
      • Replace values, fill down, split columns, merge columns and more
    • How to build a date table
      • By using start date and end date from the fact table and using them as parameters
      • By using M code functions like Duration.Days and List.Dates
    • How to build a data model with two fact tables
      • With a fact sales table and a fact inventory table
      • With multiple dimension tables
    • How to create powerful measures like
      • Previous year’s sales
      • Year-to-date sales (YTD)
      • Cumulative sales over the last x months
      • Difference in $ between current and previous year’s sales
      • Difference in % between current and previous year’s sales
    • How to use natural language to build data visualizations
      • And discover, in the process, how to create a top x sales by product or customer
    • How to use a data from a disconnected table
      • To enable an analysis where you select, within a slicer, the measure you want to see in the report
      • By using the DAX language
    • How to create a comparable analysis
      • Using the DAX language
    • How to create an inventory analysis
      • By calculating the inventory requirement based on the monthly sales level
      • Using the DAX language
    • How to work with the scenario parameters
      • To let the user work with different assumptions (scenario analysis)
      • To build sensitivity analysis
    • How to build creative tooltips
      • To build powerful reports and allow for in-depth data analysis

This advanced Power BI training course offers approximately 6 hours of content.

This advanced Power BI training course is offered in English.

This advanced Power BI training is intended for professionals who need to manipulate and analyze a lot of data and who are looking for a powerful self-service BI (Business Intelligence) tool. It is also intended for those who have completed the Power BI training (level 2) or who have an equivalent experience.

Audrée Pellerin
Audrée Pellerin is a passionate professional, holding a master's and bachelor's degree in Corporate Finance from the University of Sherbrooke. With several years of experience in the field of consulting services, she has worked with SMEs, multinational corporations, and public sector organizations. Audrée stands out with her dual expertise as a business intelligence consultant and experienced trainer. She possesses a natural talent for explaining complex concepts in a clear and accessible manner and is recognized for her ability to impart knowledge with patience and professionalism. As a trainer, Audrée plays a vital role in helping companies strengthen the skills of their internal teams. She develops customized training programs tailored to the needs of her clients and guides participants through interactive and engaging sessions. Her pedagogical approach promotes active learning and the practical application of acquired knowledge. Trainer accredited by the Commission des partenaires du marché du travail.

To find out whether or not you should take this training, we strongly suggest that you take an online quiz. If your score is less than 70%, we strongly suggest to attend our Power BI training (level 2) training course (public, private or online) before attending this training course.

Each trainee must have access to a computer equipped with Power BI Desktop. You can find the free version of Power BI Desktop here: http://www.microsoft.com/en-us/download/details.aspx?id=45331.

This advanced Power BI training course registration includes:

  • a PDF document with all the instructions, step by step, to build your report
  • the data sources
  • the .pbix files with the solutions
  • a reference website with additional resources
  • a forum to ask questions

At the end of this training, when all the lessons and quizzes are completed, the learner will be able to download a certificate of completion. This certificate will include the trainer's Emploi-Québec accreditation number, the participant's name, the title and date of the training, the number of hours of training completed, the number of Continuing Education Units (CEUs), as well as the name and signature of the trainer. This certificate meets the requirements of the continuing education obligations of the Quebec professional orders. For private training (via Teams), the certificate will be sent to the learner by email following the completion of the training.

This training qualifies for 0.6 continuing education units (CEUs).

Le CFO masqué membre SOFEDUC - Sceau UECLe CFO masqué is a member of the Société de formation et d’éducation continue (SOFEDUC), which defines a Continuing Education Unit (CEU) as 10 hours of participation in a structured training activity organized and conducted by an accredited organization, facilitated by qualified instructors and culminating in an evaluation. Only SOFEDUC members in good standing are authorized to use the graphic symbol.

Power BI (niveau 1)

In order to improve your Power BI skills further, the next training course is: Introduction to DAX Language (Power BI and Power Pivot)

This course is an introduction to the DAX (Data Analysis Expression) language, used by Power Pivot and Power BI Desktop. Mastery of this language enables users of these two solutions to create flexible, easy-to-update dashboards, as well as advanced, relevant data visualizations. We recommend that you first take our Power BI training series.

Note that we have developed a training course for professionals who need to consume content elements created in Power BI.


The training Power BI for end users is designed for professionals who need to consume content created in Power BI (applications, datasets, reports and dashboards) and shared with them. It teaches how to use the Power BI web portal, how to use the mobile application, how to analyze and interact with shared content, and how to create your own analyses based on the shared data.


Don't hesitate to share this training with those who consult your reports!

You might also like to take a look at our Excel training courses.

No refunds allowed since you have access to your training material from the moment of payment.

Scroll to Top