> Formations > Design and manage analytics solutions using Power BI (Microsoft PL-300)
Course : Design and manage analytics solutions using Power BI (Microsoft PL-300)Official PL-300T00 course, exam preparation
Practical course - 3d
- 21h00 - Ref. PL3
|
Download in PDF format
Share this course by email
 | Prepare and transform data from various sources using Power Query |
| Design a structured data model by defining relationships, hierarchies and key indicators |
| Write simple to advanced DAX formulas to perform calculations tailored to business needs |
| Create interactive, easy-to-read reports by choosing visuals adapted to the analysis |
| Publish and share Power BI content while ensuring that it is secure and up-to-date |
| Optimize report performance to ensure smooth, relevant analysis |
Intended audience
Data and BI professionals wishing to analyze and visualize data with Power BI.
Prerequisites
A good understanding of data concepts (relational and non-relational) in the cloud, as well as notions of data analysis and visualization with Power Query and DAX.
Practical details
Teaching methods
Training in French. Official course material in digital format and in English. Good understanding of written English.
Course schedule
1 Introduction to data analysis with Microsoft
- Discover data analysis.
- Getting started with Power BI.
- Introduction to end-to-end analysis with Microsoft Fabric.
- Discover Copilot in Power BI.
2 Preparing data for analysis with Power BI
- Import data into Power BI.
- Clean, transform and load data into Power BI.
- Choose a suitable modeling structure in Power BI.
3 Modeling data with Power BI
- Configure a semantic model.
- Writing DAX formulas for semantic models.
- Create DAX calculations in semantic models.
- Use DAX time intelligence functions.
- Create visual calculations in Power BI Desktop.
- Optimize a model for performance in Power BI.
4 Designing effective reports in Power BI
- Define report design requirements.
- Design reports in Power BI.
- Improve report design for a better user experience.
- Perform analyses in Power BI.
5 Managing and securing Power BI
- Manage workspaces in the Power BI service.
- Manage semantic models in Power BI.
- Choose a content distribution method.
- Create dashboards in Power BI.
- Securing data access in Power BI
Options
Certification : 200 € H.T.
Successful completion of the exam leads to certification as a "Microsoft Certified: Power BI Data Analyst Associate".
Comment passer votre examen ?
Comment passer votre examen ?
The certification option comes in the form of a voucher and practice tests that will allow you to practise and take the exam at the end of the training course.
Customer reviews
4,7 / 5
Customer reviews are based on end-of-course evaluations. The score is calculated from all evaluations within the past year. Only reviews with a textual comment are displayed.
LAETITIA V.
12/08/26
5 / 5
A very intensive but very interesting course; unfortunately, some topics were covered very briefly, whereas I think they would have benefited from being explored in greater depth – a fourth day would have allowed us to spend more time on the various topics
ALEXIS L.
12/08/26
5 / 5
The course is intensive but very rewarding, and the teaching is excellent
PASCAL B.
10/06/26
5 / 5
Very packed programme. In my opinion, a bit short for three days.
PARTICIPANTS
Data and BI professionals wishing to analyze and visualize data with Power BI.
PREREQUISITES
A good understanding of data concepts (relational and non-relational) in the cloud, as well as notions of data analysis and visualization with Power Query and DAX.
TRAINER QUALIFICATIONS
The experts who lead the training courses are specialists in the subjects covered. They are approved by the publisher and certified for the course. They have also been validated by our teaching teams in terms of both professional knowledge and teaching skills for each course they teach. They have at least three to ten years of experience in their field and hold or have held positions of responsibility in companies.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training course.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you have specific accessibility requirements? Contact Ms FOSSE, disability advisor, at the following address: psh-accueil@orsys.fr so that we can assess your request and its feasibility.
Data and BI professionals wishing to analyze and visualize data with Power BI.
PREREQUISITES
A good understanding of data concepts (relational and non-relational) in the cloud, as well as notions of data analysis and visualization with Power Query and DAX.
TRAINER QUALIFICATIONS
The experts who lead the training courses are specialists in the subjects covered. They are approved by the publisher and certified for the course. They have also been validated by our teaching teams in terms of both professional knowledge and teaching skills for each course they teach. They have at least three to ten years of experience in their field and hold or have held positions of responsibility in companies.
ASSESSMENT TERMS
Assessment of targeted skills prior to training.
Assessment by the participant, at the end of the training course, of the skills acquired during the training course.
Validation by the trainer of the participant's learning outcomes, specifying the tools used: multiple-choice questions, role-playing exercises, etc.
At the end of each training course, ITTCERT provides participants with a course evaluation questionnaire, which is then analysed by our teaching teams. Participants also complete an official evaluation of the publisher.
An attendance sheet for each half-day of attendance is provided at the end of the training course, along with a certificate of completion if the participant has attended the entire session.
Assessment of targeted skills prior to training.
Assessment by the participant, at the end of the training course, of the skills acquired during the training course.
Validation by the trainer of the participant's learning outcomes, specifying the tools used: multiple-choice questions, role-playing exercises, etc.
At the end of each training course, ITTCERT provides participants with a course evaluation questionnaire, which is then analysed by our teaching teams. Participants also complete an official evaluation of the publisher.
An attendance sheet for each half-day of attendance is provided at the end of the training course, along with a certificate of completion if the participant has attended the entire session.
TEACHING AIDS AND TECHNICAL RESOURCES
The teaching resources used are the publisher's official materials and practical exercises.
The teaching resources used are the publisher's official materials and practical exercises.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training course.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you have specific accessibility requirements? Contact Ms FOSSE, disability advisor, at the following address: psh-accueil@orsys.fr so that we can assess your request and its feasibility.
This programme is an original creation, developed by the teaching teams at ORSYS Formation. Any reproduction, representation, adaptation or use, in whole or in part, without the prior written authorisation of ORSYS, is strictly prohibited. ORSYS reserves the right to take any action necessary to protect its intellectual property rights.
This programme is an original creation, developed by the teaching teams at ORSYS Formation. Any reproduction, representation, adaptation or use, in whole or in part, without the prior written authorisation of ORSYS, is strictly prohibited. ORSYS reserves the right to take any action necessary to protect its intellectual property rights.