Microsoft Power BI Data Analyst

This course covers 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 show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.

Why attend this course?

• Learn what are the duties of a Data Analyst.

• Use features of Microsoft Power BI that will help you fulfill the Data Analyst Role.

• Connect to relational database sources like SQL Server.

• This course helps in your preparation to pass Exam PL-300 to become a certified Microsoft Power BI Data Analyst.

Audience Profile

The audience for this course are data professionals and business intelligence professionals such as Data Analysts who want to learn how to accurately perform data analysis using Power BI.

This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist both in the cloud and on-premises.

Prerequisites

Successful Data Analysts start this role with experience of working with data in the cloud, specifically:

• Understanding core data concepts.

• Knowledge of working with relational data in the cloud.

• Knowledge of working with non-relational data in the cloud.

• Knowledge of data analysis and visualization concepts.

You can gain the prerequisites and a better understanding of working with data in Azure by completing Microsoft Azure Data Fundamentals before taking this course.

Course Outline

Module 1: Discover Data Analysis

• Get started building with Power BI.

• Introduction to end-to-end analytics using Microsoft Fabric.

Module 2: Prepare data for analysis with Power BI - Get data in Power BI

• Clean, transform, and load data in Power BI.

• Choose a Power BI model framework.

Module 3: Model data with Power BI

• Configure a semantic model.

• Write DAX formulas for semantic models.

• Create DAX calculations in semantic models.

• Use DAX time intelligence functions in semantic models.

• Create visual calculations in Power BI Desktop.

• Optimize a model for performance in Power BI.

Module 4: Design Effective Reports in Power BI

• Scope report design requirements.

• Design Power BI reports.

• Enhance Power BI report designs for the user experience.

• Perform analytics in Power BI.

Module 5: Manage and Secure Power BI

• Manage workspaces in Power BI service.

• Manage semantic models in Power BI.

• Choose a content distribution method.

• Create dashboards in Power BI.

• Secure data access in Power BI.

Certification Overview 

​

Data Analysts play a crucial role in helping businesses unlock the full potential of their data assets using Microsoft Power BI. As subject matter experts, they design and develop scalable data models, clean and transform raw data, and implement advanced analytics to deliver actionable insights. Their work empowers organizations by creating intuitive and impactful data visualizations that drive meaningful business outcomes. 

​

As a candidate for this certification, you should deliver actionable insights by working with available data and applying domain expertise. You should:

• Provide meaningful business value through easy-to-comprehend data visualizations.

• Enable others to perform self-service analytics.

​

How to earn this certification?

​

Achieve the Microsoft Data Analyst Associate Certification by taking the Microsoft Power BI Data Analyst (PL-300) training course and completing the PL-300 exam.

​

Skills Overview 

​

• Prepare the data.

• Model the data.

• Visualize and analyze the data.

• Manage and secure Power BI.