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)
Upcoming Training dates
Location: Wavre
Language: French
Dates: Jan 21st-22nd, 2025
Location: Remote
Language: English
Dates: Jan 28th-29th, 2025
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.
Do you still have questions about this programme?
Please complete this form, and we will respond to you promptly.
Location: Wavre
Language: English
Dates: Feb 4th-5th, 2025
Location: Remote
Language: French
Dates: Feb 11th-12th, 2025
Location: Wavre
Language: French
Dates: Feb 18th-19th, 2025
Location: Remote
Language: English
Dates: Feb 25th-26th, 2025
Location: Wavre
Language: English
Dates: Mar 4th-5th, 2025
They trust us
« The number of projects carried out with Dataceed is impressive, not to mention that several of them are considered Best Practices in the Group SEB. Dataceed has always been right on target when addressing the specific challenges of our business, helping it grow and consolidate along the way. I have absolutely no hesitation in recommending this agency. A sure bet! »
— Alexis B. (Groupe SEB)”