PL-300: Microsoft Power BI Data Analyst

PL-300 Course: Microsoft Power BI Data Analyst

This course will analyze 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. Furthermore, this course will explore how to implement appropriate security standards and policies across the Power BI spectrum, including datasets and groups. Finally, the course will cover how to manage and deploy reports and dashboards for content sharing and distribution.

Online course with a free certification exam included. Don't miss this opportunity! The exam is valued at €126 + VAT and is included at no extra cost.

Promotion valid until June 30, 2026. One-opportunity exam available only in Virtual - E-learning format. Not applicable to Self-Learning format.

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

Course aimed at

The target audience for this course is data professionals and business intelligence professionals who want to learn how to perform accurate data analysis using Power BI. This course is also for those who develop reports that visualize data from the data platform's technologies, both cloud-based and on-premises.

Objectives of the Official Power BI Course

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

• Data preparation
  
• Data modeling
  
• Data visualization and analysis
  
• Power BI Administration and Security

Elements of the PL-300 Microsoft Power BI training

• Description of data analysis (6 Units)
• Introduction to compilation with Power BI (6 Units)
  
• Data Acquisition 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)
  
• Implementation of row-level security (5 Units)

Course Content PL-300 Power BI Data Analysis

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

Lessons

• Description of the data analysis
• Introduction to compiling with Power BI
• Data collection in Power BI
• Clean, transform, and load data
• Designing a semantic model in Power BI

Lab 1: Obtaining data in 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

• Addition of measures to semantic models
• Using DAX functions
  
• Optimize model performance
  
• Create visual calculations
  
• Power BI report design
  
• Improved reporting 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, work areas, security, dashboards and use of Copilot and Microsoft Fabric

Lessons

• Performing advanced analyses
• Create and manage workspaces
  
• Semantic model management
  
• Create panels
  
• Implementation of row-level security
  
• Explore Copilot for Power BI
  
• Exploring end-to-end analytics 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 begin this role with experience working with data in the cloud.

Specifically:

• Understanding 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 better understand how to work with data in Azure by completing the Microsoft Azure Data Fundamentals data basics 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 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