top of page
Background (2).png

DAX on Power BI

WHAT YOU WILL LEARN

This one-day express training is designed to target participants with basic skills of Microsoft Power BI and extend them with the necessary knowledge of Data Analysis Expression (DAX). They will be able to learn how to create calculation elements in Power BI using the DAX language, such as calculated columns, measures, and calculated tables.


OBJECTIVES

After completing this workshop, participants will be able to:

  • Understand the basic features of the DAX language

  • Write formulas for common and slightly more advanced scenarios


PREREQUISITES

Attendees of this workshop are only required to have basic Microsoft Excel formulas knowledge and understand the basic functionalities of Microsoft Power BI.


COURSE CONTENTS


Module 1: Introduction to DAX

  • What is DAX?

  • Data types in DAX

  • Calculated columns

  • Measures

  • Aggregate functions

  • Logical functions

  • Mathematical functions

  • Variables


Module 2: Table Functions

  • FILTER function

  • ALL function

  • ALLEXCEPT function

  • DISTINCT function

  • VALUES function

  • ISEMPTY function

  • RELATED/RELATEDTABLE functions

  • Table relationships


Module 3: Contexts in DAX

  • Evaluation contexts

  • Filter contexts

  • Row contexts

  • Filtering many columns

  • Filter arguments in CALCULATE

  • FILTER and CROSSFILTER functions

  • HASONEVALUE function

  • ALLSELECTED function


Module 4: The Power of The CALCULATE Function

  • Introduction to the CALCULATE function

  • CALCULATE examples

  • Filter is a table representative

  • OR conditions in CALCULATE

  • Clear filters on one column only

  • Example: Ratios and Percentages



Assessment

GRC-103FT Microsoft Power Platform End-To-End Discovery Workshop (Fastrack).png

Data Analysis Expressions (DAX)

This assessment consists of 20 multiple choice questions related to Microsoft DAX language, a formula language used for data analysis and modeling in various Microsoft products, including Power BI. The questions cover a range of DAX functions and concepts, such as calculating running totals, filtering tables, concatenating strings, and returning related values. Each question has four options, and the correct answer is provided for each. This assessment is designed to test the participant's understanding of the DAX language and their ability to apply it in practical scenarios.
Take Assessment
GRC-103FT Microsoft Power Platform End-To-End Discovery Workshop (Fastrack).png

Microsoft Power BI

This assessment is designed to test your knowledge and understanding of Microsoft Power BI, a business intelligence tool that enables users to connect, analyze, and visualize data from various sources. The assessment includes 20 multiple choice questions covering topics such as data modeling, visualization, formulas, and features of Power BI Desktop and Power BI Premium. The questions are intended to provide a pre-assessment of your knowledge level and help you identify areas where you may need to improve your skills.
Take Assessment

Related Courses

GRC-103FT Microsoft Power Platform End-To-End Discovery Workshop (Fastrack).png

GRC-101: An Analytical Journey with Microsoft Power BI

RM3,300.00

ILT/VILT

Empower team members to discover insights hidden in your data with Microsoft Power BI courses.

 

Microsoft Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards. It is part of Microsoft Power Platform.

 

Gain expertise to amplify your insights and the value of your data with GRC's custom-developed Power BI course.

 

Training Duration: 3 Days

  • Certificate Of Completion Available
  • Group Private Class
  • VILT Class Available
  • HRDCorp SBL-Khas Claimable

 

Download Course Outline

 

Looking for function and formula for Power BI, may visit Conquering DAX 2019 or may check out the entire Power Platform training series and blogs at Honing Your Skills On Microsoft Power Platform.

Learn more
GRC-103FT Microsoft Power Platform End-To-End Discovery Workshop (Fastrack).png

GRC-102: Conquering DAX 2019

RM4,000.00

ILT/VILT

Data Analysis Expressions (DAX) is the native formula and query language for Microsoft PowerPivot, Microsoft Power BI Desktop and SQL Server Analysis Services Tabular models.

 

DAX 2019 is a collection of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values. Stated more simply, DAX helps you create reports and  new information from data already in your model.

 

Training Duration: 5 Days

  • Certificate Of Completion Available
  • Group Private Class
  • VILT Class Available
  • HRDCorp SBL-Khas Claimable

 

Download Course Outline

 

For more details, may check out the entire series and blogs at Honing Your Skills On Microsoft Power Platform

Learn more
GRC-103FT Microsoft Power Platform End-To-End Discovery Workshop (Fastrack).png

GRC-112: Microsoft Power BI Data Modeling with DAX

RM4,000.00

ILT/VILT

Basic data models are simple to construct using Power BI Desktop. However, Data Analysis Expressions are required if you wish to report across time periods—for example, to display year-over-year growth or to compare sales or other data by month or quarter (DAX). DAX is a programming language for creating Power BI calculations that extend your data model.

 

Learn how to use DAX aggregate functions and add calculated columns, build measurements, and use DAX logical and filter functions and recommended practices for data model construction and optimization.

 

Whether you're using Power BI Desktop, Power Pivot in Excel, or Analysis Services, learning Data Analysis Expressions (DAX) is essential to creating effective data models. 

 

Training Duration: 5 Days

  • Certificate Of Completion Available
  • Group Private Class
  • VILT Class Available
  • HRDCorp SBL-Khas Claimable
     

Download Course Outline

Learn more
GRC-103FT Microsoft Power Platform End-To-End Discovery Workshop (Fastrack).png

PL-300T00: Microsoft Power BI Data Analyst Training Course

RM2,800.00

ILT/VILT

Discover the Microsoft Certified: Power BI Data Analyst Associate credential.

 

Unlock the power of data analysis with instructor led Microsoft Power BI Data Analyst. Enhance your skills through comprehensive Microsoft analytical training, big data insight, advance business analytics technique, via this business intelligence training, and data analyst training. Gain a competitive edge and drive informed business decisions with this essential tool. Start your journey today!

 

If you are a data analyst or developer who frequently works with data, having the Microsoft Certified: Power BI Data Analyst Associate certification on your résumé is a valuable asset.

 

This Microsoft Power BI certification not only recognizes your skill set but also helps your organization distinguish itself from others. It confirms that you possess the necessary abilities to assist businesses in optimizing their data assets using Power BI.

 

In today's digital age, subject matter experts with Microsoft Power BI proficiency are at the forefront of the technological revolution. These experts armed with knowledge of big data, are capable of making new sources of information more accessible, understandable, and useful to organizations of all sizes.

 

By obtaining this Microsoft Power BI certification, you are validating your Power BI data skills and standing out in a world where the demand for this expertise is rapidly increasing.

 

For customized and hands-on Microsoft Power BI training that delves into the depths of big data analysis, you may refer to An Analytical Journey with Microsoft Power BI in Malaysia

 

Training Duration: 3 Days

  • Certificate Of Completion Available
  • Group Private Class
  • VILT Class Available
  • HRD Corp SBL-Khas Claimable

 

Download Microsoft Power BI Course Outline

 

Looking for function and formula for Power BI, may visit Conquering DAX 2019 or may check out the entire series and blogs at Honing Your Skills On Microsoft Power Platform

Learn more
bottom of page