Power Query & Power Pivot for Deep Analysis with Excel

Transform Excel Data Using Power Query and Power Pivot

23+

Years

120+

Courses

3,460+

Corporate Clients

45,000+

People Trained

View Dates & Register → 💬 Enquire About This Course

Trusted by

WSQ Accredited · Intellisoft

Next Available Date

📅 Next Class ⚡ 23, 24 Apr 2026

+4 more dates available ↓

Course Details

⏰ Duration 2 Days

📍 Venue Fortune Centre, Singapore

👥 Class Size Up to 15 Pax

🎓 Certificate ✓ WSQ Certificate Issued

Accreditation

🔖 TSC Code RET-RAN-3002-1.1

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

About This Course

About This Power Query & Power Pivot for Deep Analysis with Excel Course

Power Query and Power Pivot in Excel Course at Intellisoft Singapore

Power Query is a feature in Excel that allows you to quickly import data from multiple sources and easily clean, transform, and reshape it to suit your needs.

We show you how to use this powerful, time-saving tool to do deep cleansing of data, and then do a deeper analysis of data with Microsoft Excel’s Power Pivot.

This course teaches you how to import, merge, rearrange, and clean data, as well as how to repeat the process with one click if the data changes.

Power Query Training in Singapore at Intellisoft

Discover how to split columns, unpivot data, and use joins to merge, segment, and compare datasets.

Data Analysis Expressions (DAX) allow Microsoft Excel users to create powerful calculated fields in Power Pivot. In this course, you will learn how to use the DAX language and Power Pivot to explore and analyze relational data models. You will master how to add calculated columns and measures to data models in Excel.

Power Pivot Options in Excel - Learn Power Pivot with WSQ Funding in Singapore at Intellisoft

We highlight the differences between calculated columns and DAX measures, covers common DAX formulas and functions, and discusses best practices for working with DAX and Power Pivot.

Full of dozens of tips, tricks & techniques in this comprehensive, practical, hands-on training using Power Query and Power Pivot in Excel for Deep Data Analysis.

Learn to clean, combine, and model large datasets in Excel using Power Query and Power Pivot for faster analysis and powerful data-driven reporting.

🖥️

Learn By Doing

Hands-on exercises on real Singapore business datasets from the very first module.

👥

Small Class Sizes

Capped at 15–20 participants for personal attention.

📧

Post-Training Support

30-day free email support after the course to training@intellisoft.com.sg.

What You'll Walk Away With

🧹 Clean and transform messy datasets using Power Query’s automated data preparation tools.

🔗 Combine data from multiple files, tables, and sources into a single analytical model.

📊 Build powerful data models using Power Pivot relationships and advanced PivotTables.

⚡ Automate repetitive Excel data preparation tasks for faster reporting and analysis.

What You Will Learn

What You Will Learn in Power Query & Power Pivot for Deep Analysis with Excel

🧹

Apply Data Transformation Using Power Query

Apply Power Query tools to clean, reshape, and prepare raw datasets for analysis.

🔗

Combine Multiple Data Sources Efficiently

Combine and append multiple datasets using Power Query for integrated reporting.

📊

Build Excel Data Models Using Power Pivot

Build relational data models using Power Pivot tables and relationships.

📐

Create Advanced PivotTable Reports

Create advanced PivotTables and analytical reports using Power Pivot models.

🧠

Analyse Large Datasets Efficiently

Analyse large datasets efficiently using Power Pivot and Excel analytics features.

⚙️

Automate Data Preparation Workflows

Automate repetitive data preparation steps using reusable Power Query transformations.

Is This For You?

Who Should Attend Power Query & Power Pivot for Deep Analysis with Excel?

📊

Data Analyst

You spend too much time cleaning and combining Excel data manually.

📈

Business Analyst

You struggle to analyse large datasets efficiently using traditional Excel methods.

👔

Reporting Executive

You need faster ways to prepare and update recurring Excel reports.

💼

Finance Analyst

You work with multiple data sources and need a reliable way to consolidate them.

