|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-all-power-bi-dax-secrets/
课程评论：没有评论
课程名称：Power BI DAX 秘密 - （学习 Power BI 的 DAX 公式） 课程概述：本课程旨在深入探讨 DAX（数据分析表达式）在 Power BI 中的应用。DAX 是一种用于数据分析和计算的公式语言，它由函数、运算符和常量的组合构成，这些组合在一起以产生结果（数值或值）。DAX 公式在 BI 工具如 Power BI 中对数据分析师至关重要，能够充分发挥现有数据集的潜力。 学习 DAX 的重要性在于它是构建动态仪表板的基础，适用于 Power BI Desktop、SQL Server Analysis Services（表格模式）和 Microsoft Excel。DAX 需要在表格中进行计算，其核心在于理解上下文，包括过滤上下文和行上下文，这两种上下文相辅相成，掌握这两者将帮助你迅速解决复杂问题。 通过 DAX 语言，分析师可以发现数据值的新计算方式，获得新的见解。在本课程中，你将学习 DAX 语言的核心概念。虽然对于简单的仪表板，不必编写任何 DAX 公式就能获取结果，但对于高级计算，学习 DAX 的核心概念至关重要。DAX 语言虽然简单易写，但初学时可能会感到困难。一旦你掌握了 DAX 的基本理论，编写任何公式都将变得轻而易举，并能轻松应对多重嵌套上下文的问题。 课程由我进行讲授，我是 Muhammad Asif，微软认证的数据管理与分析解决方案专家，在微软 BI 堆栈方面拥有超过 10 年的经验。你将学到行业中实际应用的知识。让我们一起来探索 DAX 的秘密吧！
What is DAX in Power BI?DAX stands for Data Analysis Expressions i.e. such expressions or formulas that are used for data analysis and calculations. These expressions are a collection and combination of functions, operators, and constants that are evaluated as one formula to produce results (value or values). DAX formulas are very useful in BI tools like Power BI as they help data analysts to use the data sets they have to the fullest potential.Why learn DAX is important?Learning DAX is essential to build dynamic dashboards. It uses in Power BI desktop, SQL Server Analysis Services (Tabular mode), and Microsoft Excel. It is a formula language that needs tables to perform calculations.Soul of Power BIThe core of learning Power BI DAX is its context. There are two types of contexts, the first one is the filter context, and the second one is the row context. These context works together whenever you write any dax expression. I will explain these contexts with the help of simple examples. If you have solid concepts regarding filter context, row context, and context transition, then you can solve any complexity quickly.With the help of the DAX language, analysts can discover new ways to calculate data values they have and come up with fresh insights.In this course, you will learn the core concepts of dax language. For the simple dashboards, you can get your results without writing single dax formula but for the advanced calculations, you really need to learn dax with its core concepts. DAX is a really easy language to write but a bit hard to grasp in the beginning. Once you learn DAX underlying theory then it is easy to write any formula and you can play with multiple nested contexts.With every topic, first, we will discuss hidden concepts and then we will do its implementation.About meI am your instructor Muhammad Asif Microsoft certified solutions expert in data management & Analytics. I have more than 10 years of experience in Microsoft BI stack with world-leading financial Firm. You will learn what exactly is used in the industry.let's proceed to learn the secrets of DAX
