Data Modeling with DAX Tutorial

DAX functions play an important role in the usage of DAX for data modeling and reporting. It is an inbuilt function provided in the DAX language that helps you perform commonly used data calculations on the Data Model. In this tutorial, you will learn data modeling and analysis using DAX, based on the Power Pivot data model. As you proceed, you will learn about the different facets of Power Pivot, DAX and DAX functions in data modeling and analysis. By the end of the tutorial, you will be able to perform data modeling and analysis with DAX for any context at hand.

Audience

This tutorial has been designed for all those readers who depend heavily on MS-Excel to prepare charts, tables, and professional reports that involve complex data. It will help all those readers who use MS-Excel regularly to analyze data. Professionals who use data modeling and data analysis for reporting and decision-making purposes will benefit from this.

Prerequisites

To proceed with this tutorial, it is a good idea to first go through the following tutorials −

• Excel PivotTables
• Excel Power Pivot
• DAX
• DAX Functions