PL-300: MICROSOFT POWER BI

DATA ANALYST CERTIFICATION

TRAINING PROGRAM
LIVE MENTORED LEARN FROM MICROSOFT
10-WEEKS
LEARNING SESSIONS CERTIFIED INSTRUCTORS
ABOUT THE
PROGRAM Power BI is recognized
as a leading data
visualization software in the
In today's competitive job market,
2023 Gartner Magic Quadrant
Data Science professionals must for Analytics and Business
possess the crucial skill of effectively Intelligence Platforms

visualizing data. Power BI enables

professionals to transform intricate
data into visually stunning
representations, enabling clear and
impactful communication of insights.

Whether you are uncovering patterns,

analyzing trends, or presenting
findings to stakeholders, Power BI 97%
equips you with the necessary tools to of Fortune 500 companies
present data in a compelling and use Power BI for deriving
data-driven insights and
actionable manner. Seize the
improve decision-making
opportunity to excel in the dynamic
- Gartner
world of Data Science – learn data
visualization with Power BI and elevate
your career to new heights.

02
WHO IS THIS PROGRAM FOR?

Entry-level job seekers in the

data domain

Early-career data and business

analysts looking to upgrade their
profile with a valuable
certification

Business analysts and

entrepreneurs aiming to enhance
their data visualization skills and
communicate business insights
effectively to stakeholders

03
PROGRAM HIGHLIGHTS
12+ Industry
10-Week Online Case Studies, Free Exam
Program 1 Hands-on Project Voucher

10 Mentored Learning Exam Preparation Certificate of Completion

Sessions with Microsoft Guide + Mock from Great Learning
Certified Trainers Exams and Microsoft

KEY LEARNING OUTCOMES

The program will help learners:

• Understand the core concepts and functionalities of

Power BI for data analysis

• Create visually appealing and interactive

reports/dashboards

• Build expertise in data modeling, data transformation,

and data cleansing techniques

• Gain proficiency in creating calculated measures,

columns, and DAX expressions

• Master the art of data visualization and storytelling

using Power BI

• Effectively carry out functions like data exploration,

analysis, and report sharing in Power BI

• Prepare for the Microsoft Power BI Data Analyst

PL-300 certification exam
04
CURRICULUM
This curriculum is meticulously crafted to equip you with the necessary skills to
prepare you for the Microsoft Power BI Data Analyst PL-300 certification exam.

WEEK 1 | PREPARE DATA FOR ANALYSIS WITH POWER BI

The objective for this week is to learn how to use Power Query to extract data from different data
sources, and choose a storage mode, and connectivity type. You'll also learn to profile, clean, and
load data into Power BI before you model your data.

Understanding the Power BI interface and features

Creating visualizations and reports by connecting to data from various sources

Basic data modeling concepts and techniques

Data preparation, cleaning, and transformation using Power Query

Creating relationships between data tables

Advanced data modeling techniques

Key Skills

Power BI Basics

Data Visualization

Data Preparation

Data Modeling

Power Query

Relationship Management

Advanced Functionality

05
WEEK 2 | MODEL DATA WITH POWER BI

This week, learn what a Power BI semantic model is, which data loading approach to use, and
how to build out your semantic model to get the insights you need. Below are the topics
covered this week:

Understanding data modeling approaches in Power BI

Designing data models using star schema and data structures

Creating calculations and measures using DAX

Building reports and visualizations using queries and analytics

Key Skills

Data Modeling

Data Structures

DAX Formulas and Calculations

Report Building and Visualization

Query and Analytics

WEEK 3 | ADVANCED DATA MODELING WITH POWER BI

The goal for this week is to learn to optimize Power BI semantic models, using advanced DAX
functions, and implementing security measures. Below are the topics covered this week:

Advanced time intelligence calculations using DAX functions

Optimizing performance in Power BI models and reports

Improving query performance with DirectQuery and variables

Managing data complexity with cardinality reduction and aggregations

Securing data access and controlling model objects

Key Skills

Advanced DAX Calculations

Performance Optimization

Query Performance Tuning

Data Complexity Management

Data Security and Access Control

06
WEEK 4 | BUILD POWER BI VISUALS AND REPORTS

This week, learn to turn data into interactive, actionable insights with Power BI Desktop visuals
and reports. Below are the topics covered this week:

Understanding user needs and designing reports for effective communication

Creating engaging and informative reports with a focus on user experience

Designing and customizing report layouts and visualizations

Using report objects and filtering techniques to enhance report functionality

Enabling user interaction and real-time data exploration

Key Skills

Report Design and Development

User Experience and Interface Design

Data Visualization and Formatting

Report Interactivity and Filtering

