Introducing Microsoft Excel’s powerful data modeling and business intelligence tools: Power Query, Power Pivot, and Data Analysis Expressions (DAX). Learn today.
SkillsFuture Credit Claimable
Have hands-on experience with Power Query; a tool that extract, cleanse, transform, and load data from flat files, folders, databases and more. You’ll practice shaping, blending and exploring the project files, and create completely automated loading procedures with only a few clicks.
Explore the Data Modeling and cover the fundamentals of database design and normalization (including table relationships, hierarchies and more). You’ll take a tour through Excel’s data model interface, and then create your own relational database to analyze throughout the course.
Use Power Pivot and DAX to explore and analyze the data model. Unlike traditional Pivot Table, Power Pivot allows you to analyze hundreds of millions of rows across multiple data tables, and create powerful calculated fields and measures using a formula language called Data Analysis Expressions (or “DAX” for short). You’ll learn basic DAX syntax, then introduce some of the most commonly-used and powerful functions like CALCULATE, FILTER, SUMX and more.
$750 ($802.50 Inc. GST) per participant
SDF grant entitled, 1 hour lunch not claimable
Skillsfuture Credit eligible for Singapore Citizens aged 25 and above
Singaporean aged 17 to 30 may use PSEA (Post-Secondary Education Account) for fee payment
You may use UTAP Grant to defray 50% of the unfunded course fee, capped at $250/year
Alaster Leong possesses a Diploma in Information Technology with more than 33 years of working experience in IT industry; out of which, 23 years of experience in IT training and 10 years of experience in software development. He is a highly regarded and active trainer for statutory board and corporate companies conducting various IT courses.
He is also a registered trainer with People’s Association. His strength includes courseware development, training in most Microsoft Office applications, especially in Microsoft Excel, Microsoft Access, and Adobe Photoshop. He is a passionate trainer who likes to impart his knowledge to his participants.
Soh Xiao Qi
Cell Leader, Pratt Whitney
He is very detailed and you will not have to worry on missing out, the notes are very useful.
Asst. Finance Manager, The Toa Reinsurance Company Ltd
Very detailed and helpful. He is interested to make sure we really learnt from the class.
Ng Leng Leng (Rena)
Executive Marketing Manager, Building and Construction Authority
Trainer Alaster is very knowledgeable and very patient. He provides step by guide in his notes.
Mr Alaster gave very detailed explanation and promptly addressed all problems & queries.
Senior Analyst, Sinarmas Cepsa
Trainer was very clear and it is easy to follow through the steps even though it is an IT course. Very comprehensive too.
Trainer was very helpful and patient. I will recommend him to my friends.
Cat Man, Sinarmas Cepsa
Wah Chye Low
Sales Manager, Chevron Phillips Chemicals Asia
Kew Woon Yien
Snr WSHE Exec, Woh Hup Pte Ltd
Wide understanding and guidance and explanation.
Knowledgeable and friendly trainer.
Very helpful and knowledgeable.
We will get in touch with you soonest.
Copyright © 2022. All Rights Reserved.