course
Design and manage analytics solutions using Power BI (PL-300)
Build quick, effective and interactive visuals, reports and dashboards to analyse your data.

Description
In this course, you learn the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. Using a range of data source including both relational and non-relational, you access and process data with Power BI. Finally, you learn how to manage and deploy reports and dashboards for sharing and content distribution.
Audience Profile
The audience for this course is data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted at those individuals who develop reports that visualize data from the data platform technologies that exist both in the cloud and on-premises.
Certification
This course also helps you prepare for the Associate exam PL-300 (Microsoft Certified: Power BI Data Analyst Associate)
Learning Goals
Prior Knowledge
Familiarity with data analysis concepts. No specific courses or certifications are required.
Subjects
- Get started with Microsoft data analytics
- Prepare data for analysis with Power BI
- Model data with Power BI
- Design effective reports in Power BI
- Manage and secure Power BI
1: Get started with Microsoft data analytics
Explore the role of a data analyst and how Power BI tools transform data into impactful reports and dashboards that support trusted, data-driven decisions across the business.
Lessons
- Roles in data
- Data Analysis tasks
- Building blocks of Power BI
- End-to-end analytics with Microsoft Fabric
2: Prepare data for analysis with Power BI
You'll learn how to use Power Query to extract data from different data sources, choose a storage mode, and connectivity type. You'll also learn to profile, clean, and load data into Power BI before you model your data.
Lessons
- Get data in Power BI
- Clean, transform, and load data
3: Model data with Power BI
Data modeling configures and shapes your prepared data to design a semantic model with the necessary relationships and calculations using Data Analysis Expressions (DAX). This process ensures accurate analysis and sets you up to create clear, impactful Power BI reports.
Lessons
- Configure a semantic model
- Create DAX calculations in semantic models
- Modify DAX filter context
- Use DAX time intelligence functions
- Create visual calculations
4: Design effective reports in Power BI
Use data visualization and storytelling techniques to create insightful, dynamic Power BI reports that engage users, highlight key findings, and help inform decisions based on data.
Lessons
- Design Power BI reports
- Enhance reports for user experience
- Perform analytics in Power BI
- Get started with Copilot in Power BI
- Optimize model performance (optional)
5: Manage and secure Power BI
Ensure content is accessible and distributed effectively in Power BI to foster collaboration and informed decision-making. Protect sensitive information with robust security, building trust across your organization.
Lessons
- Manage workspaces in Power BI
- Manage semantic models
- Choose a content distribution method
- Secure data access in Power BI
Schedule
All courses can also be conducted within your organization as customized or incompany training.
Our training advisors are happy to help you provide personal advice or find Incompany training within your organization.

Prior knowledge courses
Introduction to Microsoft Azure Data (DP-900)
Learn foundational knowledge of cloud data services within Microsoft Azure
- Databases
- Data Engineering
T-SQL Querying Fundamentals (DP-080)
Learn the Transact SQL language to query SQL Server or Azure data sources
- Databases
Data Analytics and Business Intelligence Introduction
Principles of Data Analytics and Business Intelligence explained
- Data Analytics
Follow-up courses
Certification
The knowledge from this training aligns with these certifications.
"Very pleasant teacher, gave a very good interpretation of the course in their own way. It was nice to follow the course like that."Marieke
Hoge waardering
Praktijkgerichte trainingen
Gecertificeerde trainers
Eigen docenten
