Mastering Power BI

This 2-day advanced module completes the basic Power BI training.

By the end of this course, you will have acquired a solid foundation enabling you to handle most of the usual data processing in Power BI, whatever your business.

Target Audience: Beginners

Prerequisite: Mastering the basics of PBI

Length: 2 Days

Price: 1.310€ / 1.460€ (virtual / in-presence)

Are you attending the course because you have been asked to work on a complex data processing project?

Then, consider the "Expert's Help" extension when you register.

Why this course?

While the ‘Power BI Basics’ module focused on processing structured data to produce interactive reports and dashboards, this in-depth module answers the following questions:

What do I do when my source data needs to be transformed before processing?
How do I organise my data correctly?
What are the advanced processing functions in Power BI (DAX) that will save me a lot of time in future processing?
How can I manage access to my reports and dashboards on a granular basis?

These questions may seem complicated at first.

However, they quickly surface when you get into the habit of processing data.

The productivity gains you feel once you have completed the basic module quickly fuel the desire to develop your mastery of Power BI further in order to keep up the momentum.

This mastery module provides the answer.

Whether you're new to Power BI or a seasoned professional looking to enhance your skills, this course is designed to help you quickly master this powerful tool.

The reasons most often cited by participants in our training courses are as follows:
- Efficiency: The two most frequently cited productivity gains are :
  - Processinglarge volumes or complex data that exceeds Excel's capacity.
  - Automation of repetitive and recurring tasks linked to the regular production of reports.
- Visualisation: There is a need to professionalise the quality of reports and make them easier to read.
- Decision-making support: Interactive dashboards make it easy to simulate different scenarios.
- Collaboration: Ability to share reports (and stop distributing the same version repeatedly by e-mail) and manage access to them.
The roles that most often attend our training courses come from the following departments:
- Sales and Marketing
- Finance
- Supply Chain
- HR
Prerequisites
You must have completed the “Power BI Basics” module to participate in this course.
If you have not taken the introductory training course but have experience using Power BI, please contact us by filling out the form at the bottom of this page.
What will you be able to achieve at the end of the course?
At the end of this two-day course, you will be able to:
- Use the main ETL capabilities of Power BI
  - Extract: connect to different data sources
  - Transform: use Power Query to prepare your data for processing: cleansing, creation of calculated columns, manipulation such as filtering, etc.
  - Load: import data into Power BI
- Analysing data using the main DEX functions.
- Publish your reports on the Power BI service
- Manage access to your reports and dashboards.
Day 1: Data transformation and modelling
- Morning: Data import and transformation
  - Connecting to external data sources
  - Exploring Power BI's data transformation features
- Afternoon: Advanced transformation and modelling
  - Importance of data structuring
  - Advanced data manipulation techniques
Day 2: Further training and deployment
- Morning: Data analysis with DAX
  - Introduction to data model creation
  - Introduction to the DAX language for advanced calculations
  - Creation of custom metrics
- Afternoon: Sharing and Collaboratio
  - Publishing and sharing reports on the Power BI service
  - Collaborating with other users and managing authorisations.
The course is organised around a balanced mix of theoretical learning and numerous practical exercises.
Its main strength lies in the large amount of practical application.