Home › WSQ Courses › Data Analytics
📊 Most Popular Power BI Course SkillsFuture Credits, UTAP & SFEC Grants Eligible

Data Analytics & Visualization With Power BI

Master Power BI Dashboards, DAX & Power Query in 2 Days

23+
Years
120+
Courses
3,460+
Corporate Clients
45,000+
People Trained
Microsoft Power BI Training Course in Singapore at Intellisoft
View Dates & Register → 💬 Enquire About This Course
Trusted by
WSQ Accredited · Intellisoft
🔥 Filling Up Fast
Next Available Date
📅 Next Class ⚡ 13, 14 Apr 2026
Course Details
⏰ Duration 2 Days
📍 Venue Fortune Centre, Singapore
👥 Class Size Up to 25 Pax
🎓 Certificate ✓ WSQ Certificate Issued
From S$390 after WSQ Grant*
Full fee: S$1,090.00 incl. 9% GST  ·  See grant table →
🏛️ WSQ & SkillsFuture funding available — view full grant breakdown →
Book My Seat → 💬 Enquire About This Course
✓ 100% satisfaction guarantee · Respond within 2 hours
🏛 Up to 70% SSG Grant  ·  Pay from S$390 after funding
WSQ Funded SkillsFuture UTAP SFEC Learn more ↓
About This Course

About This Power BI Course

Power BI course in Singapore at Intellisoft

This Power BI Course introduces the exciting world of business analytics to you.

In the Microsoft Power BI class nearby in Singapore, you will learn the skills to be the best business analyst and gain insights into your data quickly. You will be able to efficiently use Power BI, Write DAX Measures and Use Power Query to clean and load data.

In this Power BI training Singapore, you will also learn Power BI –  how to publish the final dashboards and reports to the Microsoft Power BI Service in the cloud and refresh data automatically.

The course starts first by highlighting the critical Advanced Excel functionality useful for data analysis.

Then moves to Power BI tools – Power Query, Power Pivot & Power BI – all built into Power BI Desktop training to help you visualize and analyze information quickly and efficiently.

Learn Power BI Data Analysis & Visualization MasterClass Training:

  1. Importing and creating relationships between tables of data.
  2. Understanding the optimal data structure to use in PowerBI.
  3. Writing basic Data Analysis eXpressions (DAX) formulas to extract business insights.
  4. Then write more advanced DAX formulas that use the power of DAX to extract additional business insights from the data that are not immediately obvious (yet are inherently available).
  5. An introduction and overview of Power Query. It covers How to use the tool to load data and cleanse it automatically in the future with fantastic Power Query.  
  6. Helping Excel professionals move from being an average user of Excel to being a Power BI analyst, covering the differences between the tools and how to start using Power BI Dashboards effectively.
From Excel user to Power BI Ninja — build live dashboards, write DAX measures, and publish reports to the cloud.
🖥️
Learn By Doing
Hands-on exercises on real Singapore business datasets from the very first module.
👥
Small Class Sizes
Capped at 25 participants for personal attention.
📧
Post-Training Support
If you need any help after attending the course, we offer email support to our participants.
What You'll Walk Away With
📊 Hands-on, practical training that takes you from raw data to interactive Power BI dashboards in just 2 days.
💡 Learn to write powerful DAX measures including CALCULATE(), Time Intelligence, and running totals.
🔄 Use Power Query to connect, clean, and auto-refresh data from hundreds of sources without manual effort.
☁️ Publish and share live dashboards to Power BI Service, with auto-refresh and mobile app access.
What You Will Learn

Power BI Skills You Will Master

🔗

Master Power Query to Load Any Data

Use Power Query to import, clean, and auto-refresh data from hundreds of sources into Power BI.

📐

Create DAX Measures for Business Insights

Write DAX formulas including CALCULATE(), ALL(), and Time Intelligence to surface hidden business insights.

⚡

Achieve Faster Results Than Excel Alone

Build data models and dashboards far more efficiently than with traditional Excel tools and methods.

📈

