Course Description: PL-300: Microsoft Power BI Data Analyst

This course will discuss the various methods and best practices that are in line with 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 Power BI spectrum, including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards to share and distribute content.

Course + 1-chance certification exam: Take advantage of this option and purchase the official Microsoft certification exam for only 70 euros. With a discount of more than 40%! *Regular exam price: 165 euros + VAT

Audience Profile

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.

Items in this collection

• 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

Course outline

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
  

Prerequisites

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.

Language

• Course: English / Spanish

• Labs: English

Associate Certification

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 Analysis