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.
What is the difference between Artefact School of Data and other courses?
World-renowned learning and a unique educational experience. More than 4,000 students worldwide have been trained by our Artefact business experts. You benefit from immersion training with one of the world leaders in Data, who will share his expertise with you. Every day, you will learn from real-life case studies carried out with some of the world's leading companies.
What is the training format?
You choose the format! Training can be face-to-face, distance learning or hybrid! Everything is designed so that you can follow the course from our classroom or from home, as you wish. We've 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 and Engineers who make up their professional network and increase their chances of securing a future position with Artefact or with a partner.
Who are the teachers?
Your teachers 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 in Data: Artefact. This means that the tutors are in daily contact with Artefact customers and are responding to real, topical issues in the field. Our training courses are therefore designed around what they experience on a daily basis.
How do I apply for the course?
The registration process is very simple: you apply directly for a course, explaining your choice and describing your career path. You can also download our full programme and then make an appointment with us.