Microsoft Power BI Data Analyst (PL-300)

This course is the new, renamed version of DA-100: Analyzing Data with Microsoft Power BI; the course content and certification remain the same.

The content of this intensive training is derived from the exam "PL-300: Microsoft Power BI Data Analyst". Start preparing for the course now on Microsoft Learn. During the intensive training days with our trainer , you will work with the official Microsoft course materials.

Module 1: Getting Started with Microsoft Data Analytics
This module explores the different roles in the data space, outlines the important roles and responsibilities of a data analyst, and then examines the landscape of the Power BI portfolio.
Lessons

• Data analytics and Microsoft
• First steps with Power BI

Lab: First steps

Module 2: Preparing Data in Power BI
This module covers identifying and retrieving data from various data sources. You will also learn about connectivity and data storage options and understand the difference and performance impact of connecting directly to data versus importing it.
Lessons

• Obtaining data from different data sources
• Optimize performance
• Correct data errors

Lab: Preparing data in Power BI Desktop

Module 3: Cleaning, Transforming and Loading Data into Power BI
This module teaches you the process of profiling and understanding the state of the data. You will learn to identify anomalies, look at the size and shape of your data and perform the correct data cleansing and transformation steps to prepare the data for loading into the model.
Lessons

• Data design
• Extending the data structure
• Data profiling

Lab: Transforming and loading data

Module 4: Designing a Data Model in Power BI
This module teaches the fundamental concepts of designing and developing a data model for appropriate performance and scalability. This module will also help you understand and address many of the common data modeling issues, including relationships, security, and performance.
Lessons

• Introduction to data modeling
• Working with tables
• Dimensions and hierarchies

Lab: Data modeling in Power BI Desktop

• Create model relationships
• Configuring tables
• Checking the model interface
• Create quick measurements

Lab: Advanced data modeling in Power BI Desktop

• Configuring many-to-many relationships
• Enforce security at line level

Module 5: Create measures with DAX in Power BI
This module introduces you to the world of DAX and its true power to improve a model. You will learn about aggregations and the concepts of measures, calculated columns and tables, and time intelligence functions to solve calculation and data analysis problems.
Lessons

• Introduction to DAX
• DAX context
• Extended DAX

Lab: Introduction to DAX in Power BI Desktop

• Create calculated tables
• Create calculated columns
• Create measures

Lab: Advanced DAX in Power BI Desktop

• Using the CALCULATE() function to edit the filter context
• Using time intelligence functions

Module 6: Optimizing Model Performance
In this module, you will become familiar with the steps, processes, concepts and best practices for data modeling required to optimize a data model for enterprise-level performance.

Lessons

• Optimizing the model for performance
• Optimizing DirectQuery models
• Create and manage aggregations

Module 7: Creating Reports
This module introduces participants to the basic concepts and principles of report creation, including choosing the right graphics, designing a page layout and applying basic but critical features such as cropping and filtering. The important topic of designing for accessibility is also covered.
Lessons

• Draft a report
• Improving the report

Lab: Designing a report in Power BI

• Creating a live connection in Power BI Desktop
• Draft a report
• Configuring visual fields and format properties

Lab: Improving Power BI reports through interaction and formatting

• Creating and configuring sync slicers
• Creating a drill-through page
• Applying conditional formatting
• Create and use bookmarks

Module 8: Creating Dashboards
In this module, you will learn how to tell a compelling story using dashboards and the various navigation tools available for navigation. You will be introduced to features and functions and learn how to enhance dashboards for usability and insights.
Lessons

• Create a dashboard
• Real-time dashboards
• Improve a dashboard

Lab: Designing a report in Power BI Desktop - Part 1

• Create a dashboard
• Attach graphics to a dashboard
• Configure a dashboard tile warning
• Using Q&A to create a dashboard tile

Module 9: Creating paginated reports in Power BI
In this module, you will learn more about paginated reports, including how they fit into Power BI. You will then learn how to create and publish a report.
Lessons

• Overview of paginated reports
• Creating paginated reports

Lab: Creating a paginated report

• Using Power BI Report Builder
• Designing multi-page report layouts
• Determining a data source
• Determining a data set
• Creating report parameters
• Exporting reports as PDF

Module 10: Performing Advanced Analytics
This module will help you apply additional features to enhance the report for analytical insights into the data and give you the ability to use the report for actual data analysis. You will also perform advanced analytics using AI graphs in the report for even deeper and more meaningful data insights.
Lessons

• Advanced Analytics
• Data insights with the help of AI imagery

Lab: Data analysis in Power BI Desktop

• Create animated scatter plots
• Use image material to forecast values
• Working with the visual decomposition tree
• Working with the image of key influencers

Module 11: Creating and managing workspaces
This module introduces you to workspaces, including how to create and manage them. You will also learn how to share content, including reports and dashboards, and then how to distribute an app.
Lessons

• Creating workspaces
• Share and manage assets

Lab: Publishing and sharing Power BI content

• Assignment of security principles to data set functions
• Share a dashboard
• Publish an app

Module 12: Managing Data Sets in Power BI
In this module, you will learn the concepts of managing Power BI assets, including data sets and workspaces. You will also publish datasets to the Power BI service and then update and back them up.
Lessons

• Parameters
• Data records

Module 13: Row-level security
In this module, you will learn how to implement and configure security in Power BI to secure Power BI assets.
Lessons

• Security in Power BI