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. 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 analyze how to manage and deploy reports and dashboards for sharing and distributing content.

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

The course includes a certification exam and a bonus opportunity for a virtual gift! *Promotion valid until August 31st, for customers in Spain only. Does not apply to self-learning.

Course aimed at

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 intended for those developing reports that visualize data from data platform technologies that exist both in the cloud and on-premises.

Objectives of the Official Power BI Course

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

• Data preparation
  
• Data modeling
  
• Data visualization and analysis
  
• Managing and Securing Power BI

Elements of the PL-300 Microsoft Power BI training

• Description of data analysis (6 Units)
• Introduction to Compiling with Power BI (6 Units)
  
• Getting Data into Power BI (12 Units)
  
• Data Cleansing, Transformation, and Loading 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)

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 data analysis
• Introduction to building with Power BI
• Getting data into 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
  
• 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 analytics, workspaces, security, dashboards, and using Copilot and Microsoft Fabric

Lessons

• Performing advanced analysis
• Create and manage workspaces
  
• Managing semantic models
  
• Create dashboards
  
• Implementing 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 qualified start this role with experience working with cloud data.

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 course before taking this course.

Language

• Course: English / Spanish

• Labs: English / Spanish

Microsoft Associate Certification: Azure Developer Associate

Microsoft Certified: Azure Developer Associate

Demonstrate best practices and methods 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