PL-300: Microsoft Power BI Data Analyst

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

• Explore the core capabilities of Microsoft Dynamics 365 finance and operations apps
• Learn the basics of Microsoft Dynamics 365 Finance
• Learn the fundamentals of Microsoft Dynamics 365 Supply Chain Management
• Discover the basics of Microsoft Dynamics 365 Commerce
• Learn the basics of Microsoft Dynamics 365 Human Resources
• Learn the fundamentals of Microsoft Dynamics 365 Project Operations

Module 1 Introduction to Microsoft Data Analytics

Lessons:

• Description of data analysis
• Introduction to Microsoft Data Analytics

Module 2 Data Preparation in Power BI Desktop

Lessons:

• Getting data into Power BI
• Clean, transform and load data in Power BI

Laboratories:

• Lab 1: Preparing data in Power BI Desktop
• Lab 2: Loading data into Power BI Desktop

Module 3: Data Modeling with Power BI Desktop

Lessons:

• Introduction to data modeling
• Managing relationships
• Creating calculations with DAX in Power BI
• Introduction to DAX
• Advanced DAX Concepts
• Optimizing DAX performance

Laboratories:

• Lab 3: Designing a data model in Power BI Desktop
• Lab 4: Advanced DAX Calculations in Power BI Desktop

Module 4: Building Power BI Visuals and Reports

Lessons:

• Creating reports in Power BI Desktop
• Working with visual objects
• Designing reports and interacting with them
• Navigation and filtering
• Report design elements
• Performing advanced analytics with Power BI Desktop
• Exploring Insights with Advanced Analytics
• Using AI Visuals

Laboratories:

• Lab 5: Designing a report in Power BI Desktop
• Lab 6: Improving a report in Power BI Desktop
• Lab 7: Performing data analysis in Power BI

Module 5: Deploying and managing Power BI service elements

Lessons:

• Power BI Workspaces
• Distribute and manage content
• Dashboards in the Power BI service
• Introduction to row level security

Laboratories:

• Lab 8: Creating a Power BI Dashboard
• Lab 9: Enforcing row-level security in Power BI
  

Qualified data analysts enter 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 the concepts of data visualization and analysis.

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

• Course: English / Spanish

• Labs: English / Spanish

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