Data Transformation with Power Query

Working with data can be tedious, especially when dealing with large datasets in Excel. Power Query simplifies data transformation, making it easier to clean, reshape, and analyze data without complex formulas or manual work.

Join this free 4-hour virtual training session to learn how to:

• Understand the basics of Power Query and its interface
• Connect and import data from various sources
• Transform and clean data efficiently
• Automate repetitive data processing tasks
• Merge, append, and manipulate datasets with ease

Whether you are a beginner or looking to sharpen your skills, this session will provide hands-on guidance to make your data workflows more efficient. Don't miss this opportunity to master one of Excel’s most powerful tools!

The topic covers:

Module 1: Basics of Power Query

• What is Power Query?
• Why should we learn Power Query?
• Where is Power Query?
• The Power Query Editor – Basic anatomy
• Basics of data types & operators

Module 2: The Power Query Editor Interface

• Getting familiar with PQ interface
• Transforming data
• The applied steps
• Formatting data
• Basics of data types & operators

Module 3: Getting Data

• Getting data from Excel file
• Getting data from Text File/CSV (Comma Split Values)

Module 4: Data Transformation

• Transforming Data
• Formatting Data
• Replace Value
• Merging Titanic Survival data with Titanic Passengers data

Trainer Details

Alex Ooi is a data analytics expert with over seven years of specialized experience transforming complex business requirements into actionable technical solutions. With his unique blend of accounting background and technical expertise, Alex empowers organizations to make data-driven decisions with confidence.

As a Microsoft Power BI Data Analyst Associate and Associate Chartered Management Accountant (ACMA), Alex combines financial acumen with technical proficiency to deliver exceptional results. His track record includes developing Python-based automation tools that significantly reduced operational time and implementing robust data infrastructures that strengthened marketing effectiveness.

Throughout his career at industry leaders like Heineken Malaysia, Coca-Cola, and EY Analytics, Alex has consistently delivered measurable results—including a proprietary profitability analysis adopted across Heineken's APAC region and automation processes that saved 60+ man-hours monthly at Coca-Cola.

Alex excels in creating sustainable data ecosystems that minimize technical debt while maximizing business value. His consultancy focuses on three key pillars: enabling clients to control their data narratives, shifting organizational perspectives, and facilitating entry into new data horizons through hands-on workshops and training.

For organizations seeking to enhance visibility, efficiency, and profitability through data, Alex delivers purpose-driven solutions that transform complex information into strategic assets for meaningful business growth.