PL-300: Microsoft Power BI Data Analyst

PL-300 Course: Microsoft Power BI Data Analyst

This course will explore the various methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also demonstrate how to access and process data from a variety of data sources, including relational and non-relational data. This course will also explore how to implement appropriate security standards and policies across the Power BI spectrum, including datasets and groups. The course will also cover how to manage and deploy reports and dashboards to share and distribute content.

Virtual course with included certification exam as a gift. Don't miss this opportunity! The exam is valued at €126 + VAT and is included at no additional cost.

Promotion valid until June 30, 2026. One-attempt exam available only in Virtual - Teletraining mode.

Level: Intermediate - Product: Power BI - Role: Data Analyst

Course Audience

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 aimed at those who develop reports that visualize data from data platform technologies that exist both in the cloud and on-premises.

Official Power BI Course Objectives

In this course, you will learn to deliver actionable insights by working with available data to create Power BI reports. You will learn to:

• Prepare data
  
• Model data
  
• Visualize and analyze data
  
• Manage and secure Power BI

Elements of PL-300 Microsoft Power BI training

• Overview of Data Analysis (6 Units)
• Introduction to Building with Power BI (6 Units)
  
• Getting Data in Power BI (12 Units)
  
• Cleaning, Transforming, and Loading Data in Power BI (10 Units)
  
• Designing a Data Model in Power BI (10 Units)
  
• Introduction to Creating Measures with DAX in Power BI (10 Units)
  
• Optimizing a Model for Performance in Power BI (8 Units)
  
• Using Power BI Visuals (10 Units)
  
• Creating a Data-Driven Story with Power BI Reports (15 Units)
  
• Creating Dashboards in Power BI (11 Units)
  
• Performing Analysis in Power BI (12 Units)
  
• Working with AI Visuals in Power BI (7 Units)
  
• Creating and Managing Workspaces in Power BI (8 Units)
  
• Managing Datasets in Power BI (11 Units)
  
• Implementing Row-Level Security (5 Units)

PL-300 Power BI Data Analysis Course Content

Module 1. Overview of data analysis, data acquisition and transformation, and semantic model design

Lessons

• Overview of data analysis
• Introduction to building with Power BI
• Getting data in Power BI
• Clean, transform, and load data
• Designing a semantic model in Power BI

Lab 1: Get data in Power BI Desktop

Lab 2: Load data in Power BI Desktop 

Lab 3: Design a data model in Power BI 

Module 2. DAX, visual calculations, report design, and user experience

Lessons

• Adding measures to semantic models
• Using DAX functions
  
• Optimize model performance
  
• Create visual calculations
  
• Designing Power BI reports
  
• Improving reports for user experience
  

Lab 4: Creating DAX calculations in Power BI Desktop 

Lab 5: Advanced DAX calculations in Power BI Desktop 

Lab 6: Creating visual calculations in Power BI Desktop

Lab 7: Designing a report in Power BI Desktop

Lab 8: Enhancing a report in Power BI Desktop

Module 3. Advanced analysis, workspaces, security, dashboards, and using Copilot and Microsoft Fabric

Lessons

• Performing advanced analytics
• Create and manage workspaces
  
• Managing semantic models
  
• Creating dashboards
  
• Implementing row-level security
  
• Explore Copilot for Power BI
  
• Exploring end-to-end analysis with Microsoft Fabric
  

Lab 9: Performing data analysis in Power BI

Lab 10: Creating a Power BI dashboard

Lab 11: Implementing row-level security in Power BI

Prerequisites

Eligible data analysts start this role with experience working with data in the cloud.

Specifically:

• Understanding of basic data concepts.
• Knowledge of how to work with relational data in the cloud.
• Knowledge of how to work with non-relational data in the cloud.
• Knowledge of data visualization and analysis concepts.

You can meet the prerequisites and gain a better understanding of how to work with data in Azure by completing the fundamentals of Microsoft Azure Data Fundamentals before taking this course.

Language

• Course: English / Spanish

• Labs: English / Spanish

Microsoft Certified Associate: Azure Developer Associate

Microsoft Certified: Azure Developer Associate

Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.

Level: Intermediate
Role: Data Analysis
Product: Power BI
Subject: Data and AI