WSQ - Microsoft Power BI Data Analyst Associate (PL-300)

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

Final Assessment

• Written Assessment - Short Answer Questions (WA-SAQ)
• Practical Performance (PP)

Promotion Code

Promo or discount cannot be applied to WSQ courses

Minimum Entry Requirement

Knowledge and Skills

• Able to operate using computer functions with minimum Computer Literacy Level 2 based on ICAS Computer Skills Assessment Framework
• Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)

Attitude

• Positive Learning Attitude
• Enthusiastic Learner

Experience

• Minimum of 1 year of working experience.
• Minimum 18 years old

Minimum Software/Hardware Requirement

Software: 

You can download and install the following software:

• Power BI Desktop

You can also sign up a Power BI account

Hardware: Window Laptop

About Progressive Wage Model (PWM)

The Progressive Wage Model (PWM) helps to increase wages of workers through upgrading skills and improving productivity. 

Employers must ensure that their Singapore citizen and PR workers meet the PWM training requirements of attaining at least 1 Workforce Skills Qualification (WSQ) Statement of Attainment, out of the list of approved WSQ training modules.

For more information on PWM, please visit MOM site.

Funding Eligility Criteria

Steps to Apply Skills Future Claim

• The staff will send you an invoice with the fee breakdown.
• Login to the MySkillsFuture portal, select the course you’re enrolling on and enter the course date and schedule.
• Enter the course fee payable by you (including GST) and enter the amount of credit to claim.
• Upload your invoice and click ‘Submit’

SkillsFuture Level-Up Program

The  SkillsFuture Level-Up Programme provides greater structural support for mid-career Singaporeans aged 40 years and above to pursue a substantive skills reboot and stay relevant in a changing economy. For more information, visit SkillsFuture Level-Up Programme

Get Additional Course Fee Support Up to $500 under UTAP

The Union Training Assistance Programme (UTAP) is a training benefit provided to NTUC Union Members with an objective of encouraging them to upgrade with skills training. It is provided to minimize the training cost. If you are a NTUC Union Member then you can get 50% funding (capped at $500 per year) under Union Training Assistance Programme (UTAP).

For more information visit NTUC U Portal – Union Training Assistance Program (UTAP)

Steps to Apply UTAP

• Log in to your U Portal account to submit your UTAP application upon completion of the course.

Note

• SSG subsidy is available for Singapore Citizens, Permanent Residents, and Corporates.
• All Singaporeans aged 25 and above can use their SkillsFuture Credit to pay. For more details, visit www.skillsfuture.gov.sg/credit
• An unfunded course fee can be claimed via SkillsFuture Credit or paid in cash.
• UTAP funding for NTUC Union Members is capped at $250 for 39 years and below and at $500 for 40 years and above.
• UTAP support amount will be paid to training provider first and claimed after end of class by learner.

Appeal Process

1. The candidate has the right to disagree with the assessment decision made by the assessor.
2. When giving feedback to the candidate, the assessor must check with the candidate if he agrees with the assessment outcome.
3. If the candidate agrees with the assessment outcome, the assessor & the candidate must sign the Assessment Summary Record.
4. If the candidate disagrees with the assessment outcome, he/she should not sign in the Assessment Summary Record.
5. If the candidate intends to appeal the decision, he/she should first discuss the matter with the assessor/assessment manager.
6. If the candidate is still not satisfied with the decision, the candidate must notify the assessor of the decision to appeal. The assessor will reflect the candidate’s intention in the Feedback Section of the Assessment Summary Record.
7. The assessor will notify the assessor manager about the candidate’s intention to lodge an appeal.
8. The candidate must lodge the appeal within 7 days, giving reasons for appeal 
9. The assessor can help the candidate with writing and lodging the appeal.
10. he assessment manager will collect information from the candidate & assessor and give a final decision.
11. A record of the appeal and any subsequent actions and findings will be made.
12. An Assessment Appeal Panel will be formed to review and give a decision.
13. The outcome of the appeal will be made known to the candidate within 2 weeks from the date the appeal was lodged.
14. The decision of the Assessment Appeal Panel is final and no further appeal will be entertained.
15. Please click the link below to fill up the Candidates Appeal Form.

• 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

Sanjiv Venkatram – Sanjiv Venkatram is an ACLP-certified trainer and seasoned data analytics professional with extensive expertise in business intelligence, data visualization, and Microsoft Power BI. With a strong background in delivering WSQ and corporate training, he has equipped professionals from diverse industries with the ability to analyze data, design dashboards, and generate insights for decision-making. Sanjiv specializes in applying Power BI’s full suite of tools, from Power Query and DAX to advanced reporting features, ensuring learners gain practical, job-ready skills.

In his Power BI (PL-300) training, Sanjiv emphasizes guiding learners through the certification-aligned curriculum, including data preparation, modeling, visualization, and performance optimization. He integrates case studies and hands-on labs to help participants design professional dashboards and interactive reports. His structured, exam-focused approach ensures learners not only acquire technical proficiency but are also well-prepared to sit for and achieve the Microsoft Power BI Data Analyst Associate certification.

Bernard Peh – Bernard Peh is an ACLP-certified trainer with more than 25 years of experience in architecture, construction, and digital transformation. As Senior Partner at BigDataVC, he integrates data-driven technologies into project workflows and business decision-making. With strong experience in CAD, Revit, and digital project management, Bernard has also expanded into analytics and reporting, using tools like Power BI to transform raw project data into actionable insights for stakeholders.

In his Power BI (PL-300) training, Bernard focuses on helping learners understand how to connect, clean, and model data to support real-world reporting needs. He trains participants to use DAX formulas, build dashboards, and design reports that enhance organizational visibility and performance tracking. By drawing on his leadership and project management background, he contextualizes Power BI within business operations, ensuring learners can apply analytics effectively in their workplace.

Eugene Wong - Eugene Wong is a data analytics and business intelligence specialist with over 15 years of experience in digital transformation, data visualization, and performance management. He has trained and consulted for leading organizations across Singapore and the region, helping them implement data-driven strategies using tools such as Microsoft Power BI, Tableau, and Excel. With a strong background in analytics and finance, Eugene bridges the gap between business strategy and technical implementation, empowering professionals to make informed decisions through actionable insights.

In “Microsoft Power BI Data Analyst Associate (PL-300),” Eugene guides learners through the full data analytics lifecycle—from data modeling and visualization to insight generation and reporting automation. His sessions emphasize hands-on learning using Power BI’s advanced features, including DAX formulas, Power Query, and interactive dashboards. Through practical, real-world examples, Eugene equips participants with the analytical and visualization skills needed to turn complex datasets into meaningful, decision-ready business intelligence.