This course is conducted in PC/Windows operating system. There will be no laptop provided. Learners are required to bring along their own laptops.

2-Day Power BI Desktop Series 2 - Advanced DAX Formulas Course
In Singapore (Exclusive)

Power up your Power BI skills and grasp Power BI at its full potential by mastering Data Analysis Expressions (DAX)

All our courses are not subsidised and non-claimable using SkillsFuture credit

Power BI Desktop Series 2 - Advanced DAX Formulas Course Overview

Course Description

Learn from the original creator of this course – Mr. Alaster Leong.

Users who want to take their Power BI skills to the next level or grasp Power BI at its full potential should master Data Analysis Expressions (DAX). In this hands-on, project-based course, you’ll put your DAX skills to the test and apply what you learn to some of the real-world business intelligence use cases.

This course is intended to build on the fundamentals taught in “Power BI Series 1 – Data Model, DAX, and Dashboard Visualization” Course. This course covers advanced and difficult to comprehend DAX concepts such as evaluation context, iterator functions, advanced Time Intelligence functions, etc.

During this course, we will be using back the same project database you have built in Power BI Desktop Series 1 course so that you will be familiar with it.

This Power BI Desktop Series 2 – Advanced DAX Formulas course will focus on DAX formulas rather than visualization. Table, Matrix and Slicer will be the only visualization tools used in this course.

Please note that this is the second (Series 2) of two series courses for Power BI Desktop:

Power BI Desktop Series 1 – Data Model, DAX & Dashboard Visualization
Power BI Desktop Series 2 – Advanced DAX Formulas

Course Objectives

At the end of the course, learners are able to:

- comment the codes
- structure and format the codes
- use advanced DAX functions
- understand when to use those functions
- mix and match different DAX functions
- apply DAX functions in the real world

Who Should Attend?

This course is for:

learners who have attended our Power BI Series 1 – Data Model, DAX & Dashboard Visualization course.
existing Power BI Desktop users with basic DAX knowledge (refer to the prerequisite section below).

Methodology

This is a hands-on practical course. Trainer will walk through the topic step-by-step. Learners will be provided with exercise files on every topic to effectively apply what have been taught. A short Q & A session will be available after each topic.

Pre-requisites

Have attended “Power BI Series 1 – Data Model, DAX & Dashboard Visualization” or existing Power BI Desktop user with working knowledge on the following DAX functions:
- IF, SWITCH, TRUE, DIVIDE, COUNTROWS, DISTINCTCOUNT, MAX / MIN
- CALCULATE, FILTER, RELATED, ALL
- SUMX, COUNTX
- DATEDIFF, YEAR / MONTH / DAY, DATESMTD / DATESQTD / DATESYTD, DATEADD
Proficient with Excel functions will be an added advantage
A good working knowledge of Excel Pivot Table would be advantageous, but not mandatory.
Software Requirement: Microsoft Power BI Desktop installed

Things To Bring

PC/Windows operating system laptop with Power BI Desktop pre-installed
Laptop power adaptor
USB mouse

Important Note:
We will always update our Power BI Desktop training, along with our training materials, to reflect the most recent version of Microsoft Power BI Desktop. Therefore, please ensure your Power BI Desktop is updated to the most recent version before attending the class.

Course Outline

1. Project Setting

Project Path Setup
Option Settings
Creating Measure Table

2. Writing DAX Code Best Practices

Shortcuts
Commenting Codes
Formatting Codes
DAX Variables

3. Evaluation Context

Filter and Row Context
Context Transition

4. CALCULATE Modifier Functions

Common CALCULATE Modifiers
REMOVEFILTERS
KEEPFILTERS

5. Table & Filter Functions

DISTINCT
VALUES
ALLNOBLANKROW
SELECTEDVALUE
ALLEXCEPT
ALLSELECTED
SELECTCOLUMNS
ADDCOLUMNS
SUMMARIZE
ROW
DATATABLE
GENERATESERIES
CALCULATETABLE

6. Calculated Table Joins Functions

UNION
EXCEPT
INTERSECT

7. Relationship Functions

RELATEDTABLE
USERELATIONSHIP
CROSSFILTER
TREATAS

8. Iterator Functions

CONCATENATEX
AVERAGEX
RANKX

9. Scalar Functions

ISBLANK
COALESCE
HASONEVALUE
INT
DATEDIFF
Calculating Age Accurately

10. Advanced Time Intelligence Functions

CALENDAR
PARALLELPERIOD
PREVIOUSYEAR, PREVIOUSQUARTER, PREVIOUSMONTH, PREVIOUSDAY
SAMEPERIODLASTYEAR
TOTALYTD, TOTALQTD, TOTALMTD
DATESBETWEEN
LASTDATE
DATESINPERIOD
Moving Average

Our Dedicated Trainer

Mr Alaster Leong

Learn from the original creator of this course.

Alaster has been training adult learners in IT in both the private and public sectors since 1986. Alaster’s career before training centred around IT for over 12 years, as he held various roles within software development. He has earned himself a Microsoft Office Specialist (MOS) certification and he is an existing Trainer approved by People’s Association (PA). He was also a former Associate Trainer with the Civil Service College.