Produce Valuable KPI Metrics From Scratch

Design KPI dashboards and reports that surface critical business metrics that never existed before.

🛠️

Apply Tips and Tricks to Complex Problems

Use expert Power BI techniques and DAX patterns to solve real-world analytical challenges efficiently.

🖥️

Build and Publish Dashboards to Power BI Service

Publish completed reports and dashboards to the cloud with auto-refresh and mobile app sharing.

🗂️

Design Multi-Table Data Models Confidently

Create and troubleshoot relationships between multiple data tables within a single Power BI data model.

Is This For You?

Who Should Attend This Power BI Training?

📋

Finance & Accounting Executive

Spending hours consolidating large Excel datasets into management reports that still lack visual impact.

📉

Business Data Analyst

Struggling to produce complex performance analyses quickly enough to drive timely business decisions.

📣

Marketing & Sales Manager

Unable to track campaign ROI and sales trends in real time without relying on IT for every report.

🗄️

BI & Database Professional

Looking to expand into self-service BI reporting and dramatically increase analytical agility.

Beginners can easily learn Power BI and create data visualizations easily.

In this Microsoft Power BI course Singapore, we teach complete beginners. This Data Visualization With Power BI Training is suitable for beginners. It is better if you have some decent experience in using Excel on a day to day basis.

  • Intensive users of Excel, especially those responsible for reporting and analysis.
  • This training is useful for Bankers, Finance, and Accounting Executives who deal with a large amount of data and can change it into actionable form.
  • Data analysts can use it to derive complex performance analyses for actions to be taken.
  • Business users also use it to observe changes in data patterns to understand the performance of their investments in marketing, sales, and advertising.
  • Organizations looking to leverage
    Microsoft’s groundbreaking Power Pivot & BI offerings.
  • Business Intelligence and Database professionals looking to increase their professional agility and dramatically expand their capabilities.

The Excel Data Analysis training complements this course, if you use Excel for data analysis & Dashboard creation.

Before You Attend

Pre-Requisites for Data Analytics & Visualization With Power BI

It would be good if you have Basic knowledge of Excel, and can write simple formulas like SUM, IF, Nested IF, and:

  • Light usage of Excel PivotTables (or similar data analysis tools)
  • Familiarity with Excel functions like SUMIF and VLOOKUP are a plus
  • A passion for acquiring Data Analysis & Data Visualization Superpowers

Note: Anyone with Database, BI, Programming, or similar experience is quite qualified to take this course, even if lacking in good Excel experience.

Power BI for beginners Singapore  uses the POWER BI Desktop in the classroom.  The Power BI Desktop software is available for download from the Microsoft website for free. We will provide you with a copy of the application for use in the class.
You can opt to use the Intellisoft provided Laptop during classroom sessions. It will be fully loaded with the latest version of Power BI Desktop for your use in the SkillsFuture Power BI Course in Singapore.

Interested in mastering Power BI in Singapore?

Discover the best strategies on how to learn Power BI by enrolling in the best Microsoft Power BI Course offered by Intellisoft in Singapore.
Learn from Vinai Prakash, Intellisoft’s Founder and Master Trainer, who will guide you through creating and visualizing data with Power BI Dashboards in our Microsoft Power BI Singapore class.
Additionally, find out how to claim UTAP to offset your course fees on top of up to 70% WSQ Funding and SkillsFuture. Join now and enhance your data visualization skills!

🏛️  Up to 70% WSQ Funding available — Singaporeans pay as little as $300.

Curriculum

Power BI Course Outline

Module 1

Introduction to Power BI

  • When and why to use Power BI
  • Tour of the Power BI environment
Module 2

Loading Data from Hundreds of Data Sources

  • Various methods of data loading with Power Query
  • Tradeoffs in loading techniques
  • Best practices of loading and cleaning data in Power Query
  • Create a data model of multiple tables within Power BI
Module 3

Introduction to Formulas and DAX

  • Named reference syntax
  • Similarities to traditional Excel
  • Measures (Calc Fields) vs. Calc Columns
  • COUNTROWS() and DISTINCTCOUNT()
  • Best practices using Aggregator and Iterator Functions in Power BI Measure creation
