Course Overview Print

Creating impactful dashboards isn't just about visuals—it’s about clarity and insight. This course helps participants design dashboards that are both visually compelling and functionally effective using Microsoft Excel. They will apply best practices and design principles to real-world cases.

Learning Outcomes:

  • Import, clean, and shape data using Power Query

  • Build data models and relationships with Power Pivot

  • Create interactive dashboards using Power View / Power BI

  • Apply advanced calculations using DAX

Key Topics:

  • Data import and transformation workflows

  • Data modelling and relational design

  • DAX formulas and calculated fields

  • Dashboard creation and interactivity

 

FUNDING INFORMATION

SkillsFuture Singapore (SSG)

Funding is available on Course Fee.  Please see below for the eligibility categories available.

Self-sponsoredSingapore Citizen & PR aged ≥ 21 yearsUp to 50% funding
Singapore Citizen aged ≥ 40 yearsUp to 70% funding
Company Sponsored (Non-SME)Singapore Citizen & PR aged ≥ 21 yearsUp to 50% funding
Singapore Citizen aged ≥ 40 yearsUp to 70% funding
Company Sponsored (SME)Singapore Citizen & PR aged ≥ 21 yearsUp to 70% funding
Singapore Citizen aged ≥ 40 yearsUp to 70% funding

 

SSG 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 SSG-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.

Course Outline

Module 1. Introduction to Power Query, Power Pivot, Power View & Power Map

Module 2 Power Query

  • Power Query Interface
  • Importing Data
  • Appending Files in Folders
  • Data Transformation

Module 3. Working with Power Pivot

  • Power Pivot Interface
  • Getting Data for Power Pivot
  • Working with Relationships
  • Configuring Calculated Columns and Calculated Fields
  • Introducing DAX Functions
  • Build Measures with DAX Functions
  • Using KPIs
  • Working with Hierarchies

Module 4. Power View / Power BI

  • Power View Interface
  • Working with Tables
  • Understanding Aggregations
  • utilising Matrix
  • Working with Drill Through
  • Using Cards
  • Applying Filters & Highlights
  • Cross-Filtering

Module 5.Power Map

  • Power Map Interface
  • Working with Power Map

Module 6. Present and Communicate with Dashboard

  • Create your dashboard with Excel Power Tools
  • Know the Best Practices
*Important Note : Fees are subject to Singapore's prevailing Goods and Services Tax (GST).

Funding available

Course fee funding

Pay or claim with

Eligibility conditions apply. Fees & Funding →
Data Analysis with Excel Power Tools (SFw)
Fees & Funding Enquire Now

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.