The target audience for the “Power Query & Power Pivot for Deep Analysis with Excel” course includes professionals and individuals who work extensively with data in Excel and wish to deepen their analytical capabilities. This course is ideal for:

Data Analysts: Professionals who analyze and interpret data regularly and want to leverage advanced Excel tools for more efficient and insightful analysis.
Business Intelligence Professionals: Individuals involved in creating reports, dashboards, and data visualizations who seek to enhance their skills in data modeling and manipulation.
Financial Analysts: Those responsible for financial modeling, forecasting, and budgeting who want to streamline data handling and improve accuracy in their analyses.
Excel Power Users: Individuals already proficient in Excel who want to expand their toolkit with Power Query and Power Pivot for more sophisticated data transformations and analysis.
Managers and Decision-Makers: Leaders who rely on data-driven insights to make informed decisions and wish to improve their ability to extract and present meaningful insights from data.
IT Professionals and Consultants: Those tasked with managing and optimizing data workflows within organizations who want to leverage Excel’s capabilities for enhanced data management and reporting.

Overall, the course is suitable for anyone looking to advance their Excel skills specifically for data analysis, whether in business, finance, consulting, or other fields where data-driven decision-making is critical.

Before You Attend

Pre-Requisites for Power Query & Power Pivot for Deep Analysis with Excel

To join the “Power Query & Power Pivot for Deep Analysis with Excel” course, participants should ideally have the following prerequisites:

Proficiency in Excel: Participants should be familiar with basic to intermediate Excel functionalities, including navigating through worksheets & using simple formulas and functions.
Understanding of Data Concepts: A basic understanding of fundamental data concepts such as tables, rows, columns, and data types is recommended.
Familiarity with Data Analysis: Some experience in data analysis tasks like sorting, filtering, and basic data manipulation within Excel will be beneficial.
Motivation to Learn: An eagerness to explore advanced data manipulation techniques and a willingness to engage in hands-on exercises and case studies throughout the course.

These prerequisites will ensure that participants can effectively engage with the course content, grasp advanced concepts in Power Query and Power Pivot, and apply their knowledge to real-world data analysis challenges using Excel.

🏛️ Up to 70% WSQ funding available for eligible Singaporeans and PRs.

Curriculum

Power Query & Power Pivot for Deep Analysis with Excel: Course Outline & Curriculum

Module 1

Introduction to Power Query

Power Query overview
Importing data into Excel
Connecting to multiple data sources
Understanding Query Editor
Power Query workflow basics

Module 2

Data Transformation Using Power Query

Filtering and sorting data
Splitting and merging columns
Removing duplicates
Changing data types
Using applied steps

Module 3

Combining Data Sources

Appending queries
Merging queries
Working with multiple tables
Managing query dependencies
Loading data into Excel tables

Module 1

Introduction to Power Pivot

Power Pivot overview
Creating Power Pivot data models
Understanding relationships
Managing large datasets
Using Power Pivot window

Module 2

Working With Data Models

Creating table relationships
Understanding star schema
Building analytical data models
Using calculated columns
Using measures in Power Pivot

Module 3

Reporting With Power Pivot

Creating PivotTables from data models
Using slicers for filtering
Advanced PivotTable analysis
Building interactive Excel reports
Best practices for Excel data models

Power Query & Power Pivot for Deep Analysis with Excel

Course Outline

Day 1: Power Query Essentials and Intermediate Techniques

Power Pivot Data Model Training in Singapore at Intellisoft

Module 1: Introduction to Power Query

Understanding the Role of Power Query in Data Preparation
Navigating the Power Query Interface
Key Use Cases of Power Query in Business Scenarios
Differences Between Power Query in Excel and Power BI

Module 2: Data Transformation Basics

Importing Data from Various Sources (Excel, CSV, SQL, Web, etc.)
Data Cleaning Techniques: Removing Errors, Replacing Values
Reordering Columns and Rows for Analysis
Splitting and Merging Columns

Module 3: Advanced Data Transformation

Advanced Filtering Techniques for Targeted Data Extraction
Creating Custom Columns with Conditional Logic
Using the Fill Down and Fill Up Features for Missing Data
Advanced Grouping and Aggregating Techniques for Summarized Data

