Microsoft Power BI Data Analyst

In this course, participants will learn the different methods and best practices aligned with technical and business requirements to model, visualize, and analyze data with Power BI. The course will teach you how to access and process data from different types of sources, including relational and non-relational ones. You will also learn how to manage and deploy reports and dashboards to share and distribute content.

 

Objectives

Upon completion of the course, participants will be able to:

• Retrieve data from different sources and create profiles, applying the necessary transformations.
• Design and implement a data model, enriching it with DAX expressions, variables, and aggregations.
• Create reports and dashboards for effective data visualization.
• Perform advanced analytics to gain in-depth knowledge about the data.
• Manage workspaces, datasets, and RLS configuration to collaborate and monitor the use of data.

 

The target audience for this course includes data and business intelligence professionals who want to learn how to perform accurate data analysis using Power BI. This course is also aimed at individuals who create reports that visualize data from data platform technologies, both in the cloud and on-premises.

 

Qualified data analysts begin this role with experience working with data in the cloud.

Specifically:

• Understanding of basic data concepts.
• Knowledge of how to work with data (relational and non-relational) in the cloud.
• Knowledge of the concepts of visualization and data analysis.
• Solid knowledge of data manipulation using tools such as Excel or similar.

By attending this course, participants will receive a copy of the official Microsoft course materials.

 

Active and participative course delivered through demonstrations, practical exercises, and clinical analysis based on all the theoretical topics taught by the instructor to address real cases related to the product. The trainer will also use different dynamics that enable group work, such as challenges, assessment tests, and real cases to prepare for the associated Microsoft certification exam, if applicable.

This course is certified by Microsoft®.

At the end of the training, participants can take the PL-300 exam.

The terms of additional certification services are subject to those established by the license owner or the authorized certification body.

A Certificate of Attendance for course PL 300 will be issued only to participants with an attendance above 75%, and a Diploma of Achievement will be awarded if they also pass the assessment test.

 

 

Module 1: Introduction to Microsoft Data Analysis

Description of data analysis.

Introduction to Power BI item types.

 

Module 2: Prepare data for analysis with Power BI

Data acquisition in Power BI.

Clean, transform, and load data in Power BI.

 

Module 3: Data modeling with Power BI

• Overview of Power BI Desktop models
• Select a Power BI model framework
• Design a data model in Power BI
• Write DAX formulas for Power BI Desktop models
• Add measures to Power BI Desktop models
• Incorporate calculated tables and columns to Power BI Desktop models
• Use DAX time intelligence functions in Power BI Desktop models
• Optimize a model for performance in Power BI
• Apply model security in Power BI

 

Module 4: Power BI visuals and reports

• Define the scope of report design requirements
• Power BI report design
• Configure Power BI report filters
• Improve Power BI report designs for user experience
• Perform analysis in Power BI
• Create paginated reports

 

Module 5: Managing workspaces and datasets in Power BI

• Create and manage workspaces in Power BI
• Manage datasets in Power BI
• Create dashboards in Power BI
• Implement row-level security

 

PL-300 / PL300