PL-300: Microsoft Power BI Data Analyst

PL-300 Course: Microsoft Power BI Data Analyst

This course will examine 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 entire Power BI spectrum, including datasets and groups. The course will also discuss how to manage and implement reports and dashboards for sharing and distributing content.

Virtual course with a free certification exam included. 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-attempt exam available only in Virtual - Tele-training mode. Not applicable to Self-Learning mode.

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

Course aimed at

The audience for this course are 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 individuals who develop reports that visualize data from data platform technologies existing both in the cloud and on-premises.

Objectives of the official Power BI Course

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
  
• Administer and secure Power BI

Elements of the PL-300 Microsoft Power BI training

• 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 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)

Content of the PL-300 Power BI Data Analysis course

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: Getting Data into Power BI Desktop

Lab 2: Loading Data into 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: Enhancing a report in Power BI Desktop

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

Lessons

• Performing advanced analytics
• 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 eligible for this role begin 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 Microsoft Azure Data Fundamentals before taking this course.

Language

• Course: English / Spanish

• Labs: English / Spanish

Associated Microsoft Certification: 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