He specialises on training Microsoft Applications and Adobe Photoshop. Based on his vast experience and keeping abreast with the emerging trends, tools and technologies with the IT industry, especially software, he has extensively involved in developing several course outlines and course materials and conducting training to equip learners with skills in-demand or likely to be most important in the jobs of the future work.

Alaster constantly explore innovative and effective ways in imparting knowledge and engaging his learners at the same time. He also focuses his training on providing practical solutions to real-life problems, especially Excel. He is more than willing to help overcome various problems faced by his learners that arise in their workplace in applying their newly-acquired knowledge and skills any time after the course. He is well-known for his dedication, commitment and passion to training that makes him well-liked and appreciated by his learners.

Course Registration

All our courses are not subsidised and non claimable using SkillsFuture credit.

Organisations with more than 2 learners, click here to download registration form.

All registration forms should be submitted at least 2 weeks before course commencement. Many courses have pre-requisites, which are intended to foster a learner’s success in the course. Be sure to check the necessary pre-requisites before registering.

This course is not subsidised and non claimable using SkillsFuture credit.

COURSE INFORMATION

Course Sponsorship

Company-Sponsored

Self-Sponsored

Number of learners to be registered

One (1)

Two (2)

Select Course*

*Course Date – ALSIT-EDB

*Course Date – ALSIT-PQP

*Course Date – ALSIT-DWF

*Course Date – ALSIT- EPQ1

*Course Date – ALSIT-ETT

*Course Date – ALSIT-EDA1

*Course Date – ALSIT-EFF

*Course Date – ALSIT-VBA1

*Course Date – ALSIT-DCB

*Course Date – ALSIT-PTD

*Course Date – ALSIT-PPT

*Course Date – ALSIT-ERW

*Course Date – ALSIT-WTT

*Course Date – ALSIT-PBI1

*Course Date – ALSIT-PBI2

*Course Date – ALSIT-PYP1

*Course Date – ALSIT-DMM

*Course Date – ALSIT-ABCD

*Course Date – ALSSS-BGB

*Course Date – ALSSS-EPR

*Course Date – ALSSS-EWE

*Course Date – ALSSS-WBE

*Course Date – ALSSS-WMM

*Course Date – ALSSS-HSB

*Course Date – ALSSS-DSY

*Course Date – ALSSS-EHL

*Course Date – ALSSS-HTA

*Course Date – ALSSS-PLL

*Course Date – ALSSS-POS

*Course Date – ALSSS-UCP

*Course Date – ALSSS-MEW

*Course Date – ALSSS-NCB

*Course Date – ALSSS-PSD

*Course Date – ALSSS-HPM

*Course Date – ALSSS-LWI

*Course Date – ALSSS-QGS

*Course Date – ALSSS-DDP

*Course Date – ALSSS-AEC

*Course Date – ALSSS-MCC

*Course Date – ALSSS-RSO

*Course Date – ALSSS-SSE

CONTACT & BILLING INFORMATION

Company Name*

Company Address*

Postal Code*

TC/HR First Name*

TC/HR Last Name*

Contact Number*

Email*

Designation*

Department*

Department* (for govt using e-invoice system)

Sub-BU Code* (for govt using e-invoice system)

Billing Information Same as above

Yes

Billing Person First Name* (optional)

Billing Person Last Name* (optional)

Designation* (optional)

Department* (optional)

Contact Number*

Email* (optional)

LEARNER(S) INFORMATION

Learner 1 First Name*

Learner 1 Last Name*

Mobile Number*

Work Email*

Designation*

Dietary Restrictions*

Please specify your food allergies*

Learner First Name*

Learner Last Name*

Block / House No.*

Unit No.*

Street*

Building*

Postal Code*

Mobile Number*

Email*

Citizenship*

Dietary Restrictions*

Learner 2 First Name* (optional)

Learner 2 Last Name* (optional)

Mobile Number* (optional)

Work Email* (optional)

Designation* (optional)

Dietary Restrictions*

Dietary Restrictions* (optional)

Food allergies, please specify*

OTHERS

How did you hear about us?*

Others, please specify*

Name of referral

How did you hear about us?*

Others, please specify*

Terms and Conditions

I have read, understood, and agree to the Terms and Conditions and Privacy Policy.

Terms and Conditions

I have read, understood, and agree to the Terms and Conditions and Privacy Policy.

To learn more, be sure to read our Terms and Conditions and Privacy Policy.

Course Information

Course Code:

ALSIT-PBI2

No laptop will be provided. Bring Your Own Laptop Course.

Course Fee:

S$910.00 (Nett)

Call us for a group rebate when you register in a group of 8 or more.

Absentees will be charged the full course fee.

Course Dates:

2 days, 9:00am – 5:00pm
(14 hrs, exclude lunch break)

A closed class can be requested if you have a group of at least 8 or more registered for the same course and date at a preferred date, subject to trainer availability.

Closed class is not customised class.

Training Venue:

To be confirmed one (1) week prior to the course start date.

Registration:

For Company-Sponsored Learners: Click here to download registration form.

For Self-Sponsored Learners:
Click here to download registration form.

You can also register online here.

Note:

ALS reserves the right to reschedule, postpone or cancel any course, change the trainer and hotel venue at short notice and at its absolute discretion, due to insufficient enrolment, class size, availability and circumstances outside our control.