Your team already works in Excel. What they need now is a fast, practical way to turn scattered spreadsheets into clear performance dashboards—without getting lost in jargon or months-long projects.

This two-day program shows them how to:
• frame a business question in KPI terms,
• clean and combine data the smart way,
• build insightful visuals in Power BI, and
• set up a simple “refresh & alert” loop so the numbers stay trustworthy.

No deep coding, no black-box statistics—just the essentials you can start using next week.

Pre-requisite:

This is an Intermediate Power BI course

• Participant has completed “Data Visualization with Power BI - Foundation Course”
• Participants are required to
  • Bring an Internet enabled laptop with installed Office 365 (Excel) for hands-on exercises, and
  • Download & install Free Power BI Desktop software from Microsoft at https://powerbi.microsoft.com
  • Require WEB BASED access to Microsoft 365 apps
  • Basic Experience in creating a simple Power BI Report

Objective

By the end of the course, participants will be able to:

1. Define the right KPIs for one priority business problem.
2. Import and tidy data with Power Query instead of copy-paste.
3. Spot key patterns quickly—trends, outliers, missed targets.
4. Create an interactive dashboard in Power BI
5. Automate updates and alerts so decision-makers always see the latest numbers.

Outcome:
✔ Solve business problems using a 7-step data framework
✔ Analyze & visualize KPIs in Power BI
✔ Build interactive dashboards for stakeholders
✔ Automate reporting for continuous monitoring

Outline

Problem Definition, Data Collection & Exploration

Objective: Learn how to identify business problems, gather data, and perform exploratory analysis in Power BI.

Session 1: Identify the Problem / Set the Goal

• Understanding business KPIs & stakeholder alignment
• Defining clear objectives (e.g., sales performance, customer churn)
• Hands-on: Drafting a problem statement for a case study

Data Analysis, Modeling & Visualization

Objective: Apply statistical analysis, build models, and visualize insights in Power BI.

Session 2: Introduction to Power BI for Advanced Analytics

• Identifying relevant data sources (Excel, CSV, databases)
• Data cleaning techniques (handling missing values, duplicates, outliers)
• Importing & transforming data (Power Query)
• Data modeling (relationships, star schema)
• Exercise: Connecting Excel data to Power BI

Session 3: Data Visualization & Interactive Dashboards

• Best charts for KPIs (bar, line, scatter, gauges)
• Filters, slicers, and drill-throughs
• Exercise: Creating a sales performance dashboard

Key Takeaway:
✔ Analyze data using Power BI
✔ Build interactive dashboards
✔ Translate raw data into visual insights

Who should attend

Anyone who needs to design, analyze, and communicate KPI-driven performance insights using Power BI for faster, clearer business decision-making.

Jason Khoo's Profile

Jason Khoo is a Microsoft Certified Trainer (MCT) and an ACTA-certified trainer with over 20 years of training experience. A Microsoft Certified Power BI Data Analyst Associate, he brings more than 30 years of hands-on experience in data analytics and business intelligence. He is also the Author of 4 Amazon books.

His expertise spans a wide range of areas, including Artificial Intelligence (AI), Data Science, Generative AI, Machine Learning, Digitalization, Predictive Analytics, Interactive Dashboard Design, Data Storytelling, and Data Visualization.

He is also highly skilled in developing automated, real-time reports and conducting data and visual analytics using tools such as Microsoft Excel, Power BI, and Tableau.

Throughout his career, Jason has held key roles at organizations such as Tibs (now SMRT), MobileOne Ltd, 3M, and Virgin Mobile.

During his tenure, he has worked with multiple databases, extracted and downloaded information from systems and run numerous analysis. These analyses spanned across many departments such as Finance, Sales, Marketing, Human Resources, Payroll, etc.

After his employment, he worked as a data analytics consultant for many companies, including Discovery Asia, 3M, Tanah Merah Country Club, Johnson and Johnson Vision Care, National Environmental Agency, Timberland, etc.
His data analytics skills combined with Excel allowed him to deliver many reports to the clients without them having to incur software cost. These reports include Dashboards, Top 10 charts, Risk Analysis, Business Models, KPIs, etc.

As a trainer, he is passionate about transferring his knowledge and imparting his skills to his participants. To day, he has trained thousands in his face to face workshops and had conducted talks for thousands as well.

Trans-Island Bus Services Ltd (Tibs) –Operations and Revenue Analytics, Passengers Travelling Behaviour Analytics
• Daily tracking of revenue,
• Prepare KPI for LTA,
• Fare revision analysis

Mobile One Asia Ltd (M1) – Financial analytics, Customer Call Usage Analytics
• Full company budgeting and business planning,
• Monthly Analysis,
• KPI reporting

3M – Sales, Cost and Inventory analytics
• Daily and Monthly Sales Forecasting,
• Analysis of Marketing Budget,
• Analysis of Inventory and shipments.
• Cost Analysis for new products (BOM analysis)

Virgin Mobile – Retail, Marketing, Payroll, Admin, IT, Finance Analytics
• Daily KPI reporting,
• Monthly Analysis for Finance, Payroll,
• Developed Fully Automated Business Model driven by KPI