Module 4

Working with Multiple Tables

  • Relationships: the end of VLOOKUP?
  • Data Tables vs. Lookup Tables
  • Multiple data tables in a single model
  • Troubleshooting relationship problems
  • Exercises to cement your learning
Module 5

The Magic of DAX Measures

  • The CALCULATE() function
  • ALL(), percentage of totals, and cancelling slicers
  • Introduction to Time Intelligence: Date/Calendar Tables
  • Running totals — Year to Date
  • Change versus Prior Month/Year
Module 6

What-If Analysis

  • Disconnected Tables and Slicers for What-If Analysis
Module 1

Recap and Advanced DAX

  • Recap of Day 1 concepts
  • Theory of the Vertipaq engine
  • FILTER() and Custom Calendars
Module 2

DAX Patterns for Common Problems

  • Counting things that didn't happen (e.g. customers without purchases)
  • Custom time intelligence patterns
Module 3

Power Query Deep Dive

  • When to use Power Query and why
  • Built-in transformations
  • The M language
  • Using Power Query to solve real-world problems
Module 4

Performance Optimisation

  • How to keep files small and calculations fast
  • Theory behind compression
  • Sharing and refreshing workbooks
  • Different web hosting options (SharePoint and Power BI Service)
  • Options to refresh workbooks easily
  • Creating advanced reports and dashboards
Module 5

Advanced Power BI Visualizations

  • Detailed review of Power BI vs Excel visualizations
  • Think differently and use all available visualizations
Module 6

Publishing Dashboards to Power BI Service

  • Cloud offering overview: sharing, Q&A, Analyze in Excel
  • Publishing dashboards to mobile apps
  • Using Power BI Mobile
Module 7

Microsoft's Best Kept Secret: Cube Formulas

  • Introduction to Cube Formulas
  • General Q&A session

Day One: Data Visualization Fundamentals With Microsoft Power BI

Introduction 

  • When and Why to Use Power BI
  • Tour of the Power BI Environment

Loading Data from Hundreds of Data Sources

  • Various Methods of Data Loading with Power Query
  • Tradeoffs in Loading Techniques
  • Best Practices of Loading & Cleaning Data in Power Query, a built-in tool within Microsoft Power BI.
  • Create a Data Model of Multiple Tables within Power BI

Introduction to Formulas and DAX using Microsoft Power BI

  • Named reference syntax
  • Similarities to traditional Excel
  • Measures (Calc Fields) vs. Calc Columns
  • COUNTROWS() and DISTINTCOUNT()
  • Best practices of using Aggregator & Iterator Functions in Power BI Measure creation

Working with Multiple Tables using Power BI

  • Relationships: the End of VLOOKUP?
  • Data Tables vs. Lookup Tables
  • Multiple Data tables in a single model
  • Troubleshooting your “relationship problems”
  • Exercises to cement your learning

The Magic of DAX Measures in Microsoft Power BI

  • The CALCULATE() function.
  • ALL(), percentage of totals, and “cancelling slicers.
  • Introduction to Time Intelligence: Date/Calendar Tables
  • Running totals – Year to Date,
  • Change versus Prior Month/Year Etc.

What-if Analysis using Disconnected Tables and Slicers

Day Two: Advanced Data Visualization With Power BI

Recap and More DAX

  • Recap of previous day
  • Theory of the Vertipaq engine
  • Filter() , Custom Calendars.

DAX Patterns for common problems using Power BI

  • Counting things that didn’t happen (eg customers without purchases)
  • Custom time intelligence patterns

Power Query

  • When to use it and why
  • Built-in transformations
  • The “M” language
  • Using Power Query to solve real-world problems.

Performance

  • How to Keep Your Files Small and Your Calculations Fast
  • The theory behind compression Sharing and Refreshing Workbooks
  • Different Web Hosting options (SharePoint and Power BI)
  • Options to refresh workbooks easily
  • Creating Advanced Reports and Dashboards with Power BI

