Power BI for super-user

Optimize your PowerBI skills with this workshop. Discover the transformation, data modeling and reporting functionalities.
Microsoft Partner

Upcoming sessions

Show all sessions
Guaranteed to run
  • Duration: 2 days
  • Regular price: $1,000
  • Preferential price: $880

Course outline

The main objective of this training is to expose the participants to the capabilities offered by Power BI in terms of data transformation, data modeling and analytics content creation.

LanguagesThese scheduled public sessions are offered in English or in French.


This training is for data analysts and BI experts who want to learn how to use Power BI to connect to different data sources, transform data, design data models, create and publish analytics content within their organization.


The notions covered in the Getting started with Power BI course are prerequisites for this course.


At the end of this training, participants will be able to:
  • Position the different components of the Power BI ecosystem and understand how they interact with each other;
  • Understand how to use the capabilities of the different components;
  • Connect Power BI to different data sources and configure scheduled refresh for these data sources;
  • Transform data with Power Query;
  • Use best practices to create and publish data models;
  • Secure the data of a data model using roles;
  • Use the DAX language to augment a data model;
  • Use and configure visual elements to create reports based on best practices;
  • Manage the security of different Power BI artifacts;
  • Create and publish Power BI applications.

Educational method

  • Presentations
  • Demonstrations
  • Practical exercises


Module 1: Overview of the basic concepts
The purpose of this modules is to do an overview the basic concepts of Power BI and look at some of the component of the architecture.
  • Overview of the Power BI suite and architecture
  • Integration of Power BI with the rest of Microsoft’s tools;
  • Overview of the basic concepts;
  • Overview of the powerbi.com application;
  • Overview of the Power BI Desktop application;
  • Licencing model.
Module 2 - Obtaining Data from multiple Sources
The purpose of this module is to allow the attendee to become familiar with the types of data sources and connection modes supported by Power BI.
  • Powerbi.com vs Power BI Desktop;
  • Import data;
    - Excel file;
    - CSV file;
    - Web page (Wikipedia);
    - Dataflow;
    - Direct Query;
    - Azure Analysis Services;
    - Live Connection;
    - Power BI datasets;
  • Streaming in real time;
  • Refreshing data sets;
    - On-Premises Data Gateway
Module 3 – Data transformation with Power Query
The purpose of this module is to allow the attendee to become familiar with the data transformation capabilities offered in the Power BI Desktop application.
  • Overview of Power Query;
  • Data transformation from:
    - Excel files;
    - CSV files;
    - Web pages (Wikipedia);
  • Data transformations with Dataflow
  • Column manipulations;
  • Line manipulations;
  • Manipulation of strings;
  • Manipulation of dates fields;
  • Aggregation, sort, filter, group;
  • Creating columns;
    - Custom column;
    - Conditional column;
    - Column from an example;
    - Column from a function;
  • Creation and use of parameters;
  • Creation and use of functions;
  • Best practices for data transformation.
Module 4 – Creating a data model
The purpose of this module is to allow the attendee to become familiar with the data modeling capabilities offered in the Power BI Desktop application.
  • Basic concept;
    - Fact tables;
    - Dimension table;
  • Data models
    - Flat schema;
    - Star schema;
    - Snowflake schema;
  • Types of data;
  • Data formats;
  • Data categories;
  • Default aggregations;
  • Relationships between tables;
  • Synonyms;
  • Using directories to classify columns;
  • Best modeling practices.
Module 5 – Using DAX Language
The purpose of this module is to allow the attendee to become familiar with the functions of the DAX language and learn how to use them to augment a data model.
  • Introduction to DAX language (Data Analysis Expressions);
    - Basic concepts;
  • Overview of the types of functions;
    - Date and time;
    - Time intelligence;
    - Filter;
    - Information;
    - Logical;
    - Mathematical;
    - Statistical;
    - Text;
  • Calculated tables;
  • Calculated columns;
  • Measures;
    - Total year to date;
    - Total year to date last year;
    - Variance year over year;
    - Variance year over year%;
    - Total month to date;
    - Total month to date last year;
    - Variance month over month;
    - Variance month over month%;
Module 6 – Creating and publishing an advanced report
The purpose of this module is to allow the attendee to become familiar with the best practices in terms of Power BI report creation.
  • Overview of available visualizations;
  • Custom visualizations;
  • Report custom theme;
  • Best practices;
    - Information Architecture;
    - Layout;
    - Visualization;
  • Creating an advanced report;
  • Visualizations configuration;
  • Interaction between visualizations;
  • Visualization filters, page, report;
  • Bookmarks configuration;
  • Report integrated navigation;
  • Use of control groups;
  • Drill down, Drill through;
  • Customized tooltip;
  • Mobile layout;
    - Performance analysis;
    - Creating roles to secure data;
Module 7 – Publish and share analytics content
The purpose of this module is to allow the attendee to become familiar with the practices in terms of publishing analytics content and managing access to the various components of a Power BI solution.
  • Best practices;
    - Analytics content development cycle;
    - Source management;
    - Publishing and sharing;
  • Creating a workspace;
  • Publish a report;
  • Configure data refresh;
  • Configuring roles to secure data;
  • Creating a dashboard;
  • Sharing scenarios;
    - Workspaces;
    - Dashboard;
    - Reports;
  • Publishing a Power BI application;
    - Navigation configuration;
    - Security configuration;
  • Integration with other Microsoft applications;
    - SharePoint;
    - Teams;
    - Flow;
    - PowerApps.

Surround yourself with the best

Luc Labelle
Certified Trainer and IT Consultant
Recognized by his peers as an inspiring coach, trainer, and consultant, Luc is able to transfer his knowledge to benefit his teams.
Pierre-Edouard Brondel
Pierre-Edouard Brondel
Trainer and Desktop Application Consultant
Renowned as an educational expert in the IT and office technology field who has accumulated more than 25 years of experience, Pierre-Édouard is first and foremost passionate about human capital.
Marc Maisonneuve
Marc Maisonneuve
Trainer and Professional Efficiency Consultant
Frédéric Paradis
Frédéric Paradis
Certified Trainer and Cloud Architect
As a certified Microsoft trainer, Frédéric describes himself as a Cloud magician who easily navigates the mythical space between technology and reality.
Be aware of trends, innovations and best practices, every month.
Training center accredited by Emploi-Québec, Accreditation : 0051460
GST : 141582528 – QST : 1019557738
© 2020 AFI
AFI Expertise

The AFI experience brought to you by Edgenda

At AFI, our focus is to offer you relevant training and impactful learning experiences in line with your transformation approach. Do you need support for your approach? Check out Edgenda’s services: Edgenda.com