EN 
FR 
Powered by ARTEFACT
Power BI Advanced
Mastering Power BI
Take your Power BI skills to expert level with this advanced training course focused on preparing for PL300 certification.
Power BI Advanced
On request
Choose your session
Course description
This intensive course is designed for Power BI users who want to deepen their knowledge and prepare for PL300 certification. You will learn how to build and optimise dashboards, manage advanced data transformations with Power Query, explore alternatives for data preparation, and master complex data visualisation and analysis.Objectives
On completion of this course, you will be able to :
Design and develop advanced dashboards incorporating UI/UX principles
Apply advanced data transformation and optimisation techniques
Prepare for and pass PL300 certification by mastering the advanced features of Power BI
Public
This course is designed for professionals with intermediate experience of Power BI who are aiming for PL300 certification, such as data analysts, BI consultants and BI project managers.Prerequisites
A computer capable of running Power BI. Experience with Power BI. Basic knowledge of data manipulation and visualisation.Evaluation
Official PL 300 certification.Power BI Advanced
1. DASHBOARD ARCHITECTURE
1 hour
Overview of dashboard project stages
UI/UX and planning best practice
2. DATA INGESTION AND TRANSFORMATION
1 hour
Advanced techniques in Power Query for processing and analysing columns
Exploring DataFlows and data pipelines
3. ALTERNATIVES TO POWER QUERY
1 hour
Comparison of tools such as BigQuery, Dataiku and MS DataFlows for data preparation
4. DATA VISUALISATION AND REPORTING
1 hour 30 minutes
Advanced techniques for viewing and using DAX for conditional formatting
In-depth knowledge of functions such as Drill Through and the manipulation of data parameters
5. DATA MODELLING AND OPTIMISATION
1 hour
Review of data modelling concepts and exploration of directional filters
Techniques for optimising model performance in Power BI
6. DAX FOR ADVANCED ANALYSIS
1 hour
Use of advanced DAX functions to create tables and build KPIs
7. NEW TRENDS ON POWER BI
1 hour
Exploring Microsoft Fabric, One Lake, Direct Lake and Looker as semantic layers
8. PL-300 PREPARATION
1 hour
Effective preparation techniques for the PL300 exam, including a frequently asked questions session and a quiz
Like them, train your teams in data
Choose Artefact School of Data
to train your teams
Receive all the latest news from the School of Data.
Other training courses on the same theme
Up-skill your teams
FAQ
Do you have any other questions about Artefact School of Data? We'd love to hear from you.
Are our courses face-to-face and/or distance learning?
We recommend that you come to one of our face-to-face courses to be at the heart of the leader in Data and Artificial Intelligence. However, if you prefer or if you can't do otherwise, our courses can also be taken at a distance or as a hybrid! Everything is designed so that you can follow our courses from our classroom or from home, as you wish. We have made this choice to optimise your learning during the course.
What support is there to help you find a job?
Every day, our students have the opportunity to work alongside Artefact employeesone of the leaders in Data. This means that every day, they meet Data Scientists, Analysts, Engineers, Data Consultants and Data Marketing experts who make up their team. professional network and increase their chances of securing a future position with Artefact or with a partner.
In addition, we offer a Career Day to help you find a job. This includes workshops on job hunting, preparing CVs and LinkedIn profiles, as well as advice on technical interviews.
Who are the teachers?
Your tutors are Data Scientists, Analysts or Senior Engineers by trade. This is very important to us because they work at the very heart of one of the leaders specialising in Data and AI: Artefact. This means that the teachers are in daily contact with Artefact customers and are responding to real, current issues in the field. Our training courses are therefore designed around what they experience on a daily basis.
How do I apply for one of our courses?
The registration process is very simple: you apply directly for the course of your choice, explaining your motivations and describing your career path. You can also download the full programme and then make an appointment with us.
Are our training courses Qualiopi certified?
Our training courses are certified "Qualiopi pour l'action de formation".