Advanced Power BI Visualizations

  • A detailed review of what is different about Power BI vs Excel.
  • Learn to think differently and use the visualizations available.

Publishing Dashboards to Power BI Services

  • A detailed review of the cloud offering, including sharing, Q&A, Analyze in Excel, and publishing Dashboards to Mobile Apps.
  • Using Power BI Mobile

Microsoft’s Best Kept Secret Unveiled

  • Cube Formulas

General Q&A

This Power BI MasterClass Workshop has been rated the Best Power BI Training Course in Singapore by several of our participants, Companies and HRs.

Use this class to learn Power BI and get your entire team to master Power BI data visualizations, DAX, Power Query & online report publishing.

Intellisoft offers comprehensive Power BI training courses in Singapore to help individuals acquire Power BI certification Singapore. This Best Power BI course Singapore Skillsfuture program covers essential skills such as data visualization, dashboard creation, and data analysis.

Participants can expect hands-on training and practical exercises to enhance their understanding of Power BI tools and techniques. Enroll in WSQ Funded & SkillsFuture enabled Power BI courses Singapore today to master the art of visualizing data with PowerBI dashboards.

Your Trainer
👤
Your Trainer

Vinai Prakash

MBA Microsoft Certified Trainer 35+ Years Experience

Founder of Intellisoft Systems. Trained 45,000+ professionals across Singapore corporates, government agencies, and polytechnics, in several countries. Vinai has published articles on data analysis in The Straits Times and written content for leading business publications. He is the author of the bestselling book on Amazon - Excel Crash Course.

Trusted by professionals from 500+ organisations
Canon CPF Board OCBC NTU NUS Mindef HDB JTC ExxonMobil Sembcorp
AXA Epson NTUC Health DSO Toyota Asia Pacific BNY Mellon Ritz-Carlton Standard Chartered Singapore Police Force Tan Tock Seng Hospital

Training Course Fees & Funding

Full course fee: S$1,000.00 (before GST & government funding) TGS: TGS-2022016804

Highest Funding
70% Grant

70% SSG Grant

Baseline + Enhanced Training Support

  • SG Citizens aged 40+ (Individual, SME or MNC)
  • SME-sponsored SG Citizens (21+)
  • SME-sponsored PRs (21+)
Course Fee S$1,000.00
SSG Funding (70%) − S$700.00
Nett Fee S$300.00
GST (9%) S$90.00
You Pay S$390.00
SkillsFuture Credit UTAP Funding* SFEC (Company)
SSG Funded
50% Grant

50% SSG Grant

Baseline WSQ Funding

  • SG Citizens aged 21–39 (Individual or MNC)
  • MNC company-sponsored PRs (21+)
  • Individual PRs (21+)
Course Fee S$1,000.00
SSG Funding (50%) − S$500.00
Nett Fee S$500.00
GST (9%) S$90.00
You Pay S$590.00
SkillsFuture Credit UTAP Funding* SFEC (Company)
Foreigners & other pass holders: Government grants are not applicable. Full course fee of S$1,000.00 + 9% GST = S$1,090.00 applies. Contact us for more details.

Additional Funding Options

SF
SkillsFuture Credit

Singapore Citizens aged 25+ can use their SkillsFuture Credits to offset nett fees.
EC
SFEC (Enterprise Credit)

Companies sending local & foreign staff can claim up to $10,000 SFEC funding.
UT
UTAP (NTUC Members)

NTUC members can claim up to 50% of remaining fees (capped at $500/year).*

Need help with funding applications? We'll guide you through the process.

+65 6250-3575 WhatsApp Us

* Terms & conditions apply. Funding subject to eligibility and approval by respective agencies. GST applies on full course fee before subsidy. Fee information is accurate as of Apr 2026.

Register

Register for Data Analytics & Visualization With Power BI in Singapore

💬 Corporate / Group Enquiry
Date Duration Venue
13, 14 Apr 2026
 2 Days Fortune Centre, Singapore Register →
