Workplace Decision Dashboards with Power BI and AI

It is mandatory for all participants to be equipped with a laptop (Microsoft OS, Windows 10, 4 gig ram, i5 core), pre-installed with either Microsoft Excel 2016 (full licence) or any latest version, to optimise the learning experience. Access to Power Bi and GenAI would be required.

At the end of this course, you will be able to:

1. Create a Power BI report that communicates decision-ready KPIs, trends, and drivers;

2. Combine and prepare workplace data from common sources and refresh reliably;

3. Build a simple data model and create essential measures for trend/variance/exception analysis;

4. Apply AI tools to accelerate data preparation, measure drafting, and insight narration with validation steps; and

5. Design interactive dashboards that support follow-up actions (drill-through, exceptions, tooltips).

Programme Outline

Module 1: Introduction to Power BI – dashboards that drive decisions

• Overview of Power BI workflow

• What makes a “decision dashboard”

• Create your first Power BI report page

• Visual selection essentials: what to use (and what to avoid)

Module 2: Combine data from different sources

• Common workplace sources: Excel, CSV, folder of monthly files, system exports

• Data hygiene checklist: headers, dates, IDs, duplicates, etc.

• Power Query “survival skills” (only what you need for dashboarding)

• Combine two sources into one clean dataset

• Use GenAI to propose cleaning rules and transformation steps

Module 3: Modelling essentials + “just enough DAX” for everyday metrics

• Facts vs dimensions (star schema concept)

• Relationships that work (and common traps)

• Measures vs columns: what you need to know to avoid wrong numbers

• Building essential measures that match the participant’s chosen workplace scenario

• Use GenAI to draft a measure + explain it

Module 4: Workplace decision patterns - trend, variance, drivers, exceptions

• Turning charts into decisions: “What happened? What is next?”

• Commonly used analysis patterns

• Build interactivity that helps action-taking: slicers, drill-through, tooltips, bookmarks

• Building a simple dashboard

• Where AI adds value (and where it should not be trusted blindly).

Intended For

This course is designed for professionals who work with workplace data from Excel, CSV files, or system exports, need dashboards to support management or operational decision-making, and want to build and maintain dashboards independently.

Competency Mapping (ISCA)

Category 5 = 7.00 Hours

60 Cecil Street

ISCA House

Singapore 049709

Date & Time

13 Aug 2026 (9:00 AM - 5:00 PM)

Closing Date for Registration

1 week before programme or until full enrolment

Fee (inclusive of GST)

For ISCA Members: $ 406.57

For Non-ISCA Members: $ 485.05

Ong Kia Meng

Kia Meng is a training solutionist, and technology evangelist in the data analytics space, possessing more than ten years' experience from financial business partnering. His ability to harness technology enables him to deliver impactful data-driven outcomes. Kia Meng founded Databuilder PL to focus on helping clients adopt data-driven learning design and offer training on data science and business analytics topics. He has created digital instructional media and conducted various business skills training for corporate clients, with participants spanning various nationalities.

A Chartered Accountant of Singapore, Kia Meng graduated with an Accountancy degree from the Nanyang Technological University. He holds an Advanced Certificate in Training & Assessment (ACTA) and a Diploma in Design and Development of Learning for Performance (DDDLP) from the Institute for Adult Learning (IAL) Singapore. He is a certified instructor by IBM in Cloud Computing and in Data Science. As a qualified employment intermediary in Singapore, Kia Meng is also very passionate about helping individuals match their talents to career objectives.