Course Details
Course Details
What You'll Learn
Topic 1: Review Data with Power Query
Topic 2: Data Analysis with Power Query and Power Pivot
Topic 3: Advanced Data Analysis using Power Query
Course Info
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:
- Microsoft Excel for Microsoft 365 (Windows) with Power Query and Power Pivot https://www.microsoft.com/en-sg/microsoft-365/excel
Hardware: Windows laptop (Power Pivot is not available in Excel for Mac)
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
Dr. Alvin Ang is a data scientist and data science educator with a PhD in Operations Research, an MSc in Logistics and a BEng in Mechatronics, Robotics and Automation Engineering, all from Nanyang Technological University. Operations research is the mathematics of better decisions, and his published work on Kanban production-control systems at IEEE conferences reflects the quantitative rigour he brings to every class. He has served as an IBM Data Science Instructor, a Research Fellow at NUS, a Principal Consultant in data science and an Assistant Professor of Mathematics at SP Jain School of Global Management, where he was named Mathematics Professor of the Year, and he lectured undergraduates in statistics and quantitative methods at SUSS. Since 2021 he has trained professionals at Tertiary Infotech in Python, R, SQL, statistics, Excel analytics, Tableau, Power BI, Apache Spark, machine learning and deep learning, and he founded DataFrens.sg, a community for data scientists in Singapore. An ACLP-certified adult educator, he is known for connecting technical concepts to practical, real-world applications, a strength echoed in hundreds of learner recommendations.
In Excel Power Query and Power Pivot Masterclass, Dr. Ang shows how to get far more out of Excel as an analysis tool. Learners clean and structure data, analyse it with formulas, PivotTables, Power Query and Power Pivot, and present findings in clear charts and dashboards. As a data scientist who teaches Excel analytics alongside Python and R, he emphasises sound analytical thinking and repeatable workflows rather than one-off spreadsheets.
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).
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