|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mastering-dax-for-advanced-powerbi-reporting/
课程评论：没有评论
Coursera 课程《Power BI - 精通 DAX》课程总结 本课程是为所有 Power BI 用户设计的，旨在帮助学习者掌握 DAX（Data Analysis Expressions），这是 Power BI、Excel Power Pivot 和 SSAS Tabular 的核心公式语言。DAX 能够解锁 Power BI 中更高级的报告功能，但学习曲线较陡峭，需要扎实的基础和大量的实践。 课程特点： * **讲解深入：** 采用极其详尽的讲解方式，确保学习者不仅能复制公式，更能理解背后原理，从而更快地学习和掌握 DAX。 * **专家指导：** 由微软最有价值专家（MVP）和微软认证培训师讲授，能够提供专业的 DAX 问题解答和学习指导。 课程内容涵盖： 1. **DAX 在 Power BI 中的应用：** 计算列、计算表、度量值和行级别安全性。 2. **核心 DAX 函数：** 学习最常用和最重要的 DAX 函数。 3. **DAX 引擎原理：** 深入了解 DAX 引擎的内部工作机制。 4. **CALCULATE 函数：** 重点讲解 DAX 中的核心函数 CALCULATE。 5. **上下文概念：** 理解行上下文（Row Context）、筛选上下文（Filter Context）及上下文转换（Context Transition）。 6. **时间智能函数：** 学习时间相关的函数和计算方法。 7. **其他重要函数：** 如 RANKX 和 TOPN 等。 课程设置： * **实践导向：** 课程包含实践练习和作业，强调“做中学”的理念，鼓励学习者动手编写 DAX 公式，通过实践不断提升技能。 * **循序渐进：** 从基础概念讲起，为学习者打下坚实的 DAX 基础，帮助构建对 DAX 的更深入理解。 通过本课程的学习，学员将能更好地理解和运用 DAX，从而在 Power BI 中创建更强大、更具洞察力的报告。
BackgroundDAX is the formula language of Power BI, Excel Power Pivot and SSAS Tabular. The formula language simply unlocks advanced capabilities for reporting in Power BI.However, DAX is not an easy language to learn. Mastering it requires a proper understanding of the rudiments and a lot of constant practice.In this course, I have used a very explanatory approach to ensure that you will understand, learn and master DAX faster than most courses where formulas ae being copied from a text editor without proper explanation of what is happening behind it.As a Microsoft Most Valuable Professional for the Data Platform and a Microsoft Certified Trainer, I will be able to answer your DAX questions as you continue to develop your skills after this course.What you will learn.This course is suitable for all levels of Power BI users. You will learn from the introductory concepts to build a solid background. By the time you complete the course, you should have a better understanding of:1. DAX usage in Power BI (Calculated Columns, Calculated Tables, Measures and Row Level Security)2. The most important and used DAX functions3. How the DAX Engine works behind the scenes4. The CALCULATE function in DAX5. Row Context, Filter Context and Context Transition6. Time Intelligence functions and calculations7. Other important DAX functions like RANKX and TOPNAssignments.Because DAX is about doing , and beyond looking, I am sorry to say that I included assignments for you. Don't worry if you stumble here and there while completing the assignments, it's completely normal. You will just have to watch the parts of the videos again till you are able to complete them. It's all for good.The more DAX you write, the better you get over time. So this is a good opportunity to write a lot of them.
