PL-300T00 Microsoft
Power BI Data Analyst
Overview
Course Objective
Who Should Attend
Prerequisites
• 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
Training Calendar
Intake
Duration
Program Fees
Module
Module 1 - Get Started with Microsoft Data Analytics
This module explores the different roles in the data space, outlines the
important roles and responsibilities of a Data Analysts, and then explores
the landscape of the Power BI portfolio.
• Data Analytics and Microsoft
• Getting Started with Power BI
• Lab: Getting Started in Power BI Desktop
• Getting Started
Module 2 - Prepare Data in Power BI
This module explores identifying and retrieving data from various data
sources. You will also learn the options for connectivity and data storage
and understand the difference and performance implications of
connecting directly to data vs. importing it.
• Get Data from various data sources
• Lab: Preparing Data in Power BI Desktop
• Prepare Data
Module 3 - Clean, Transform, and Load Data in Power BI
This module teaches you the process of profiling and understanding the
condition of the data. They will learn how to identify anomalies, look at
the size and shape of their data, and perform the proper data cleaning and
transforming steps to prepare the data for loading into the model.
• Data Shaping
• Enhance the data structure
• Data Profiling
• Lab: Transforming and Loading Data in Power BI Desktop
• Loading Data
Module 4 - Design a Data Model in Power BI
This module teaches the fundamental concepts of designing and
developing a data model for proper performance and scalability. This
module will also help you understand and tackle many of the common
data modeling issues, including relationships, security, and performance.
• Introduction to data modelling
• Working with tables
• Dimensions and Hierarchies
• Lab: Data Modeling in Power BI Desktop
• Create Model Relationships
• Configure Tables
• Review the model interface
• Create Quick Measures
• Lab: Advanced Data Modeling in Power BI Desktop
• Configure many-to-many relationships
• Enforce row-level security
Module 5 - Create Model Calculations using DAX in Power BI
This module introduces you to the world of DAX and its true power for
enhancing 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.
• Introduction to DAX
• DAX context
• Advanced DAX
• Lab: Advanced DAX in Power BI Desktop
• Use Time Intelligence functions
• Use the CALCULATE() function to manipulate filter context
• Lab: Introduction to DAX in Power BI Desktop
• Create calculated tables
• Create calculated columns
• Create measures
Module 6 - Optimize Model Performance in Power BI
In this module you are introduced to steps, processes, concepts, and data
modeling best practices necessary to optimize a data model for
enterprise-level performance.
• Optimize the model for performance
• Optimize DirectQuery Models
• Create and manage Aggregations
Module 7 - Create Reports in Power BI
This module introduces you to the fundamental concepts and principles
of designing and building a report, including selecting the correct visuals,
designing a page layout, and applying basic but critical functionality. The
important topic of designing for accessibility is also covered.
• Design a report
• Enhance the report
• Lab: Designing a report in Power BI Desktop
• Create a live connection in Power BI Desktop
• Design a report
• Configure visual fields and format properties
• Lab: Enhancing reports with interaction and formatting in Power
BI Desktop
• Create and configure Sync Slicers
• Create a drillthrough page
• Apply conditional formatting
• Create and use Bookmarks
Module 8 - Create Dashboards in Power BI
In this module you will learn how to tell a compelling story through the use
of dashboards and the different navigation tools available to provide
navigation. You will be introduced to features and functionality and how
to enhance dashboards for usability and insights.
• Create a Dashboard
• Real-time Dashboards
• Enhance a Dashboard
• Create a Dashboard
• Lab: Creating a Dashboard in Power BI Service
• Pin visuals to a Dashboard
• Configure a Dashboard tile alert
• Use Q&A to create a dashboard tile
Module 9 - Enhance reports for usability and storytelling in Power BI
This module will teach you about paginated reports, including what they
are how they fit into Power BI. You will then learn how to build and publish
a report.
• Paginated report overview
• Create Paginated reports
• Lab: Creating a Paginated report in Power BI Desktop
• Use Power BI Report Builder
• Design a multi-page report layout
• Define a data course
• Define a dataset
• Create a report parameter
• Export a report to PDF
Module 10 - Perform Advanced Analytics in Power BI
This module helps you apply additional features to enhance the report for
analytical insights in the data, equipping you with the steps to use the
report for actual data analysis. You will also perform advanced analytics
using AI visuals on the report for even deeper and meaningful data
insights.
• Advanced Analytics
• Data Insights through AI visuals
• Lab: Data Analysis in Power BI Desktop
• Create animated scatter charts
• Use the visual to forecast values
• Work with Decomposition Tree visual
• Work with the Key Influencers visual
Module 11 - Manage Datasets in Power BI
In this module you will learn the concepts of managing Power BI assets,
including datasets and workspaces. You will also publish datasets to the
Power BI service, then refresh and secure them.
• Parameters
• Datasets
• Security in Power BI
Module 12 - Create and Manage Workspaces in Power BI
This module will introduce you to Workspaces, including how to create
and manage them. You will also learn how to share content, including
reports and dashboards, and then learn how to distribute an App.
• Creating Workspaces
• Sharing and Managing Assets
• Lab: Publishing and Sharing Power BI Content
• Share a dashboard
• Map security principals to dataset roles
• Publish an App
FAQs
General Questions:
Q: What is the Microsoft Power BI Data Analyst (PL-300T00) course about?
This 3-day course provides hands-on training on how to prepare, model, visualize, and analyze data using Microsoft Power BI. You will learn to connect to different data sources, clean and transform data, build data models, use DAX for advanced calculations, and design impactful reports and dashboards. The course also covers content sharing, dataset management, implementing row-level security, and creating paginated reports. It is ideal for those looking to leverage Power BI for business insights and data storytelling.
Q: Who should attend this course?
Data professionals and business intelligence analysts seeking to improve their Power BI skills. Report developers who visualize data from cloud or on-premises platforms. Professionals responsible for analyzing and presenting business data for decision-making. Anyone interested in transforming raw data into actionable insights using Microsoft Power BI.
Q: What are the prerequisites for this course?
Understanding of core data concepts. Experience working with relational and non-relational data in the cloud. Familiarity with data analysis and data visualization concepts. No prior experience with Power BI is required, but foundational knowledge of data principles is recommended.
Q: How long is the course?
The course spans 3 days (21 hours) and is delivered via instructor-led or remote online learning.
Q: What key topics are covered in this course?
Introduction to data analytics and Power BI, connecting to and preparing data from multiple sources, data cleaning, shaping, and transformation, data modeling and performance optimization, creating measures using DAX, designing interactive reports and dashboards, advanced analytics with AI visuals, managing datasets, workspaces, and report sharing, creating paginated reports with Power BI Report Builder.
Q: Will I receive a certification after completing the course?
Yes, participants will receive a certificate of completion, acknowledging their proficiency in data analysis, reporting, and visualization using Microsoft Power BI.
Program Content & Skills:
Q: What foundational data concepts will I learn in this course?
You’ll learn core Power BI concepts such as connecting to data sources, cleaning and transforming data, modeling relationships, and applying business logic using DAX. The course also covers key principles like data profiling, data shaping, row-level security, and performance optimization for scalable analysis.
Q: How does the course help me apply Power BI to real-world problems?
You’ll work with real datasets to build interactive dashboards, create reports, and perform data analysis. The hands-on labs guide you through tasks like connecting to cloud and on-premises sources, creating drillthrough pages, and publishing dashboards—preparing you to solve business problems across various industries.
Q: What skills will I develop in managing Power BI solutions?
You’ll learn to create and manage datasets, build and optimize data models, write DAX calculations, and manage workspace content. You’ll also explore features like paginated reporting, Power BI service tools, sharing via apps, and applying security roles to safeguard your data environment.
Q: Will I learn how to handle different types of data sources?
Yes. You’ll work with a variety of data sources including relational and non-relational databases, and learn how to connect, import, and transform them in Power BI. The course covers both import and DirectQuery modes, and teaches best practices for performance and scalability.
Q: How does this course prepare me for Power BI in a professional context?
The course gives you the tools to become a data-driven problem solver. With practical training in designing reports, managing workspaces, and creating enterprise-level dashboards, you’ll be ready to apply Power BI in roles involving business intelligence, data analysis, and decision support across multiple sectors.
Submit your interest today !
