Learn DAX for Power BI Course Singapore
Dax for Power BI Course: Learn Data Analysis using Expressions to solve common business problems in Power BI.
Course Start Date
Schedule
- Days: 1 Days
- Duration: 7 Hours
- Timings: 9:30 AM - 5:30 PM
- 10 Anson Road, 26-08A International Plaza, Singapore 079903
Why Choose Us
- Expert Local Trainers
- Hands-on Training by experts
- Certificate of Achievement
Who Should Attend This DAX for Power BI Course Singapore
The DAX for Power BI course in Singapore is designed for professionals who are looking to improve their data analysis skills using Microsoft Power BI.
Business professionals
Analyst
Entrepreneur
Training Professionals
Student
Course Completion Requirements
Minimum 75% attendance is required in order to complete the course and receive the course completion certificate
Above 16 years old
High School Level English
Basic internet & computer operation skills
DAX for Power BI Training in Singapore
In this course, trainees will learn how to use Data Analysis Expressions (DAX), the language used to create custom calculations within the Power BI data model. While the course touches on the theory behind the data model and DAX, the main focus is on applying DAX to address common business challenges effectively.
Target Students
This course is designed for business users who already use Power BI to build analytical solutions and are ready to unlock the full power and flexibility of DAX. For experienced Power BI users, mastering DAX is a natural and essential next step.
Prerequisites:
Although experience with Power BI Desktop is not strictly required for this class, Trainees with at least some familiarity will be better equipped to get the most out of the course.
What will you learn?
- Learn how to write their own calculated columns, measures, and tables
- Learn how to visualize the way Power BI computes DAX calculations
- Learn how to troubleshoot custom code
DAX functions that are covered in this class include:
- Date and time functions: CALENDAR(), CALENDARAUTO(), DATE(), NOW(), TODAY(), WEEKDAY(), WEEKNUM(), YEAR(), MONTH(), DAY()
- Filter functions: ALL(), ALLEXCEPT(), CALCULATE(), CALCULATETABLE(), FILTER(), LOOKUPVALUE(), REMOVEFILTERS()
- Information functions: CONTAINS(), HASONEFILTER(), HASONEVALUE(), ISINSCOPE(), ISBLANK(), ISEMPTY(), ISERROR(), USERNAME()
- Logical functions: AND(), COALESCE(), IF(), IFERROR(), NOT(), OR(), SWITCH(), TRUE(), FALSE()
- Math and Statistical Functions: DIVIDE(), SUM(), SUMX(), AVERAGE(), AVERAGEX(),COUNT(), COUNTROWS(), COUNTX(), DISTINCTCOUNT(), MAX(), MAXX(), MEDIAN(), MEDIANX(), MIN(), MINX(), RANKX()
- Table manipulation functions: ADDCOLUMNS(), SELECTCOLUMNS(), CROSSJOIN(), DATATABLE(), NATURALINNERJOIN(), SUMMARIZE(), VALUES()
- Text functions: CONCATENATEX(), FIND(), LEFT(), LEN(), MID(), REPLACE(), SEARCH(), TRIM(), VALUE()
- Time intelligence functions: DATEADD(), DATESBETWEEN(), DATESMTD(), DATESQTD(), DATESYTD(), PARALLELPERIOD(), SAMEPERIODLASTYEAR(), TOTALMTD(), TOTALQTD(), TOTALYTD()
DAX for Power BI Course Outline:
Getting started with DAX
- What is DAX?
- Basics of DAX syntax
- Creating a calculated column
- Creating a calculated measure
- Creating a calculated table
- Differences in evaluation context
- Rules of evaluation
- Working with variables
- Commenting your code
- Testing your code
Performing basic calculations
- Implicit measures
- Adding quick measures
- Doing basic math
- Using logic in your calculations
- Aggregating and summarizing data
- Working with DAX data types
Working with context in the data model
- Context defined
- Data modeling basics
- Introduction to dimensional modeling
- Relationships and their effect on the evaluation context
- Getting data from other tables using RELATED() and RELATEDTABLE()
- Modifying the context using CALCULATE()
- Looking up data without using relationships
Performing more advanced calculations
- Handling errors gracefully
- Using DAX iterator functions
- Using table manipulation functions
- Troubleshooting your calculations using the Performance Analyzer and DAX Studio
Working with time
- Performing date calculations
- Working with date tables
- Generating a date table with the CALENDAR() function
- Defining custom operating periods
- YTD, QTD, and MTD calculations
- Custom to-date calculations
- Finding year-over-year change
- Finding moving averages
Enhancing the user experience
- Controlling visibility of your measures
- Using What-if parameters
- Adding banding
- Using DAX to provide row-level security
Frequently Asked Questions (FAQ)
What is the focus of this DAX for Power BI course?
This course is designed to help participants gain proficiency in Data Analysis Expressions (DAX), the formula language used in Power BI. It covers a range of functions including date and time, filter, logical, math and statistical, table manipulation, text, and time intelligence functions. The course emphasizes practical application to solve common business problems.
Who should attend this course?
This course is ideal for business users who have experience using Power BI to build analytical solutions and are ready to leverage the power and flexibility that DAX provides. Learning DAX is a common next step for experienced Power BI users.
What topics are covered in the course?
The course includes:
- Introduction to DAX and its syntax
- Creating calculated columns, measures, and tables
- Understanding and applying evaluation context
- Using DAX functions for calculations and data manipulation
- Implementing time intelligence functions
- Enhancing user experience with DAX
What are the prerequisites for this course?
Participants should have a basic understanding of Power BI and data modeling concepts. Familiarity with Excel functions can also be beneficial.
How is the course delivered?
The course is delivered through instructor-led sessions that include hands-on exercises, real-world examples, and interactive discussions to reinforce learning.