Home
PL-300 Microsoft Power BI Data Analyst Training

Sessions 3 days
Duration 22.5 hrs
Level Beginner to Intermediate
Assessment NA

Venue

12 Woodlands Square #07-85/86/87 Woods Square Tower 1, Singapore 737715. 5 mins walk from Woodlands (NS9) MRT station.

The venue is disabled-friendly.

Certificate of Achievement from Tertiary Infotech Academy Pte Ltd - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Achievement from Tertiary Infotech Academy Pte Ltd.

We are an Authorised Microsoft Learning Partner (Org ID: 5238476). To get the official Microsoft certification, please register your certification exam at a Pearson VUE test center.

We are Authorised Pearson Vue Testing Center. Once you have prepared for the exam, you can register for the certification here. The course fee does not include the certification exam fee.

You can purchase the exam voucher (one of the lowest prices in Singapore) at Microsoft Role-Based Certification Exam Voucher.

PL-300 Microsoft Power BI Data Analyst Training

Course Code: C1433

1 Review(s) | Add Your Review

This course is designed to prepare students for the Microsoft Power BI Data Analyst (PL-300) certification exam. The course covers all the topics that are necessary to become a proficient Power BI data analyst, including data modeling, visualization, report creation, and dashboard design.

The course begins with an introduction to Power BI and its various components. Students will learn about data sources, data modeling, and creating visuals in Power BI. The course also covers the process of creating reports, including adding visuals and formatting options.

In addition to report creation, the course will cover advanced visualization techniques, including drill-throughs, bookmarks, and custom visuals. Students will also learn how to design dashboards and create KPIs using Power BI.

Throughout the course, students will have access to hands-on labs and practical exercises to reinforce their learning. The labs will be based on real-world scenarios, allowing students to apply their knowledge to actual data analysis situations.

By the end of the course, students will be prepared to take the Microsoft Power BI Data Analyst (PL-300) certification exam. The exam validates the skills needed to design and develop data models, reports, and dashboards in Power BI.

Get exam-ready on our Practice Exam Portal — train in realistic Practice Mode and timed Exam Mode, then retake them as many times as you like before the real exam.

Start Practising →

No funding is available for this course

For WSQ funding, please checkout the details at WSQ - Power BI Data Analyst Exam Prep Course (PL-300)

Course Fee

$1,050.00 (GST-exclusive)

$1,144.50 (GST-inclusive)

Mode of Training

Physical Classroom Training
Synchronised Teaching using ZOOM
Corporate Training at Company Premise

Course Date * Course Date

Include Exam Voucher *

No
Yes +$200.00

Course Time * Course Time

9:30am - 5:30pm

No. of Participants

Sponsorship

Self-Sponsored
Organization Sponsored

Name(s) on Certificate *

Additional Message or Emails for Course Notification

* Required Fields

Please bring your own laptop for hands-on training. If you don't have laptop, we can provide spare laptop for training use.

We provide free consultation related to the subject matter after the course.
Please email your queries to enquiry@tertiaryinfotech.com and we will forward your queries to the subject matter experts.

You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commences.
We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% for any paid amount.
Note the venue of the training is subject to changes due to availability of the classroom.

Course Details

Topic 1: Discover data analysis

Overview of data analysis
Roles in data
Tasks of a data analyst

Topic 2: Get started building with Power BI

Use Power BI
Building blocks of Power BI
Tour and use the Power BI service

Topic 3: Get data in Power BI

Get data from files
Get data from relational data sources
Get data from a NoSQL database
Get data from online services
Select a storage mode
Get data from Azure Analysis Services
Fix performance issues
Resolve data import errors

Topic 4: Clean, transform, and load data in Power BI

Shape the initial data
Simplify the data structure
Evaluate and change column data types
Combine multiple tables into a single table
Profile data in Power BI
Use Advanced Editor to modify M code

Topic 5: Design a data model in Power BI

Get data from files
Get data from relational data sources
Get data from a NoSQL database
Get data from online services
Select a storage mode
Get data from Azure Analysis Services
Fix performance issues
Resolve data import errors

Topic 6: Introduction to creating measures using DAX in Power BI

Introduction to DA
Understand context
Use the Calculate function
Use relationships effectively
Create semi-additive measures
Work with time intelligence

Topic 7: Optimize a model for performance in Power BI

Introduction to performance optimization
Review performance of measures, relationships, and visuals
Use variables to improve performance and troubleshooting
Reduce cardinality
Optimize DirectQuery models with table level storage
Create and manage aggregations

Topic 8: Work with Power BI visuals

Introduction to work with Power BI visuals
Add visualization items to reports
Choose an effective visualization
Format and configure visualizations
Import a custom visual
Add an R or Python visual
Work with key performance indicators

Topic 9: Create a data-driven story with Power BI reports

Introduction to create a data-driven story with Power BI reports
Design a report layout
Add buttons, bookmarks, and selections
Design report navigation
Use basic interactions
Use advanced interactions and drill through
Configure conditional formatting
Apply slicing, filtering, and sorting
Publish and export reports
Comment on reports
Tune report performance
Optimize reports for mobile use

Topic 10: Create dashboards in Power BI

Introduction to dashboards
Configure data alerts
Explore data by asking questions
Add a dashboard theme
Pin a live report page to a dashboard
Configure a real-time dashboard
Configure data classification
Set mobile view