7, 8 May 2026
 2 Days Fortune Centre, Singapore Register →
9, 16 May 2026
 2 Days Fortune Centre, Singapore Register →
21, 22 May 2026
 2 Days Fortune Centre, Singapore Register →
8, 9 Jun 2026
 2 Days Fortune Centre, Singapore Register →
🏢 Running this for a group? Request a Custom Corporate Run →
What Participants Say

What Past Participants Say about this SkillsFuture Power BI Training Course

★★★★
The Power BI Master Class Training helped me to understand the DAX Measures, PowerPivot & Power BI thoroughly. It will help me in cleaning up data and producing management Dashboards.
N
Neptune Orient Lines Pte Ltd
★★★★
The PowerBI Training helped me to understand DAX, Learned Power Query, and PowerPivot & Power BI which can be immediately applied to our work.
A
Asian Development Bank
★★★★
Learned how to load millions of data rows quickly into Power BI, clean the data and create a data model. The amazing capabilities to Design Power BI Dashboards is great. It will help to revamp the manual consolidation files at work. Definitely recommend the PowerBI training for all business users.
T
Total Gas & Power Asia Private Ltd
★★★★
The most interesting things were the writing of DAX formulas, the building of complete dashboards from scratch, and the secret formulas to solve everyday simple problems. I learned to use the data cleanup, and it will improve my data visualization skills
C
Cathy Zheng
Data Analyst, SAF
★★★★
I loved the DAX Calculations and Visual Formatting techniques in creating Power BI management dashboards with our Power BI Trainer Mr. Vinai. He is an expert in conducting the Power BI Workshop, and showed us so many hidden tips and tricks
M
Mr. Neo
Director, AXS
★★★★
The Power BI course is Full of Examples, Depth of knowledge, ability to reference with what I need at Work, patience & never a minute is boring. The Best Corporate Power BI Training I have ever attended
J
Jennifer Lee
Rolls Royce Singapore
★★★★
Our Power BI Trainer Mr. Vinai Prakash is 1) very good in Storytelling which make it easy for me to understand, 2) he kept the lesson relevant, 3) While we make progress in the lesson, he kept his humor which make the PowerBI certification Course highly interesting.
C
Cilla Lim
Rolls Royce
★★★★★
Vinai is an awesome trainer and very knowledgeable. I learned to clean data first, write DAX and create visualizations with Microsoft Power BI Dashboards
M
Mark Lin
Manager, Singapore Cancer Society
★★★★
This was one of the most practical Power BI courses I’ve attended. Mr. Vinai explained complex concepts like data modelling, DAX calculations, and dashboard design in a very clear and structured way. The hands-on exercises helped me understand how to clean data using Power Query and build interactive dashboards for management reporting. I was able to apply what I learned immediately at work.
S
Sarah Lim
Business Analyst
★★★★
Excellent course for anyone who wants to move beyond basic Excel reporting. The Power BI training was very hands-on and focused on real business scenarios. I particularly liked the sections on data transformation, creating relationships between tables, and designing professional dashboards. The trainer, Mr Maymond was knowledgeable and patient, and the pace was just right for learners.
R
Rajesh Kumar
Operations Manager, Singapore
Common Questions

Frequently Asked Questions

