Register
Home Power Query & Power Pivot for Deep Analysis with Excel

Power Query & Power Pivot for Deep Analysis with Excel

Power Query & Power Pivot for Deep Analysis with Excel: WSQ Funded

What Will You Learn in Power Query and Power Pivot MasterClass

  • Import, clean, and transform data from multiple sources
  • Automate repetitive data preparation with step-by-step query building.
  • Merge, append, and reshape large datasets without writing formulas.
  • Create relationships between multiple tables to build data models.
  • Use Power Pivot to handle millions of rows of data with ease
  • Write and apply DAX  for advanced calculations and measures.
  • Build hierarchies, KPIs, and calculated columns for deeper insights.
  • Design interactive Pivot directly from data model.
  • Optimize and manage Excel Data Model for better performance
  • Real case studies to combine Power Query + Power Pivot

Training Course Fees

The full course fees for this training is S$1,000, before any Government funding.
For Singaporean/PR above 21 years, Training Grants are available.
For Foreigners, no government grants are available.

Grant Information

WSQ funding from SkillsFuture Singapore (SSG) is available to Singaporeans/PRs above 21.
(Both Individuals & Company Sponsored ).

Individual Singaporeans, 25 years & above can also use their SkillsFuture Credits for this training at Intellisoft.

Companies sending Locals & Foreign staff for training can avail SFEC Funding. 
Use it to improve the skills of your entire department!

NTUC Members can utilize UTAP Funds to offset 50% of the remaining fees*.

Contact us for more information on How to apply for this SkillsFuture Grant.
Call +65-6252-5033 for Details or WhatsApp Now at +65-9066-9991

up to 70% Grant

$700 Funding by SSG
Pay $300
  • Singaporeans Above 40 Years
  • Individuals
  • SME Companies
  • Individuals Can Use SkillsFuture
  • UTAP Funding*

up to 50% Grant

$500 Funding by SSG
Pay $500
  • Below 40 Years
  • Individuals
  • SG / PR / MNC Companies
  • SkillsFuture (Singaporeans only)
  • UTAP Funding*
Pick Training Date & Register

Highly Trusted & Quality WSQ Course in Singapore at Intellisoft

Course Outline

Target Audience

Grant Info

Course Dates

Register

Contact Us

Course Overview

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.

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.

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.

Course Outline

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

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

Target Audience

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:

  1. Data Analysts: Professionals who analyze and interpret data regularly and want to leverage advanced Excel tools for more efficient and insightful analysis.
  2. Business Intelligence Professionals: Individuals involved in creating reports, dashboards, and data visualizations who seek to enhance their skills in data modeling and manipulation.
  3. Financial Analysts: Those responsible for financial modeling, forecasting, and budgeting who want to streamline data handling and improve accuracy in their analyses.
  4. 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.
  5. 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.
  6. 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.

Pre-Requisites

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

  1. Proficiency in Excel: Participants should be familiar with basic to intermediate Excel functionalities, including navigating through worksheets & using simple formulas and functions.
  2. Understanding of Data Concepts: A basic understanding of fundamental data concepts such as tables, rows, columns, and data types is recommended.
  3. Familiarity with Data Analysis: Some experience in data analysis tasks like sorting, filtering, and basic data manipulation within Excel will be beneficial.
  4. 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.

Grant Information

WSQ: To claim WSQ Funding for this Power Query & Power Pivot course, participants must be either individual Singaporeans/PRs, OR Company Sponsored Singaporeans/PRs. You can get up to 50% to 70% WSQ Grant.

SkillsFuture for Microsoft Power Query & Power Pivot Training: Individual Singaporeans aged 25 and above can use their SkillsFuture Credits to offset the unfunded portion to learn how to use Power Query & Power Pivot for deep data analysis in Excel or Power BI.

Only Skills Future Credit (Opening Credit) and One-off SkillsFuture Credit Top-Up can be used for this course.

SkillsFuture Credit (Mid-Career) CANNOT be used for this course.

UTAP Funding: NTUC Members can utilize UTAP to offset 50% of the remaining fees*.

Call us at 6250-3575 or email us for any questions or to register for the upcoming class of Power Query and Power Pivot in Excel with SkillsFuture &WSQ funding.

Do You Have Any Questions

on Course Fee, WSQ Grant or Funding?

Ask Us. We’ll be happy to assist you.

Training Schedule

13, 14 Oct 2025
18, 25 Oct 2025
27, 28 Nov 2025
22, 23 Jan 2026

Register

Intellisoft offers WSQ funded, UTAP supported SkillsFuture Credits Ready Courses in Singapore

To register for the “Power Query & Power Pivot for Deep Analysis with Excel” course, you have several convenient options:

  1. Online Registration: Visit our website and navigate to the registration page. Fill out the online registration form with your details and course preferences. You can typically find the registration link under the course description or on our homepage.
  2. Walk-in Registration: Feel free to visit our office during business hours. Our staff will be happy to assist you with the registration process in person. You can find our office address and hours of operation on our website.
  3. Email Registration: Send us an email indicating your interest in the course. Include your name, contact information, and any specific questions you may have. Our team will respond promptly and guide you through the registration steps via email.
  4. WhatsApp: If you prefer to communicate via WhatsApp, send us a message with your name and the course you wish to register for. We will reply with further instructions and assist you through the registration process.
  5. Drop by Our Office: If you’re in the City Area around Bugis, Rochor, Bencoolen, Bras Basah, Dhoby Ghat, you can drop by our office directly at Fortune Centre. Our staff will be available to answer your questions and assist you with completing the registration form on-site.

For more information about the course, feel free to email us at training@intellisoft.com.sg or reach out via WhatsApp at +65-90669991. We look forward to helping you register and start your journey with Power Query and Power Pivot for deep analysis with Excel!

Why Choose Us?

ACTA Certified Trainers

Authorized Training Organization

WSQ
Certifications

Fully Set Up
Training Room

20+ Years
Experience in Education

Practical, Hands-on
Training

25,000+
Certified Students

32+
Courses

Useful & Handy
Student Guide

Contact Us

We are located at Fortune Centre, 190 Middle Road, #10-08 Singapore 188979

Click here for For Directions 

Telephone: 6252-5033  WhatsApp: 9066-9991

Email: info@trainingint.com

Our Clients

                 

Related Links

Want To Learn Photoshop?

Get our Latest Photoshop Tips by email.

Useful Articles

Training Schedule

Search

Want To Learn Excel Fast?

Get Excel Tips, Tricks & Shortcuts By Email.