top of page
Background (2).png

Conquering DAX 2019

DAX is the native language of Analysis Services Tabular and Power BI. Likewise, DAX is the only language used in PowerPivot for Excel and Power BI to create calculations in their data modeling task. DAX formula language uses Excel look-alike expressions to define calculations in both PowerPivot for Excel and Power BI.

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.
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.

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
  • 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.

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
  • 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

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
  • SBL-Khas Claimable
     

Download Course Outline

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

PL-300T00: Microsoft Power BI Data Analyst

RM2,800.00

ILT/VILT

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

 

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 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 Power BI proficiency are at the forefront of the technological revolution. These experts are capable of making new sources of information more accessible, understandable, and useful to organizations of all sizes.

 

By obtaining this 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, you may refer to An Analytical Journey with Microsoft Power BI

 

Training Duration: 3 Days

  • Certificate Of Completion Available
  • Group Private Class
  • VILT Class Available
  • 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 series and blogs at Honing Your Skills On Microsoft Power Platform

Dynamics 365