University Pathways

Discover how Singapore Polytechnic helps students transition to top universities with a robust curriculum and university accelerated pathway programmes.

Know more

SP Open House

This year, come find out how SP helps discover what it means to be the main character of you own future! Visit our academic schools and facilities, speak to your future seniors and lecturers and have all your burning questions answered!

Know more

Overview

Course Date:

16 Dec 2026 to 16 Dec 2026

Registration Period:

16 Oct 2026 to 25 Nov 2026

Duration/Frequency:

8 hours|Weds|9am-6pm

Mode of Training:

Face-to-Face (Classroom Teaching)

What You Will Learn

This course equips participants with hands on skills to clean, reshape, and combine data from multiple sources with Power Query - a practical data preparation and automation tool built into Microsoft Excel and Power BI. It will help reduce manual effort and improve data accuracy for everyday work.

Designed for working professionals regularly handling data, they will course focus on guided practice using realistic workplace datasets. They will build simple, repeatable data transformation workflows directly applicable to reporting, consolidation, and analysis tasks, with support from Generative AI tools to speed the process up and simplify it.

The course emphasises practical demonstrations and scenario-based exercises that reflect common data challenges faced by organisations face.

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

Describe the role of Power Query in preparing data and organising it.
Import data from common sources like Excel, CSV, and web links.
Apply core cleaning and transformation steps using the Power Query Editor.
Build simple, repeatable workflows to automate data preparation tasks.
Combine datasets with basic merge and append techniques.
Use basic M expressions to customise selected transformations.
Export cleaned data for reporting or further analysis.

Topics to be covered

Module 1: Introduction and Data Connections

(a) What is Power Query?
(b) Benefits and use cases
(c) Overview of the Power Query interface
(d) Connecting to data sources (Excel, CSV, web, databases)
(e) Refreshing queries and handling connection error

Module 2: Data Cleaning and Transformation

(a) Removing duplicates and errors
(b) Filtering, sorting, replacing values, and handling blanks
(c) Splitting and combining columns
(d) Pivoting and unpivoting data
(e) Changing data types and using conditional columns

Module 3: Advanced Techniques and Integration

(a) Combining data (merging, appending, using parameters)
(b) Grouping and aggregating data
(c) Creating custom columns using M language
(d) Best practices for query design
(e) Power Query in Power BI vs Excel
(f) Refreshing, scheduling, and sharing cleaned data

Overview

Course Date:

Registration Period:

Duration/Frequency:

Mode of Training:

What You Will Learn

Sustainability Essentials for Enterprises

Certificate in Teaching and Learning for Adjunct Lecturers

Certificate in Teaching Practices for Adjunct Lecturers

Prevention And Response To Violence And Harassment, Including Sexual Harassment, Bullying And Sexual Assault (SASH) In The Maritime Sector (Asynchronous e-learning)