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 5,000 students around the world have been trained by our experts atArtefact. You will benefit from immersion training with one of the world leaders in Data & AI, who will share their expertise with you. Every day, you'll learn from real-life cases you've worked on with some of the world's biggest companies.
How do I apply for our courses?
The registration process is very simple: you apply directly for the course of your choice, explaining your motivation and describing your career path. You can also download our full programme and make an appointment with our team.
How can I finance my training?
There are a number of funding solutions available to you: personal funding (in one or more instalments), use of your Personal Training Account (CPF), assistance from Pôle emploi, funding via your company's OPCO if you are in post, Professional Transition Project (PTP), Agefiph, etc. As each professional project and each funding application is unique, we offer you a personalised meeting to answer all your questions and help you through the process. You can also watch a video showing all the financing options available.
Are the courses face-to-face or distance learning?
We recommend taking the course face-to-face, in order to take full advantage of the learning environment within a leading player in Data and Artificial Intelligence, and to benefit from direct exchanges with the trainers and other participants.
However, for greater flexibility, our courses can also be taken at a distance or in a hybrid format. Every effort is made to ensure that you can participate in the best possible conditions, either from our classroom or from home, depending on your preference. This flexible format has been designed to optimise your learning throughout the course.
Who are the speakers at Artefact School of Data?
The lecturers at Artefact School of Data are senior Data Scientists, Data Analysts and Data Engineers. They all work forArtefactone of the world leaders in data. Thanks to their day-to-day work with Artefact's customers, they are confronted with the real and current issues faced by companies. This proximity to the field means that we can offer training that is rooted in the reality of data projects, built on their experience and the challenges they face every day.
Are our training courses Qualiopi certified?
Our training courses are certified "Qualiopi pour l'action de formation".
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 the data industry. This means that every day, they meet Data Scientists, Data Analysts, Data Engineers and Data Marketing experts, who make up their team. professional network and increase their chances of securing a future position with Artefact or from one of our partners.