|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/understanding-key-dax-functions-in-power-bi/
课程评论：没有评论
Coursera 课程“Power BI 中的关键 DAX 函数”旨在帮助初学者探索并掌握 DAX（数据分析表达式）的核心函数。本课程侧重于 DAX 的基础概念，对于已经熟悉 DAX 的用户不建议学习。 课程内容涵盖： * **DAX 上下文的理解**：包括评估上下文（初始上下文）、聚合（筛选上下文）和迭代（行上下文）。 * **常用 DAX 函数讲解**：重点介绍 ALL、ALLSELECTED、TOPN、LASTNONBLANK、TREATAS、CALCULATETABLE、PARALLELPERIOD、RANKX、GROUPBY 等函数。 * **实际案例应用**：通过累计销售计算、滚动总计计算、利用切片器选择度量值等实际场景，演示 DAX 函数的应用。 * **区分函数差异**：清晰解释 USERELATIONSHIP 与 TREATAS、ALL 与 ALLSELECTED 之间的区别。 * **高级 DAX 技巧**：包括计算中位数、处理多重 IF 语句、以及如何根据排名动态调整视觉对象的大小和内容。 本课程的视频内容精确且聚焦于主题本身，不包含额外信息，非常适合希望入门 DAX 的学习者。
Course covers different functions that are used in day to day reporting development and is helpful to understand the core concepts of these DAX functions. The videos are precise to topic and no additional information is covered other than the topic itself. ** This is not recommended for you , if you are already good at DAX and understand the core DAX functionality , as this course is designed for who wanted to explore the KEY DAX functions and just getting to learn DAX.Key Topics Covered in the Course: · Understanding Context in Power BI· Evaluation Context or Initial Context in Power BI· Aggregations or Filter Context in Power BI· Iterations or Row Context in Power BI· Understanding Cumulative Sales Calculation· Understanding Rolling Total Calculation· Power BI Slicer Selections To Use With Different Measures· Understanding ALL Function· Using TOPN Function· Understanding ALLSELECTED Function· Understanding LASTNONBLANK Function· Understanding TREATAS Function· Difference between USERELATIONSHIP & TREATAS· Calculating MEDIAN value· Understanding CALCULATETABLE Function· How And When To Use PARALLELPERIOD· Different Ways You Can Use The TOPN Function· Uses of Iterating Formulas In Power BI· The Main Difference Between ALL And ALLSELECTED· Advanced RANKX - Deep Understanding· How To Use The GROUPBY Function In Power BI· Dealing With Mulitple IF Statements In Power BI Using DAX· Dynamically Change Size Of Visual Based On Ranking Selection in Power BI using DAX· Create Dynamic Visuals Based on Ranking in Power BI using DAX