What are the course fees and what government funding is available? ▾
The full course fee is S$1,000 before any government funding. Singaporeans and PRs above 40 years old or from SMEs can receive up to 70% WSQ funding from SkillsFuture Singapore (SSG), paying as little as S$300. Those below 40 years or from MNCs receive 50% funding, paying S$500. Individual Singaporeans aged 25 and above can also use their SkillsFuture Credits to further offset the cost.
Can NTUC members get additional funding for this Power BI course? ▾
Yes. NTUC members can utilise the Union Training Assistance Programme (UTAP) to offset an additional 50% of the remaining fees after WSQ funding has been applied. This makes the Power BI course significantly more affordable for union members. Contact Intellisoft at +65 6250-3575 for guidance on how to apply for UTAP alongside your WSQ grant.
How long is the Power BI course and where is it held? ▾
This is a 2-day intensive classroom training course held at Intellisoft's training rooms at Fortune Centre, 190 Middle Road, #10-08, Singapore 188979. The venue is a short walk from Bencoolen, Bugis, Rochor, and Bras Basah MRT stations, and is fully disabled-friendly. Tea, coffee, and light snacks are provided throughout the training.
What are the prerequisites for this Power BI training? ▾
A basic working knowledge of Microsoft Excel — including simple formulas like SUM and IF, and light use of PivotTables — is recommended. Familiarity with Excel functions like SUMIF and VLOOKUP is a bonus. Importantly, anyone with database, BI, or programming experience is also well-qualified to attend, even without strong Excel experience.
Do I need to bring my own laptop or install Power BI Desktop? ▾
No, you do not need to bring your own laptop. Intellisoft provides laptops pre-loaded with the latest version of Power BI Desktop for use during classroom sessions. Power BI Desktop is free to download from Microsoft's website, and Intellisoft will also provide you with a copy for use in class.
Will I receive a certificate upon completing this Power BI course? ▾
Yes. This is a WSQ-funded course approved by SkillsFuture Singapore (SSG). Participants who complete the course will receive a WSQ-accredited certification, which is recognised by employers across Singapore and supports your professional development in data analytics.
Who should attend this Power BI training course? ▾
This course is ideal for Excel power users, finance and accounting executives, data analysts, marketing and sales professionals, and business intelligence specialists who want to move beyond spreadsheets. It is also highly suitable for organisations looking to adopt Microsoft's Power BI, Power Pivot, and Power Query tools for self-service BI reporting. Both beginners and professionals with some data background will benefit.
Is post-course support available after the training? ▾
Yes. Intellisoft provides free post-course consultation related to the course subject matter. You can email your queries to training@intellisoft.com.sg and they will be forwarded to the subject matter experts. Corporate training on Power BI can also be arranged at your company premises for groups of 15 or more participants.
Keep Learning

Further Reading

Power BI
Data Model Creation and Considerations in Power BI
3 Mar 2025
Articles
Power BI Tip #5: All About Slicer Controls in Power BI
12 Jan 2025
Articles
How To Clean Data Using Power Query
21 Sep 2024
Articles
How To Learn Advanced Excel Fast
23 Jan 2026
Articles
From Data Frustration to Data Transformation: A Success Story
20 Jul 2023
Ready to Get Started?

Upgrade Your Skills.
Seats Fill Quickly.

Join thousands of professionals who've trained with Intellisoft. With WSQ funding, this is the most cost-effective way to upskill your team.

Secure Your Seat → 📄 Download Brochure 📞 +65 6250-3575

✉️ training@intellisoft.com.sg · We respond within 2 business hours

💬 Quick Enquiry

We respond within 2 business hours.

By submitting, you consent to Intellisoft collecting your data in accordance with Singapore's PDPA.

✅ Thank you! We'll be in touch shortly.
Data Analytics & Visualization With Power BI
Next class: 13, 14 Apr 2026 · Fortune Centre, Singapore · 2 Days
💬 Enquire 📄 Brochure View Dates & Register →
Course Brochure
Data Analytics & Visualization With Power BI

Enter your details and we'll send the full course brochure — complete outline, funding details, and registration instructions.

📬 Brochure sent within minutes · No spam · PDPA

Free · No Obligation
Wait — Before You Go
Get our free course brochure with full outline, fees, and grant details.

No spam · Unsubscribe anytime

Data collected in accordance with Singapore's PDPA.

Free Tips, Tutorials & Training Grants Info

Learn from expert tips, tricks and resources for Excel, PowerPoint, Photoshop, Python, Power BI, Project Management, IT, Soft Skills & more with our Email Newsletter.
Plus get the latest news on Grants. Join Today!

Yes! Send Me Exclusive Tips
Key Links
Facebook-f Youtube Twitter Linkedin-in Wordpress

Found What You Were
Looking For?

Just Tell us...

We're Here To Help You!