You have no items in your shopping cart.
Course Details
Course Details
What You'll Learn
Topic 1. Review Data with Power Query
- Data types explained
- Query data from a table or range
- Query data from another Excel file
- Load data only as a connection
- Fill up and fill down
- Split column by delimiter
- Split into rows
- Add conditional and custom columns
- Add column by example
- Merge columns
- Sort and filter data in Power Query
Topic 2. Data Analysis with Power Query and Power Pivot
- Use IF formulas
- Nest IF and AND
- AddDays to determine the deadline
- Pivot data in Power Query
- Pivot and append data
- Pivot and don't aggregate
- Unpivot data in Power Query
- Unpivot warnings
- Group By feature
- Appending Queries
Topic 3. Advanced Data Analysis using Power Query
- Overview of joins in Power Query
- Walk through all six joins
- Joins: Left or right
- Outer join versus XLOOKUP
- Merge with multiple fields
- Approximate match equivalent of VLOOKUP: Binning
- Approximate match equivalent of VLOOKUP: Conditional column
- Cross Join
- Drill down to create a variable in Power Query
- Fuzzy matching by percentage
- Merging inconsistent data with a transformation table
Course Info
Promotion Code
Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.
Minimum Entry Requirement
Knowledge and Skills
- Able to operate using computer functions
- Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)
Attitude
- Positive Learning Attitude
- Enthusiastic Learner
Experience
- Minimum of 1 year of working experience.
Target Age Group: 18-65 years old
Minimum Software/Hardware Requirement
Software:
- Python 3.x https://www.python.org/downloads/
Hardware: Window or Mac Laptops
Job Roles
Job Roles
- Data Analyst
- Business Analyst
- Financial Analyst
- Marketing Analyst
- Operations Analyst
- Business Intelligence Developer
- Report Developer
- Data Consultant
- Data Manager
- Risk Analyst
- Compliance Analyst
- Database Administrator
- Systems Analyst
- Performance Analyst
- Strategy Analyst
- Supply Chain Analyst
- Product Analyst
- Project Manager
- Research Analyst
- HR Analyst
Trainers
Trainers
Sanjiv i is an ACTA certified experienced leader with a proven track record in business / finance consulting and in developing i) business intelligence (BI) solutions ii) data analytics/analysis solutions and iii) IOT lead BI solutions. Sanjiv's goal through Prudentia Consulting, is to promote the simple joy and excitement of actively using the Microsoft Platform. He believes that the agility afforded by the Microsoft platform helps businesses get time back for deeper business thinking and to spend more time with their end customers
Sanjiv has rich experiences in diverse/complex high-tech businesses, turn around environments and strategic transformations. His functional expertise is in sales analytics, financial planning and analysis, engineering and program management. He has worked across discrete manufacturing, professional services and higher education verticals. He also has a working knowledge of equities portfolio management within the financial services domain.Sanjiv is the CEO of Prudentia Consulting, an organization committed to promoting the active usage of the Microsoft Platform. Prior to this, he has worked at Microsoft (US & APAC: 9.2 years), Cognizant Tech Solutions (3.3 years), Yazaki North America (8 years) and until recently at Oracle. Here are a few of his BI/analytics projects driven at scale: Built APAC wide BI dashboard using the Power BI umbrella tool set (Power BI online, Power BI desktop and Power Pivot) and a KPI lake (SQL DB), Helped develop key KPIs – identified key KPIs and helped land this in the DB, Developed a budget audit tool that captured budget inputs from a host of countries across the globe, Developed a business unit P&L reporting tool (functional architecture) in Business Objects for the world-wide financial planning and analysis team.
Ken Hiong is a ACTA certified trainer. Ken has over 20 years of work experience in the healthcare and pharmaceutical industry, having assumed various functional and managerial roles in sales, marketing, business development, finance, business analysis and planning. With an interest and experience in scripting, Ken has worked on projects using HTML, CSS, PHP, MySQL, WordPress, MS Office, VBA, Power BI, etc. Notably, Ken is a proven expert Excel user at work who has made efficient many work processes, improved data analysis and enhanced the quality of business planning and reporting for organizations.
Ken graduated with a Pharmacy degree, holds a Master of Business Administration from the National University of Singapore and a Master of Applied Finance from the University of Adelaide. An ardent advocate of lifelong learning, Ken is ACTA trained and seeks to continually upgrade his IT skills through various channels of learning and Microsoft certifications. With MS Office Master qualification, Ken looks forward to assisting individuals and corporations improve their computer skills, productivity and business outcomes.
Liew Sing Loon is a ACTA certified trainer. Liew Sing Loon graduated from the National University of Singapore (NUS) in 1992 with a Second Upper Honors Degree in Electrical Engineering. He started his career as an Electronic Product Design Engineer for four years in a Multinational Company which sell the products worldwide. The job provided him practical knowledge in various aspects of manufacturing operations ranges from Design, Quality, Production and Procurement. He then spent fifteen years in Information Technology Sector as a Key Account Manager in selling IT solutions to Banking, Telecommunications and Government clients. The job provided him the opportunities to propose IT solutions, integrating software, hardware and services, to solve customers’ problems to achieve their strategic business objectives. He joint a German Product Test company to develop its business in providing product Safety, Immunity, Electromagnetic Compatibility (EMC) Certification test. While working in the industry, Liew Sing Loon obtained a Master of Science (MSc) in Technology Management from NUS.
In the last decade, Liew Sing Loon has been Adjunct Lecturer in several Institutes of high learning, transferring his knowledge on Quantitative & Statistical Analysis, Operations, Project & Quality Management to learners ranging from Diploma, full time undergraduates and working adults.Liew Sing Loon has a Certificate of Completion in Education Psychology Course and Teaching & Learning in Higher Education Program conducted by National Institute of Education (NIE).
Dwight Nuwan Fonseka is Head of Data Science at Plano Pte. Ltd. and an ACLP-certified trainer with deep expertise in data analytics, machine learning, and AI applications. He has extensive hands-on experience developing predictive models, RShiny dashboards, and deep learning solutions using R, Python, TensorFlow, and Keras. With a strong professional background in healthcare, finance, and customer analytics, Dwight brings an applied perspective to teaching AI, focusing on both the opportunities and risks of emerging technologies.
Review
Customer Reviews (2)
- it was one of the most engaging and enriching learning experience Review by Course Participant/Trainee
-
I attended a Power Query and Pivot training session conducted by Alvin Ang, and I must say—it was one of the most engaging and enriching learning experiences I’ve had in a while.1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment
Alvin has a remarkable ability to tailor his teaching to suit the pace and learning style of each participant. His sessions are highly interactive, filled with real-world examples, and thoughtfully paced to ensure no one is left behind. What stood out most was how he connected technical concepts to broader societal trends, making the learning both relevant and inspiring.
He also encouraged us to see upskilling as a vital part of staying competitive in today’s fast-evolving world—a message that truly resonated with me.
With his deep expertise in Data Science, AI, and a wide range of analytical tools, combined with his passion for teaching and mentoring, Alvin is not just a trainer—he’s a true enabler of growth. I highly recommend him to anyone looking to build data capabilities, whether you’re just starting out or looking to deepen your expertise. (Posted on 10/21/2025) - All good Review by Course Participant/Trainee
-
Nur atikah binti shaari (Posted on 2/18/2024)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment
Write Your Own Review
- Recommended Courses
WSQ - Applications Integration with Power Apps and Power Automate
₹50,400.00 (GST-exclusive)
₹54,936.00
(GST-inclusive)
WSQ - Statistical Data Analysis with Excel for Beginners
₹22,050.00 (GST-exclusive)
₹24,034.50
(GST-inclusive)
WSQ - Data Analytics and Visualization with Power BI
₹50,400.00 (GST-exclusive)
₹54,936.00
(GST-inclusive)
WSQ - Software Automation with Excel VBA Programming
₹47,250.00 (GST-exclusive)
₹51,502.50
(GST-inclusive)
