TSY In House Training #896: Powerful Data Transformation In Power Query
Course Introduction:
Power Query is the FREE Excel add-in from Microsoft that will help transform and manipulate your data into a for-mat that is ready for PivotTables, reports, and so much more.
Power Query is also part of the component in Power BI for transforming data in order to create the Visualizations.
If you always have to spend a lot of time manually preparing your data for analysis, this Power Query training will teach you how to shave hours off your day with practical examples, tips, and tricks to transform your data in Power Query.
Date: 30th & 31th July 2026
Venue: NationGate Solution (M) Sdn. Bhd., Prai, Penang
Course Objectives:
Upon successful completion of this course, participant will be able to:
extract data from different sources into Power Query.
transform data in Power Query.
load data from Power Query to Excel.
add data model to the table loaded from Power Query to Excel.
understand the general errors in Power Query.
Prerequisite:
Participant must have at least intermediate knowledge & skill in Microsoft Excel.
Preferable having PivotTable and PivotChart skills.
Who Should Attend:
This course is designed for below users:
Excel Users
Users that employ Excel on a daily basis and want to exploit the full power of the new Excel Business Intelligence tools to improve their reporting and data crunching capabilities.
IT & BI Specialists
Professionals that are in charge of the data warehouse management of their company and need to understand how to provide support to analysts who need to extract data from different analytical and relational sources.
More Pictures:
Feel free to contact TSY Consultancy by Call / WhatsApp to +6012-6243921 or email to marketing@tsy.my
Cheers.
Comments