|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-bi-dax-intermediate-ranking-logic-time-intelligence/
课程评论：没有评论
课程名称：中级 Power BI DAX：排名、逻辑、时间智能 课程概述：准备提升您的 Power BI 数据建模技能，并像专业人士一样编写 DAX 吗？本课程是您掌握中级 DAX 技术的逐步指南，这些技术将使报告从功能性转变为卓越，并增强您的数据建模工作流程。在这个以实践为基础、面向商业的课程中，您将超越基本的度量值和计算列，发现 DAX 如何推动智能、响应灵活且个性化的 Power BI 体验。 课程共分为六个结构化章节，您将探索中级 DAX 能力的全面范围——从动态标题和用户感知过滤器到行级安全、先进逻辑、迭代器、排名、格式化和时间智能。我们首先介绍动态报告元素，教您如何使用 SELECTEDVALUE、USERPRINCIPALNAME 和 FORMAT 等函数生成适应用户和上下文的标题、搜索网址和个人评论。接下来，您将掌握嵌套 IF 语句、复合条件以及强大的 SWITCH(TRUE()) 结构的逻辑模式，使您的度量更具灵活性和上下文感知能力。 然后，我们深入探讨迭代器函数，如 MAXX、MINX 和 CONCATENATEX，并揭示 EARLIER 的原理及其现代替代方案 VAR。这些课程将加深您对行上下文的理解，并增强您在 Power BI 中有效的数据建模技术掌握程度。在排名部分，您将使用 RANKX、TOPN 和可选参数构建复杂的比较，这些都是排行榜式报告的重要工具。同时，您还将学习如何应用条件格式和通过 UNICHAR、RAG 状态逻辑和动态 KPI 实现可视化讲述。 最后，我们专门为 DAX 时间智能分配了一个完整的章节：运行总计、之前期间比较以及使用 DATEADD、SAMEPERIODLASTYEAR、DATESYTD 等函数的日历感知度量。您将学会如何构建和定制自己的日历表，并应用基于时间的过滤器来发掘趋势和季节性。 到课程结束时，您不仅能编写更优秀的 DAX，还能构建更智能的数据模型，设计用户响应型报告，并自信地应用可扩展的最佳实践。本课程将使熟练的 Power BI 用户变成强大的 DAX 创造者。
Ready to level up your Power BI data modeling skills and write DAX like a pro? This course is your step-by-step guide to mastering intermediate DAX techniques - the kind that transform reports from functional to exceptional and enhance your data modeling workflow.In this hands-on, business-focused course, you'll move beyond basic measures and calculated columns to discover how DAX can drive intelligent, responsive, and personalised Power BI experiences. Across six structured chapters, you'll explore the full breadth of intermediate DAX capabilities - from dynamic titles and user-aware filters to row-level security, advanced logic, iterators, rankings, formatting, and time intelligence.We begin with dynamic report elements, showing you how to use functions like SELECTEDVALUE, USERPRINCIPALNAME, and FORMAT to generate titles, search URLs, and personal commentary that adapt to the user and context. You'll then master logical patterns with nested IF statements, compound conditions, and the powerful SWITCH(TRUE()) structure - making your measures flexible and context-aware.Next, we take a deep dive into iterator functions like MAXX, MINX, and CONCATENATEX, before demystifying EARLIER and its modern replacement using VAR. These lessons will deepen your understanding of row context and strengthen your grasp of effective data modeling techniques in Power BI.In the ranking section, you'll build sophisticated comparisons using RANKX, TOPN, and optional arguments that control ties and sort order - all vital tools for leaderboard-style reports. You'll also learn how to apply conditional formatting and visual storytelling using UNICHAR, RAG status logic, and dynamic KPIs.Finally, we dedicate a full chapter to DAX time intelligence: running totals, prior period comparisons, and calendar-aware measures using DATEADD, SAMEPERIODLASTYEAR, DATESYTD, and more. You'll understand how to build and customise your own calendar tables and apply time-based filters to uncover trends and seasonality.By the end of the course, you won't just be writing better DAX - you'll be building smarter data models, designing user-responsive reports, and confidently applying best practices that scale. This is the course that turns competent Power BI users into powerful DAX creators.