Module 4: Introduction to M Language

Exploring the M Language Syntax and Structure
Editing Queries Directly in the Advanced Editor
Creating Custom Functions for Reusable Logic
Common M Functions for Data Manipulation (e.g., Table.TransformColumns, Text.Combine)

Module 5: Case Studies and Practical Exercises

Real-World Scenario: Preparing Sales Data for Reporting
Combining Data from Multiple Files and Folders
Practice Exercises with Provided Datasets
Group Discussion on Common Data Challenges

Day 2: Power Pivot and Advanced Analytics

Module 6: Introduction to Power Pivot

Overview of the Power Pivot Add-in: Activation and Setup
Loading Data into the Power Pivot Data Model
Understanding Table Relationships: One-to-One, One-to-Many
Creating Hierarchies for Advanced Data Navigation

Module 7: DAX Fundamentals

Overview of DAX: Syntax and Functions
Understanding Row Context vs. Filter Context
Creating Basic Calculated Columns and Measures
Using Aggregation Functions (SUM, AVERAGE, COUNT, DISTINCTCOUNT)

Module 8: Advanced DAX Techniques

Time Intelligence Functions: Calculating YTD, QTD, MTD, and Rolling Averages
Advanced Logical Functions: SWITCH, IFERROR, CALCULATE
Working with Iterative Functions: SUMX, AVERAGEX
Troubleshooting DAX Formulas and Debugging Errors

Module 9: Optimizing Data Models

Understanding the Importance of Star and Snowflake Schemas
Best Practices for Efficient Data Models: Reducing File Size, Avoiding Duplicates
Using the Diagram View for Relationship Management
Performance Tuning: Analyzing and Optimizing Query Performance

Module 10: Advanced Analytics and Reporting

Creating Slicers and Filters for Interactive Dashboards
Designing Effective Power Pivot Reports with Visual Insights
Using KPIs to Track and Display Key Business Metrics
Integrating Power Query and Power Pivot for Dynamic Reporting

Module 11: Final Project and Review

Hands-On Project: Building an Interactive Dashboard from Raw Data
Applying Power Query and Power Pivot to Solve Business Problems
Course Recap: Key Takeaways and Best Practices

These objectives aim to provide participants with a comprehensive understanding and practical skills in leveraging Power Query and Power Pivot for deep data analysis within Excel, preparing them to handle complex data challenges effectively.

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

Training Course Fees & Funding

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

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

SkillsFuture Credit

Singapore Citizens aged 25+ can use their SkillsFuture Credits to offset nett fees.

SFEC (Enterprise Credit)

Companies sending local & foreign staff can claim up to $10,000 SFEC funding.

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 for Power Query & Power Pivot for Deep Analysis with Excel in Singapore

💬 Corporate / Group Enquiry

Date	Duration	Venue
23, 24 Apr 2026	2 Days	Fortune Centre, Singapore	Register →
21, 22 May 2026	2 Days	Fortune Centre, Singapore	Register →
23, 24 May 2026	2 Days	Fortune Centre, Singapore	Register →
11, 12 Jun 2026	2 Days	Fortune Centre, Singapore	Register →
20, 21 Jul 2026	2 Days	Fortune Centre, Singapore	Register →

🏢 Running this for a group? Request a Custom Corporate Run →

Common Questions

Frequently Asked Questions

How much does the Power Query and Power Pivot course cost and are there grants available? ▾

The course fee may be eligible for WSQ funding depending on participant eligibility. Singaporeans and Permanent Residents may receive up to 70% funding under SkillsFuture or related schemes. Learners may also use their SkillsFuture Credit to offset the course fee. Contact Intellisoft Systems to confirm the latest funding eligibility and payable amount.

How long is the Power Query and Power Pivot training course? ▾

The course is delivered as a 2-day instructor-led training programme. Participants spend the sessions learning both Power Query and Power Pivot through guided exercises and practical examples. The structure allows learners to understand the full data workflow from data preparation to reporting. Hands-on practice ensures participants can apply the techniques immediately at work.

What prerequisites are required before attending this Excel course? ▾

