fr
en
Designing and managing analytics solutions with Power BI (PL-300)
Your data should inform stakeholder decisions. With Power BI, structure analyses and presentations to make indicators understandable and variances visible. Become more independent in producing information that supports business management.
- Duration
- 3 days 21 hours
- Code
- PL-300 Code
- Certification
- Microsoft Certified : Power BI Data Analyst Associate Certification
Accredited training for the Microsoft Certified : Power BI Data Analyst Associate certification.
Presentation
Organisations that make full use of their data make faster, better-informed decisions. Becoming a certified data analyst in Microsoft Power BI is a sought-after skill for turning raw data into actionable insights and supporting business teams' strategic choices.
This course covers the 4 official PL-300 examination domains: data preparation with Power Query, data modelling and semantic model creation, visualisation and analysis through interactive reports and DAX, and management and security of Power BI workspaces. Each module combines methodological instruction with official Microsoft labs using real datasets.
By the end of the course, you will master the Power BI analytics cycle and be ready for the official PL-300 examination, included in our offer, leading to Microsoft Certified: Power BI Data Analyst Associate certification (see the Certification tab for details).
Objectives
By the end of this Power BI Data Analyst course, you will be able to:
- connect and prepare data sources for analysis;
- clean, transform and load data with Power Query;
- design and develop effective semantic models;
- create interactive, impactful data visualisations;
- implement advanced analysis and DAX measures;
- publish, share and manage Power BI reports and dashboards;
- manage and govern Power BI workspaces;
- prepare for and pass PL-300 to earn Microsoft Certified: Power BI Data Analyst Associate certification.
Program
Module 1: preparing data
- Identifying and connecting to varied data sources: databases, files and cloud services.
- Configuring connection settings and data storage mode.
- Profiling, cleaning and detecting anomalies in data.
- Applying transformations with Power Query.
- Creating tables and relationships using performance best practices.
Labs
- Connect, clean and transform a dataset with Power Query.
Module 2: modelling data
- Defining tables, relationships and cardinalities for an optimised semantic model.
- Creating advanced calculations with DAX (Data Analysis Expressions).
- Implementing Time Intelligence and statistical functions.
- Implementing row-level security (RLS) and configuring user roles.
Labs
- Create a high-performance, secure data model using DAX and row-level security.
Module 3: visualising data
- Selecting and configuring visualisation types suited to business needs.
- Applying conditional formatting and advanced filters.
- Improving user experience with bookmarks, custom tooltips and visual interactions.
- Designing accessible, user-friendly reports.
- Publishing and sharing reports in the Power BI service, including permission management.
Labs
- Create advanced visualisations and an interactive dashboard in the Power BI service.
Module 4: analysing data
- Applying advanced filters and analysing trends.
- Exploring automated insights with Quick Insights and Power BI's integrated AI capabilities.
- Analysing time series and detecting outliers.
- Using key influencers and decomposition trees to identify determining factors.
Labs
- Perform advanced data analysis and explore automated insights with Power BI AI.
Module 5: managing and securing Power BI
- Managing workspaces and semantic models.
- Configuring scheduled refreshes and dataset governance.
- Version management strategies and workspace collaboration.
- Optimising performance and defining access levels.
- Deploying reports and managing their life cycle.
Labs
- Publish, refresh and govern a complete Power BI environment.
Audience
This course is intended for data and business intelligence professionals seeking to master advanced Power BI analysis, including:
- data analysts and BI professionals wishing to develop practical expertise in in-depth Power BI data analysis;
- report and dashboard designers working with cloud or on-premises data sources;
- professionals moving into data careers seeking recognised business intelligence analysis skills.
Prerequisites
This course requires the following prerequisites:
- Technical skills: experience with Excel and data visualisation tools, ideally with an understanding of relational databases and SQL.
- Theoretical foundations: understanding of data analysis fundamentals.
- Recommended alternative: completion of PL-900: Microsoft Power Platform Fundamentals to become familiar with the Power Platform ecosystem.
Teaching and assessment methods
- Initial skills assessment
- Training materials provided to participants
- Continuous assessment throughout the course
- End-of-course feedback questionnaire
- Combination of theory and practical application
- Attendance records
- Post-course follow-up evaluation
- Practical exercises
Course highlights
- Official Microsoft program: content aligned with the current PL-300 syllabus, delivered by a Microsoft Certified Trainer (MCT).
- Training in French: course materials, official practical labs and instruction are entirely in French.
- DAX and Power Query skills: develop operational expertise in Power BI's two most demanding technical pillars.
- PL-300 examination included: the official Microsoft examination is included at no additional cost.
- Microsoft Exam Replay included: if you do not pass on your first attempt, you can retake the examination free of charge, increasing your chances of certification.
Dates and sessions
Choose the date and delivery format that suit you.
No upcoming sessions are currently available.
Microsoft®, Power Platform® and Power BI® are registered trademarks or trademarks of Microsoft Corporation in the United States and other countries.