Introduction To Power Query
1 Day
From RM 5,000*
Remark:
Excluding labs & exams (if applicable, need to add-on)
Private in-house training at employer's venue
Minimum 5 pax up to maximum 25 pax per session (depending on the trainer)
HRDC Claimable Course
This intensive one-day Introduction to Power Query course equips business and data professionals with essential skills to automate data preparation tasks in Excel and Power BI. Designed for those who regularly work with data, the training combines technical instruction with practical application through real-world case studies.
The course begins with Power Query fundamentals, introducing its interface and capabilities before quickly advancing to hands-on data extraction from various sources including Excel, CSV files, folders, and PDFs. You'll master core transformation techniques such as splitting and merging columns, formatting data, extracting values, and replacing content—skills that dramatically reduce manual data cleaning time.
A significant portion focuses on data consolidation using Append and Merge functions, enabling you to combine data from multiple sources into cohesive datasets without complex formulas or manual copying. The training emphasizes best practices for creating efficient, maintainable queries that can be refreshed and updated as source data changes.
The course culminates with applied case studies covering financial analysis, acquisition due diligence, time series analysis, and product dimension reporting. These exercises reinforce learning through realistic scenarios, while timed speed challenges develop your ability to solve data transformation problems efficiently.
After completing this training, you'll immediately apply these skills to streamline daily data tasks—transforming hours of manual data cleaning into minutes of automated work. The knowledge gained will help you produce more accurate analyses, create refreshable reports that update automatically when source data changes, consolidate information from multiple files without error-prone copy-pasting, and standardize inconsistent data formats. These practical capabilities translate directly to increased productivity and more reliable insights in any role involving data analysis.
Trainer Details
Industry Practitioners: Trainers with hands-on experience in the field, bringing real-world applications to the training.
Corporate Training Specialists: Professional trainers with a strong track record in corporate learning and development.
Executive Coaches & Thought Leaders: Elite trainers who have coached senior executives and industry leaders.
KK Cheah
Corporate Training Specialists
Private in-house training at employer's venue
Minimum 5 pax up to maximum 25 pax per session
With over 28 years of IT industry experience and 23 years specializing in computer training, Cheah Keng Kean is a distinguished Malaysian tech educator with exceptional credentials. As a Microsoft Certified Trainer holding numerous advanced certifications (MCSD, MCDBA, MCSE, MCITP), he delivers expert instruction across a comprehensive range of Microsoft technologies.
Cheah combines deep technical knowledge with practical implementation skills, having developed sophisticated systems like DSS (Decision Support System) using Oracle and CADATS using C/C++. His expertise spans SQL Server, SharePoint, Visual Studio, .NET frameworks, and various programming languages including C#, VB, and ASP.
Having served prestigious organizations like Nota Asia, New Horizons, and Informatics Singapore, Cheah has cultivated a reputation for delivering high-quality training while openly sharing his knowledge and experience. His impressive client portfolio includes industry leaders such as Petronas, Shell, Microsoft, Dell, HP, major Malaysian banks, universities, and government agencies.
Fluent in English and Bahasa Malaysia, Cheah excels in both classroom instruction and practical consultancy, helping organizations implement effective database solutions and custom analytical reports. His background as an analyst programmer provides him with valuable real-world insights that enhance his teaching methodology.
For comprehensive, expert-led IT training from a seasoned professional with proven industry experience, Cheah Keng Kean offers unparalleled technical expertise combined with exceptional instructional skills.
Alex Ooi
Industry Practitioners
Private in-house training at employer's venue
Minimum 5 pax up to maximum 25 pax per session
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.
Get in touch with us
Fill in your details, and we’ll provide you with a customized quotation, detailed trainer profiles, and a comprehensive course outline. Select your preferred trainer category to find the perfect fit for your team’s needs!