PL-300: Microsoft Power BI Data Analyst

PL-300 Course: Microsoft Power BI Data Analyst

This course will cover the various methods and best practices that align with the business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show 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 full spectrum of Power BI, including datasets and groups. The course will also cover how to manage and implement reports and dashboards to share and distribute content.

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

Promotion valid until December 31, 2026. One-time exam available only in Virtual - Distance Learning format.

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

Course intended for

The audience for this course is data professionals and business intelligence professionals who want to learn how to perform data analysis accurately using Power BI. This course is also aimed at people 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 provide 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

PL-300 Microsoft Power BI Training Elements

• Data analysis overview (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 artificial intelligence 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. Data analysis overview, getting and transforming data, and semantic model design

Lessons

• Data analysis overview
• 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: Designing 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
  
• Optimizing model performance
  
• Creating 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: Improving a report in Power BI Desktop

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

Lessons

• Performing advanced analysis
• Creating and managing workspaces
  
• Managing semantic models
  
• Creating dashboards
  
• Implementing row-level security
  
• Exploring 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

Data analysts who are suitable for this role should have experience working with cloud data.

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 may meet the prerequisites and better understand how to work with data in Azure by completing the basic data aspects of Microsoft Azure Data Fundamentals before taking this course.

Language

• Course: English / Spanish

• Labs: English / Spanish

Microsoft Associate Certification: Azure Developer Associate

Microsoft Certified: Azure Developer Associate

Demonstrate recommended methods and procedures that align with the 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