Participants should already have basic working knowledge of Microsoft Excel before joining the course. Familiarity with worksheets, tables, and basic formulas will help learners follow the training more easily. Prior experience with PivotTables is helpful but not mandatory. The course focuses on advanced Excel analytics tools such as Power Query and Power Pivot.

Will participants receive a certificate after completing the course? ▾

Participants typically receive a certificate of completion after attending the training. Full attendance is usually required, especially if the course is taken under a funding scheme. Some programmes may include simple assessments or exercises as part of the learning process. The certificate demonstrates that the participant has completed Power Query and Power Pivot training.

Where is the Power Query and Power Pivot course conducted? ▾

The classroom-based training is conducted at Intellisoft Systems training centre located at Fortune Centre, 190 Middle Road, #14-05, Singapore 188979. The facility is equipped for hands-on training with computers and practice datasets. Organisations may also request corporate training sessions at their office location. This allows teams to learn using real company datasets.

Who should attend the Power Query and Power Pivot course? ▾

This course is designed for professionals who regularly work with Excel data and need more efficient analysis tools. It is particularly useful for analysts, finance professionals, reporting executives, and business analysts. Anyone responsible for preparing large datasets or recurring reports will benefit from these skills. The course helps transform Excel into a powerful data analytics platform.

How can I register for the Power Query and Power Pivot course? ▾

You can register through the course page by selecting a scheduled class date. Alternatively, you can contact Intellisoft Systems via phone or email to confirm schedules and seat availability. Organisations planning group training can also request a corporate training proposal. Early registration is recommended because class sizes are limited.

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

Chat on WhatsApp

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

💬 Quick Enquiry

✅ Thank you! We'll be in touch shortly.

Power Query & Power Pivot for Deep Analysis with Excel

Next class: 23, 24 Apr 2026 · Fortune Centre, Singapore · 2 Days

💬 Enquire 📄 Brochure View Dates & Register →

Power Query & Power Pivot for Deep Analysis with Excel

About This Power Query & Power Pivot for Deep Analysis with Excel Course

What You Will Learn in Power Query & Power Pivot for Deep Analysis with Excel

Apply Data Transformation Using Power Query

Combine Multiple Data Sources Efficiently

Build Excel Data Models Using Power Pivot

Create Advanced PivotTable Reports

Analyse Large Datasets Efficiently

Automate Data Preparation Workflows

Who Should Attend Power Query & Power Pivot for Deep Analysis with Excel?

Data Analyst

Business Analyst

Reporting Executive

Finance Analyst

Pre-Requisites for Power Query & Power Pivot for Deep Analysis with Excel

Power Query & Power Pivot for Deep Analysis with Excel: Course Outline & Curriculum

Introduction to Power Query

Data Transformation Using Power Query

Combining Data Sources

Introduction to Power Pivot

Working With Data Models

Reporting With Power Pivot

Power Query & Power Pivot for Deep Analysis with Excel

Course Outline

Day 1: Power Query Essentials and Intermediate Techniques

Module 1: Introduction to Power Query

Module 2: Data Transformation Basics

Module 3: Advanced Data Transformation

Module 4: Introduction to M Language

Module 5: Case Studies and Practical Exercises

Day 2: Power Pivot and Advanced Analytics

Module 6: Introduction to Power Pivot

Module 7: DAX Fundamentals

Module 8: Advanced DAX Techniques

Module 9: Optimizing Data Models

Module 10: Advanced Analytics and Reporting

Module 11: Final Project and Review

Your Trainer

Vinai Prakash

Training Course Fees & Funding

70% SSG Grant

50% SSG Grant

Additional Funding Options

Register for Power Query & Power Pivot for Deep Analysis with Excel in Singapore

Frequently Asked Questions

Further Reading

Upgrade Your Skills.Seats Fill Quickly.

💬 Quick Enquiry

Free Tips, Tutorials & Training Grants Info

Key Links

Found What You Were Looking For?

Just Tell us... We're Here To Help You!

Upgrade Your Skills.
Seats Fill Quickly.

Found What You Were
Looking For?

Just Tell us...

We're Here To Help You!