Data Modeling With Dax 简明教程

Data Modeling with DAX Tutorial

DAX 函数在数据建模及报表中的 DAX 使用中扮演着重要的角色。这个函数是 DAX 语言中内置的函数,帮助你在数据模型上执行常用的数据计算。在本教程中,您将学习使用基于 Power Pivot 数据模型的数据建模和分析。在学习的过程中,您将学习数据建模和分析中的 Power Pivot、DAX,以及 DAX 函数的不同方面。在教程的末尾,您将能够对任何手头的语境进行数据建模和分析。

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

本教程针对所有那些极大地依赖 MS-Excel 来准备包含复杂数据的图表、表格,以及专业报告的读者。它将帮助那些经常使用 MS-Excel 来分析数据的读者。那些使用数据建模和数据分析来进行报告和做决定的专业人士也会受益于本教程。

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 −