Effective Communication and Storytelling

WEEK 5 | BUILDING ADVANCED VISUALS AND REPORTS USING POWER BI

The objective for this week is to learn to turn data into interactive, actionable insights with
Power BI Desktop visuals and reports. Below are the topics covered in this week:

Designing detailed and interactive reports for in-depth analysis

Creating engaging and informative reports with visual storytelling

Optimizing report performance and usability

Analyzing and visualizing data with advanced techniques

Creating reports for specific use cases, such as mobile devices and paginated reports

Key Skills

Advanced Report Design and Development

Data Analysis

Data Visualization

Performance Optimization

Specialized Data Analysis and Visualization

Report Publishing and Sharing

07
WEEK 6 | MANAGE WORKSPACES AND DATASETS IN POWER BI

In this week, learn how to publish Power BI reports to the Power BI service. You'll also learn how to
create workspaces, manage related items, and data refreshes for up-to-date reports. Additionally,
implement row-level security to restrict user access to relevant data without the need for multiple
reports. Below are the topics covered in this week:

Deploying and managing Power BI solutions

Securing and protecting Power BI data and models

Monitoring and troubleshooting Power BI performance and issues

Implementing row-level security and data governance

Creating and managing dashboards for data exploration and insights

Key Skills

Power BI Deployment and Management

Data Security and Governance

Performance Monitoring and Troubleshooting

Row-Level Security and Data Access Control

Dashboard Creation and Management

WEEK 7 | PRACTICAL PROJECT EXPERIENCE

This week's aim is to synthesize and apply the foundational concepts and skills acquired
over previous weeks by undertaking a comprehensive project, This week delves into the
following topics:

Understand the business problems

Understand the data and relevant questions to ask

Clean and transform the data

Model the data

Visualize data using interactive reports and dashboards

Analyze data, identify trends, and draw conclusions

Publish your reports to the Power BI service and share them with stakeholders for
feedback and decision-making

08
WEEK 8 | FIRST EXAM PREPARATION WEEK + MOCK EXAM -1 (OPTIONAL)

The outcome of this week is to review key concepts and skills, and prepare for the Power BI
certification exam, through case-study practice questions and a mock exam. Below are the topics
covered in this week:

Review of key concepts and skills for the PL-300 certification exam

Practice case-study questions

Attempt the first mock exam

WEEK 9 | SECOND EXAM PREPARATION WEEK + MOCK EXAM -1 (OPTIONAL)

The outcome of this week is to continue to consolidate understanding of key concepts and skills in
preparation for the Power BI certification exam, achieved through rigorous practice with more
case-study questions and a comprehensive mock exam. Below are the topics covered in this week:

Review of key concepts and skills for the PL-300 certification exam

Practice case-study questions

Attempt the second mock exam

WEEK 10 | THIRD EXAM PREPARATION WEEK + MOCK EXAM-3 +

GUIDE FOR THE EXAM REGISTRATION PROCESS (OPTIONAL)

The outcome of this week is to further solidify comprehension of essential concepts and skills
essential for the Power BI certification exam by engaging in intensive practice, including a
comprehensive mock exam. Additionally, receive thorough guidance on registering for the
PL-300 exam in both online and offline modes. Below are the topics covered in this week:

Review of key concepts and skills for the PL-300 certification exam

Practice exam questions and discussion of strategies for success

Attempt the third mock exam

Get a walkthrough of the registration process for the PL-300 exam in both
online and offline mode

Tips for preparing and taking the exam

09
CASE STUDIES AND PROJECTS
SAMPLE CASE STUDIES

CASE STUDY 1: ANALYZE QUALITY OF LIFE FACTORS TO IDENTIFY

TOP STATES FOR RETIREES

Description: This case study explores the key factors affecting the quality of life for retirees in
the United States. By analyzing data on the cost of living, healthcare accessibility, climate,
social opportunities, and other relevant metrics, we identify the top 5 states for retirees to live
in and the worst 5 states to avoid. Provide valuable insights for retirees, financial planning
companies, real estate agencies, and healthcare providers to make informed decisions about
retirement destinations.

Skills Used: Data Analysis, Data Visualization, Statistical Modeling, and Data Storytelling

CASE STUDY 2: OPTIMIZE WORKFORCE FOR RETENTION, ENGAGEMENT,

AND FAIR PROMOTIONS BY ANALYZING EMPLOYEE DATA

Description: This case study explores the use of data analysis to optimize workforce
management. By examining employee demographics, job satisfaction levels, promotion
readiness, and performance metrics, we identify areas for improvement and develop
data-driven strategies to enhance employee retention, boost engagement, and optimize
the promotion process.

