About this course
The Power BI data analyst works closely with business stakeholders to identify business requirements. They collaborate with enterprise data analysts and data engineers to identify and acquire data. They also transform the data, create data models, visualize data, and share assets by using Power BI.
This course is designed for students who are planning to take the corresponding PL-300 certification exam, or students who are performing Data Analyst tasks in their daily job.
Duration
This course is 40 class hours, typically consisting of (10) 4-hour sessions with additional hours for labs and practice assessments.
Benefits
- The Power BI data analyst collaborates with key stakeholders across verticals to identify business requirements
- Cleans and transforms the data, and then designs and builds data models by using Power BI
- Provides meaningful business value through easy-to-comprehend data visualizations
- Enables others to perform self-service analytics, and deploys and configures solutions for consumption
- Proficient using Power Query and writing expressions by using DAX
Who should take this course?
Candidates for this exam deliver actionable insights by working with available data and applying domain expertise. They provide meaningful business value through easy-to-comprehend data visualizations, enable others to perform self-service analytics, and deploy and configure solutions for consumption.
Candidates for this exam should be proficient at using Power Query and writing expressions by using Data Analysis Expressions (DAX). These professionals know how to assess data quality. Plus, they understand data security, including row-level security and data sensitivity.
Class Details
Exam Objectives:
- Prepare the data (25-30%)
- Model the data (25-30%)
- Visualize and analyze the data (25-30%)
- Deploy and maintain assets (15-20%)
Pre-requisites:
There are no pre-requisites for this course. However, the DP-900 Azure Data Fundamentals course and familiarity with the Microsoft suite of products is beneficial.
Labs:
- Prepare Data in Power BI Desktop
- Load Data in Power BI Desktop
- Design a Data Model in Power BI
- Create DAX Calculations in Power BI Desktop, Part 1
- Create Advanced DAX Calculations in Power BI Desktop, Part 2
- Design a Report in Power BI Desktop
- Enhance a Report in Power BI Desktop
- Create a Power BI Dashboard
- Identify Patterns and Trends
- Enforce Row-Level Security
Additional Resources:
No additional resources are currently available for this course.
