


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
for Individual
Course
Objectives
.png)
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.

Course Fees
-
$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

Course
Schedule
We will get in touch with you soonest.
Copyright © 2022. All Rights Reserved.