|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mastering-intermediate-dax-power-bi-power-pivot-ssas/
课程评论：没有评论
课程名称：掌握中级DAX - Power BI、Power Pivot和SSAS 课程概述： 本课程旨在通过数据分析表达式（DAX）简化数据分析和数据建模，适用于Power BI、Power Pivot和分析服务（SSAS）。学员将通过实践来分析和建模数据。 第一部分将回顾DAX的基本原理，内容涵盖行上下文、过滤上下文、函数如ALL、FILTER、RELATEDTABLE、CALCULATE、EARLIER以及关系等。第二部分将介绍一些后续课程中将详细讨论的DAX函数，这些函数允许您修改总计和小计的显示方式，涵盖ISFILTERED、ISCROSSFILTERED、ALLSELECTED、HASONEVALUE和SELECTEDVALUES等函数。 第三部分重点分析CALCULATE和上下文转换，学习何时在CALCULATE中使用FILTER，以及如何有效结合CALCULATE和VALUES。第四部分将通过案例研究深入探讨具体问题的解决方案。我们将讨论父子层次关系，涉及PATH和PATHLENGTH等函数；研究不同的移动平均，使用EARLIER、FILTER、VALUES和AVERAGE；以及在不同粒度下使用迭代器函数。 此外，学员还将学习高级关系，包括双向过滤和USERELATIONSHIP的使用。每个部分都包含一个下载文件夹，里面有课程示例和活动。实践活动对学习DAX非常重要，通过实践巩固所学知识是课程的关键。
Data Analysis and data modelling made easy with Data Analysis eXpressions. DAX can be used in Power BI, Power Pivot and Analysis Services. Analyse and Model your data with in Power BI, Excels Power Pivot and Analysis Services with Data Analysis eXpressions. This is a hands on course Course Overview In the First section of this course you will refresh the fundamentals of how DAX works. as this section is a refresher section we will work through example rather fast.. We will discuss Row context and Filter context, ALL, FILTER, RELATEDTABLE, CALCULATE, EARLIER, Relationships and much more. The aim of section 2 is to introduce you to some DAX functions that we will be working with in more detail later in this course. Many of the functions and expressions we will use in this section allow you alter or amend how totals and subtotals are shown. Functions covered will include ISFILTERED, ISCROSSFILTERED, ALLSELECTED, HASONEVALUE and SELECTEDVALUES In Section 3 we will look in dept at CALCULATE and Contest Transition. You will learn when to use FILTER inside CALCULATE and also when it is useful to combine CALCULATE and VALUES. Section 4 is packed with Case Studies. We will look at different problems and the solutions. The first case study will focus on parent-child-hierarchy and include functions such as PATH and PATHLENGHT. The second case study will look at different Moving Averages using EARLIER, FILTER, VALUES and AVERAGE. In the third case study we will look at the use of Iterator functions over different granularities. Finally you will learn about about advanced relationships. We will look at BI Directional Filters and the use of USERELATIONSHIP Each section of this course contains a folder to download. The folder contains the examples shown in the course and also activities for you to complete. These Activities are of utmost importance. When it comes to learning DAX, practice is a must.
