You have no items in your shopping cart.
Course Details
Course Details
What You'll Learn
This course prepares you for the PL-300 certification exam, covering all official exam domains and their approximate weightings:
Domain 1 Prepare the data (27.5%)
- Identify and connect to data sources or a shared semantic model; choose between DirectLake, DirectQuery, and Import
- Change data source settings (credentials, privacy levels) and create/modify parameters
- Profile data (statistics, column properties) and resolve inconsistencies, nulls, and import errors
- Select appropriate column data types; create and transform columns; group and aggregate rows
- Pivot/unpivot/transpose data; convert semi-structured data to a table; create fact and dimension tables
- Identify/create appropriate keys for relationships; merge and append queries; configure data loading
Domain 2 Model the data (27.5%)
- Configure table and column properties; implement role-playing dimensions
- Define relationship cardinality and cross-filter direction; create a common date table
- Identify use cases for calculated columns and calculated tables
- Create DAX measures: single aggregations, CALCULATE, time intelligence, statistical functions, semi-additive measures
- Create quick measures, calculation groups, calculated tables/columns
- Optimize model performance (remove unnecessary rows/columns, use Performance Analyzer and DAX query view, reduce granularity)
Domain 3 Visualize and analyze the data (27.5%)
- Select and format appropriate visuals; apply themes, conditional formatting, slicing/filtering; create visual calculations with DAX
- Use Copilot to create/suggest report pages and narrative visuals; choose when to use a paginated report
- Enhance reports for usability: bookmarks, custom tooltips, visual interactions, navigation, drillthrough, sync slicers
- Design reports for mobile and accessibility; configure export settings and automatic page refresh
- Identify patterns and trends using the Analyze feature, grouping/binning/clustering, AI visuals, forecasting and reference lines
- Detect outliers/anomalies; use Copilot to summarize the underlying semantic model
Domain 4 Manage and secure Power BI (17.5%)
- Create and configure workspaces; publish, import, or update items; create dashboards and apps
- Choose a distribution method; configure subscriptions and data alerts; promote or certify content
- Identify when a gateway is required; configure semantic model scheduled refresh
- Assign workspace roles and configure item-level access and access to semantic models
- Implement row-level security roles and configure RLS group membership
- Apply sensitivity labels
Course Info
Promotion Code
Promo or discount cannot be applied to WSQ courses
Prerequisite
The learner must meet the minimum requirement below :
- At least O levels and above education
- Read, write, speak and understand English
The learner must also have basic Python knowledge. If you don't have Python knowledge, please consider the following WSQ courses:
Mode of Training
Instructor Classroom Training
WSQ Funding Validity Period
15 Aug 2020 - 14 Aug 2024
WSQ Course Fee Funding
Self-Sponsored
- Click here for more info on the funding for self-sponsored.
- Eligible Singapore Citizens can use their SkillsFuture Credit and PSEA funds to offset course fee payable after funding.
Employer-Sponsored
- Click here for more info on the funding for employer-sponsored.
- Absentee Payroll claimable by SMEs: Up to 80%of hourly basic salary capped at $7.50/hr
- Absentee Payroll claimable by Non-SMEs: Up to 80% of hourly basic salary capped at $4.50/hr
WSQ Assessment
- Participants will be assessed through individual assessment
- Passing Criteria – Participants are to answer all questions accurately in the individual written assessment.
- Participants may need to attend additional coaching sessions and re-assessments if they do not pass the required competency standards.
Job Roles
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
Trainers
is an accomplished IT and data specialist with over 20 years of experience in academia, ICT leadership, and professional training, with a strong focus on data analytics and Excel-based solutions. He has developed and delivered specialized training programs on Statistical Data Analysis with Excel and Visual Basic for Applications (VBA) for Excel, equipping learners with advanced data manipulation, automation, and reporting skills. His expertise extends to automating institutional reporting systems, where he successfully streamlined academic records management through Excel-based tools, integrating macros and automation to improve efficiency and accuracy. As a trainer and consultant, Dr. Siraj has taught Excel to diverse audiences, including university staff, administrative teams, and professionals in banking, security, and education, ensuring they can apply Excel for decision-making, statistical modeling, and process automation. His practical mastery of Excel is complemented by his deep knowledge of office automation and ICT project management, making him a highly sought-after trainer in data analysis and productivity tools. With his blend of hands-on technical expertise and instructional experience, Dr. Siraj stands out as a credible authority in leveraging Excel to drive organizational efficiency and data-driven strategies
Review
Customer Reviews (6)
- Superb training Review by Course Participant/Trainee
-
I found the course extremely useful and relevant to my job. Highly recommend it to others. (Posted on 6/15/2026)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Learned a lot Review by Course Participant/Trainee
-
Very engaging session. The trainer patiently answered all our questions and gave useful tips. (Posted on 1/27/2026)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Great practical training Review by Course Participant/Trainee
-
A very practical course. The trainer made a complex topic simple and enjoyable to learn. (Posted on 6/8/2025)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Engaging trainer Review by Course Participant/Trainee
-
Well organised course with clear objectives. The step-by-step approach made it easy to follow. (Posted on 4/18/2025)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Great learning experience Review by Course Participant/Trainee
-
The course content was comprehensive and up to date. The practical exercises were the best part. (Posted on 2/2/2025)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment
Write Your Own Review
- Recommended Courses
