|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-bi-dax-essentials-basic-dax-formulas-and-functions/
课程评论：没有评论
**课程名称：** Power BI DAX 基础：基础 DAX 公式和函数 **课程概述：** 本课程是 G Com Solutions 系列 DAX 语言课程的第一部分，后续还有 DAX 中级和 DAX 高级课程。本课程旨在为学员打下坚实的 DAX 语言基础，并确保学员对所有基础知识都有信心。 **核心内容：** * **DAX 三大对象：** 学习 DAX 可以创建的三种对象：计算列（calculated columns）、计算表（calculated tables）和计算度量值（calculated measures）。 * **高效编写 DAX：** 掌握编写 DAX 的技巧，以最大程度地减少错误，包括有效使用公式栏、添加注释、以及高效利用自动完成功能。 * **常见错误规避：** 课程专门讨论人们常犯的错误以及如何避免。 * **实战演练：** 这是一门非常注重实践的课程，提供充足的实际 DAX 编写练习，学习如何构建 DAX，从基础度量值开始，逐步构建更高级的度量值。 * **计算列与度量值的选择：** 学习何时使用 DAX 计算列优于 Power Query 计算列，以及何时计算列应优先于度量值。 * **深入学习度量值：** 大部分课程将专注于度量值的创建，包括常用的关键函数、函数嵌套技巧。 * **掌握迭代函数：** 学习迭代函数，它们允许学员对虚拟列进行聚合，从而避免在数据模型中实际添加列带来的开销。 * **精通 CALCULATE 函数：** 深入了解 DAX 中最重要的函数——CALCULATE 函数。 **课程成果：** 完成课程后，学员将能够自信、熟练地编写 DAX 公式。
Power BI DAX Essentials is the first of three courses by G Com Solutions dedicated to the DAX language. And to go along with it, we have DAX intermediate and DAX Advanced.In this Power BI DAX Essentials course, we will focus on giving you a good grounding in the DAX language, and making sure that you are confident with all of the basics.We'll discuss the three objects which DAX is capable of creating: calculated columns, calculated tables, and calculated measures.You'll learn how to write your DAX in such a way that you are far less likely to make errors. You'll learn how to use the formula bar in the most effective manner, how to add comments to your DAX measures, how to use auto-complete effectively to minimize the errors that you make; and the course even contains a section dedicated to discussing the most common errors that people make and how you can avoid making them.This is very much a hands-on course, and you'll get plenty of real-world practice in writing DAX, and learning to structure your DAX in such a way that you start with basic measures, which then become the building blocks to your more advanced measures.You'll learn when to use DAX calculated columns in preference to Power Query computed columns, and also the circumstances when calculated columns should be used in preference to measures. But since measures are the most important DAX calculation, most of the course will be dedicated to discussing the creation of measures: some of the key functions that you'll need to use and the technique of nesting functions, whereby one function becomes the argument of another.You will master iterator functions, which enable you to aggregate a virtual column, saving you the overhead of having to physically add a column to the data model. And you'll also get a good handle on the calculate function, the most important function in the DAX language.By the end of the course, you'll feel confident and comfortable writing DAX formulas.
