2-Day Power BI Desktop Series 2 - Advanced DAX Formulas Course (Exclusive Course)
Course Overview
This course is created, owned, and trained by its original creator, Mr. Alaster Leong. Learn from the original creator.
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
Objectives
Upon completion of the course, learners will be 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.
Prerequisites
- Have attended our “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 preferred
Things To Bring
- A Windows operating system laptop with Microsoft Power BI Desktop recent version installed or updated (personal laptop is preferred as some company laptops may have security restrictions).
- Laptop power adaptor and a USB mouse.
Course Information
Fee
SGD 910.00 (Nett)
Absentees will be charged the full course fee
Includes lunch and two coffee breaks with light snacks, unless otherwise stated
Time
9:00am to 5:00pm (14 hours)
Mode
Classroom @ Hotel
Dates
19-20 Dec 2024
20-21 Feb 2025
24-25 Apr 2025
19-20 Jun 2025
18-19 Aug 2025
16-17 Oct 2025
15-16 Dec 2025
ALS reserves the right to reschedule, postpone or cancel any course, change the venue at short notice and at its absolute discretion, due to insufficient enrolment, class size, availability and circumstances outside our control.
If you have a group of 6 or more individuals attending for the same course, you can opt for your own closed class on your preferred month, subject to trainer’s availability.
Why Learn With Us?
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 Lead IT Trainer - Mr. Alaster Leong
This course is created, owned and trained by 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.
More Courses By Alaster
Data Analysis using Dynamic and Interactive Excel Dashboard Course
Data Analysis with Excel Power Query, Data Model and Power Pivot Course
Excel 100 Tips and Techniques Course (Exclusive)
Excel 365 Dynamic Arrays Series 1 – Power Functions Course (Exclusive)
Excel Advanced Formulas and Functions Course
Excel Automation with VBA Series 1 – Fundamentals Course
Excel Data Cleansing and Building Techniques Course
Excel Pivot Table In-Depth Course
Excel Power Query Series 1 – Automating Data Preparation (Exclusive)
Excel Power Query Series 2 – Automate Complex Data Transformation (New & Exclusive)
Power BI Desktop Series 1 – Data Model, DAX and Dashboard Visualization Course (Exclusive)
Power BI Desktop Series 2 – Advanced DAX Formulas Course (Exclusive)