Topc 11: Perform analytics in Power BI

Introduction to analytics
Explore statistical summary
Identify outliers with Power BI visuals
Group and bin data for analysis
Apply clustering techniques
Conduct time series analysis
Use the Analyze feature
Use advanced analytics custom visuals
Review Quick insights
Apply AI Insights

Topic 12: Work with AI visuals in Power BI

Introduction to working with AI visuals
Use the Q&A visual
Find important factors with the Key influencers visual
Use the Decomposition Tree visual to break down a measure

Topic 13: Create and manage workspaces in Power BI

Distribute a report or dashboard
Monitor usage and performance
Recommend a development life cycle strategy
Troubleshoot data by viewing its lineage
Configure data protection

Topic 14: Manage datasets in Power BI

Create dynamic reports with parameters
Create what-if parameters
Use a Power BI gateway to connect to on-premises data sources
Configure a dataset scheduled refresh
Configure incremental refresh settings
Manage and promote datasets
Troubleshoot service connectivity

Topic 15: Implement row-level security

Configure row-level security with the static method
Configure row-level security with the dynamic method

Course Info

Prerequisite

The learner must meet the minimum requirement below :

At least O levels and above education
Read, write, speak and understand English
Basic familiarity with spreadsheets and working with data

Mode of Training

Instructor Classroom Training

Job Roles

Data Analyst
Business Intelligence Specialist
Business Analyst
Data Visualization Specialist
Financial Analyst
Marketing Analyst
Reporting Specialist
Operations Analyst
Sales Operations Manager
IT Manager (with reporting focus)
Product Manager (data-driven products)
Supply Chain Analyst
Project Manager (with data reporting needs)
HR Analytics Specialist
CRM Administrator

Trainers

Sanjiv i is an ACTA certified experienced leader with a proven track record in business / finance consulting and in developing i) business intelligence (BI) solutions ii) data analytics/analysis solutions and iii) IOT lead BI solutions. Sanjiv's goal through Prudentia Consulting, is to promote the simple joy and excitement of actively using the Microsoft Platform. He believes that the agility afforded by the Microsoft platform helps businesses get time back for deeper business thinking and to spend more time with their end customers Sanjiv has rich experiences in diverse/complex high-tech businesses, turn around environments and strategic transformations. His functional expertise is in sales analytics, financial planning and analysis, engineering and program management. He has worked across discrete manufacturing, professional services and higher education verticals. He also has a working knowledge of equities portfolio management within the financial services domain.Sanjiv is the CEO of Prudentia Consulting, an organization committed to promoting the active usage of the Microsoft Platform. Prior to this, he has worked at Microsoft (US & APAC: 9.2 years), Cognizant Tech Solutions (3.3 years), Yazaki North America (8 years) and until recently at Oracle. Here are a few of his BI/analytics projects driven at scale: Built APAC wide BI dashboard using the Power BI umbrella tool set (Power BI online, Power BI desktop and Power Pivot) and a KPI lake (SQL DB), Helped develop key KPIs – identified key KPIs and helped land this in the DB, Developed a budget audit tool that captured budget inputs from a host of countries across the globe, Developed a business unit P&L reporting tool (functional architecture) in Business Objects for the world-wide financial planning and analysis team.

Audrey Lin is a ACTA certified trainer. She is a Business Development Director at Gill Technologies, an IT Consulting and Managed Services Provider focused at servicing SMEs. I'm responsible for the operations, sales, marketing, accounting, and finance functions of the organization. She have 13 years of experience in helping businesses and schools maximize their Return on Investment on IT through the use of the right technology, improving their business processes and increasing user adoption. My expertise is around Microsoft 365, MS Teams and Power BI. To help organizations improve employee productivity with tools from the MS 365 stack, she have delivered several classroom & online-styled end user training sessions to organizations from various industries - real estate, F&B, oil & gas, healthcare, schools, logistics. I have also created multiple customized & on-demand videos that end users can refer to for a quick review. Being certified as a Microsoft Data Analyst Associate, She is proficient at helping businesses gather business insights from their wide array of data. She have been involved in BI Projects with healthcare firms, logistics companies, FIs, etc., starting from the design phase, right through to the daily management of the BI system. Her area of knowledge in managing security and compliance in MS 365 is significant and ever-growing. She have good understanding of the Zero Trust Principle and uses that to improve the IT security posture of her clients. With the support of her engineering team at Gill Technologies, we use cloud-based management tools from MS 365, namely Intune, Endpoint Manager, Defender, etc. to manage our clients' endpoints.

Peter Cheong is an IT and knowledge management professional with strong expertise in networking, cybersecurity, and information systems. He has completed the Cisco Networking Academy Introduction to Packet Tracer course and has participated in international ICT and knowledge management conferences such as the IFLA Knowledge Management Satellite Meeting. With professional experience in IT systems and infrastructure, Peter brings both technical knowledge and global exposure to his training. As an adult educator, Peter focuses on building learners’ foundational skills in cybersecurity, network defense, and risk management aligned to CompTIA Security+ objectives. His sessions emphasize real-world security scenarios, equipping participants to recognize vulnerabilities, manage threats, and implement effective security controls. His combination of practical training and industry exposure ensures learners are well-prepared for both the certification exam and workplace application.