Course Overview Print

Turning numbers into business insight demands both design and data fluency. This course enables participants to use Power BI to create interactive, purpose-driven dashboards that support data-driven decision-making. They will build visual reports using hands-on guided labs.

Learning Outcomes:

  • Import, clean, and model data using Power BI tools

  • Design dashboards with visual clarity and interactivity

  • Apply DAX functions for calculations and measures

  • Share and collaborate on Power BI reports securely

Key Topics:

  • Power BI Desktop and service overview

  • Data transformation using Power Query

  • Data modelling and relationships

  • Visualisation types and formatting

  • DAX fundamentals and report publishing

Course Outline

Learning Unit 1. Introduction to Self-Service Solutions and Power BI

  • Introduction to Self-Service Solutions and Power BI
    • Introduction to business intelligence
    • Types of BI
    • Introduction to data analysis
    • Introduction to data visualisation
    • Overview of self-service BI
    • Considerations of self-service BI
    • Microsoft tools for self-service BI
  • Hands-on Practical Exercise

Learning Unit 2. Import and Apply Data Transformation Techniques

  • Power BI Desktop Overview
  • Using Excel as a Power BI data source
  • Using Databases as a Power BI data source
    • Power BI Desktop Queries
  • Data Processing and Transformation Overview
    • Shaping Data
  • Hands-on Practical Exercise

Learning Unit 3. Link Dataset and Application of DAX (Data Analysis Expression)

  • Link Dataset and Application of DAX (Data Analysis Expression)
  • Relationships
  • DAX queries
  • Set Calculations and measures
  • Hands-on Practical Exercise

Learning Unit 4. Create Visualisations Dashboards

  • Develop Interactive Data Visualisations
  • Creating Power BI reports / Dashboard
    • Using Custom Visuals
  • Hands-on Practical Exercise

 

Class Timings

  • Weekdays and weekends : 09:00AM - 05:30PM
  • Evenings : 06:45PM - 10:30PM

Target Audience and Pre-requisites

Business User, Data Analyst or Professional who needs to observe changes in data patterns, understand the performance of their investments and illustrate it through a dashboard.

Pre-requisites

  • Participants should be familiar with Microsoft Excel application such as creating Pivot Table, Charts and Excel formula (SUM, AVERAGE, etc)
  • Workplace Literacy and Numeracy: Level 5 (WPLN: Speaking, Writing, Listening, Reading, and Numeracy at ESS level 5 or equivalent*)

 

*participants with minimum primary school education completed would have fulfilled this requirement.

SWDA Funding Requirements

  • Trainees must scan their attendance twice daily using the SingPass application.
  • Trainees must attain at least 75% attendance.
  • Trainees must pass the in-house assessment to be eligible for funding.
  • Trainee and/or sponsoring company is/are required to meet all SWDA-mandated eligibility criteria and requirements for funding.  For more information, please refer to SkillsFuture homepage.

Appeal Policy and Procedure

  • As a candidate in this course assessment, you may appeal your results if you disagree with them.
  • To do so, submit your written appeal request via email to esv_comat_cse@stengg.com within 3 working days from date of assessment.

Cancellation, Postponement and Refund Policy

  • Request for cancellation or postponement must be submitted in writing more than 4 weeks before the class start date to avoid any charges.
  • Written notice for cancellation or postponement received 2 to 4 weeks before class start date will incur Late Cancellation Charge - 50% of course fee.
  • Written notice for cancellation or postponement received less than 2 weeks before class start date will incur Late Cancellation Charge - 100% of course fee.
  • If payment has been made and ST Engineering e-Services Pte Ltd accepts the trainee's written notification to cancel or withdraw from the course, ST Engineering e-Services Pte Ltd will issue a refund, less any applicable Late Cancellation Charges.

Feedback Policy and Procedure

  • You may submit feedback via email to esv_comat_cse@stengg.com or your servicing Account Manager.
  • Any formal feedback will be handled within 10 working days from receipt with a written reply given.  An interim reply will be provided should more time be required.
*Important Note : Fees are subject to Singapore's prevailing Goods and Services Tax (GST).

Have Question?

We’re here to help — reach out anytime.

By submitting this form, you consent to be contacted via email and/or your mobile number regarding your enquiry. You consent to the collection, use, disclosure and processing of your personal data in accordance with our Personal Data Policy.