Skills Used: Data Analysis, Data Visualization, Statistical Modeling, Predictive Analytics, HR
Analytics, Workforce Planning, Talent Management, and Data Storytelling

CASE STUDY 3: ANALYZE SALES DATA TO OPTIMIZE PRODUCT MIX, ENHANCE

SUPPLY CHAIN EFFICIENCY, AND PREDICT FUTURE SALES TRENDS

Description: This case study explores the analysis of sales data to optimize product mix, enhance
supply chain efficiency, and predict future sales trends. By leveraging data analytics, we develop
predictive models to forecast sales, identify areas for improvement in the supply chain, and refine
marketing strategies. Our findings provide actionable insights to inform strategic decisions, boost
profitability, and maintain a competitive edge in the retail market.

Skills Used: Data Analysis, Data Visualization, Predictive Modeling, Supply Chain Optimization,
Marketing Analytics, Product Mix Optimization, Data Storytelling, and Statistical Modeling

10
 CASE STUDY 4: ANALYZING FLIGHT DELAYS FOR SMARTER TRAVEL
DECISIONS

Description: This case study explores the analysis of flight delay data to identify key factors
contributing to delays and improve travel experience for users. By examining flight data, including
meteorological conditions, aircraft details, and delay patterns, we provide actionable insights to
inform travel decisions and enable users to anticipate delays, choose reliable flights, and plan
journeys with confidence. The case study aims at enhancing the booking platform, improving
customer satisfaction, and maintaining the company's competitive edge.

Skills Used: Data Analysis, Data Visualization, Statistical Modeling, Data Storytelling, Business
Intelligence, Aviation Industry Analysis, and Customer Experience Optimization

SAMPLE PROJECT

REVEAL INSIGHTS ON CLASSIC MOVIE PREFERENCES AND USER BEHAVIOR

FOR DATA-DRIVEN DECISION MAKING

Description: This project explores the analysis of classic movies and user demographics. By
examining a vast database of movie information and user ratings, we provide actionable insights
into user interests, genre preferences, and demographic distributions. Our findings reveal patterns
in user engagement, ratings, and viewing habits, enabling the creation of a compelling report that
attracts both loyal viewers and new customers.

Skills Used: Data Analysis, Data Visualization, Statistical Modeling, Demographic Analysis, User
Behavior Analysis, Data Storytelling, Business Intelligence, and Customer Segmentation

11
CERTIFICATE OF COMPLETION
Showcase your competence with a Certificate of Completion from
Great Learning and Microsoft.

L E
P
This is to certify that

John Doe

M
has successfully completed the

A
PL-300: Microsoft Power BI Data Analyst

S
Certification Training Program
in September 2024

Harish K. Subramaniam Mohan Lakhamraju

Academic Director Founder & CEO
Scan to verify

Note: The image is for illustrative purposes only. The actual certificate may be
subject to change at the discretion of Great Learning.

12
 PROGRAM FEE $1100
Please get in touch with a Program Advisor for more details on flexible fee payments.

ABOUT GREAT LEARNING

Great Learning is a leading global ed-tech company for professional and higher
education. It offers comprehensive, industry-relevant programs across various
cutting-edge Technology, Data, and Business domains. These programs are developed
in collaboration with the world’s foremost academic institutions such as MIT Professional
Education, Wharton Online, The University of Texas at Austin, Northwestern School of
Professional Studies, Deakin University, Great Lakes Institute of Management, and more.
They are constantly reimagined and revamped to address the dynamic needs of the
industry. Offered in blended, classroom, and purely online modes, these programs are
delivered with the help of expert mentors and highly qualified faculty. Great Learning is
on a mission to enable transformative learning and career success in the digital
economy and has impacted 11 million+ learners from over 170 countries.

11 Mn+ 170+ 7000+

Learners Countries Industry Experts

* Indian Education * Entrepreneur, Education * EdTech Review

Awards 2022 Innovation Awards 2022 Awards 2020

13
 This program is a part of the ‘Great Learning Journeys’ initiative aimed
at delivering intricately designed learning pathways exclusively for
alums to pursue their aspirations at an affordable cost.

READY TO ADVANCE
YOUR CAREER?

SPEAK TO A PROGRAM ADVISOR

+1 512 641 4554

HAVE QUESTIONS ABOUT THE PROGRAM OR

HOW IT FITS IN WITH YOUR CAREER GOALS?
[email protected]

VISIT OUR WEBSITE

DISCLAIMER: Any names, brands, or other IPs featured or referred to here are the property of their
respective IP holders. Their use does not imply any sponsorship or endorsement of Great Learning or its
affiliates by such IP holders, nor it is intended to infringe on or denigrate their goodwill or reputation.