|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/advanced-dax-in-power-bi/
课程评论：没有评论
**课程名称：Power BI 高级 DAX 精通** **课程概述：** 本课程专为希望在 Power BI 环境中深入理解数据分析表达式（DAX）的学习者设计。课程内容全面，从 Power BI 的基础概念，如数据表、查找表和基数，逐步深入到更高级的 DAX 技术和函数。 **核心内容：** * **DAX 基础与引擎：** 深入理解筛选流程、DAX 运算符以及 DAX 引擎（公式引擎和存储引擎）。 * **VertiPaq 和 DirectQuery：** 掌握 VertiPaq 引擎的原理，包括压缩、编码方法，并理解其与 Power BI 模型的关系，以及 DirectQuery 的使用。 * **DAX 函数与应用：** 学习 DAX 错误处理、标量函数、逻辑函数以及表操作函数（如 SELECTCOLUMNS, ADDCOLUMNS, UNION）。 * **复杂 DAX 函数与上下文转换：** 重点讲解 CALCULATE, KEEPFILTERS 等复杂函数，并通过实际练习掌握上下文转换。 * **时间智能分析：** 学习创建日期表，掌握 SAMEPERIODLASTYEAR 等常用时间函数，以及 YTD（年初至今）和 MTD（当月至今）的计算方法。 * **高级表函数与关系管理：** 熟悉 USERELATIONSHIP 和 CROSSFILTER 等高级表函数和关系管理技术，助力构建复杂模型。 **学习目标：** 完成本课程后，您将熟练运用 DAX 进行 Power BI 报表优化，并能应对复杂的分析挑战，从而提升您的决策效率和 Power BI 模型构建能力。
The Advanced DAX in Power BI course is designed for individuals looking to deepen their understanding of Data Analysis Expressions (DAX) within the Power BI environment. This comprehensive course covers a wide range of topics, starting with foundational Power BI concepts such as data tables, lookup tables, and cardinality, before moving into more advanced DAX techniques and functions.Key concepts explored in this course are filter flow, DAX operators, and the essential functions of the DAX engine, including the formula engine and the storage engine. Participants will gain an in-depth understanding of the VertiPaq engine and DirectQuery and will learn about compression, encoding methodologies, and the relationships between VertiPaq and Power BI models.The course also covers DAX error handling, scalar functions, logical functions, and table manipulation functions like SELECTCOLUMNS, ADDCOLUMNS, and UNION. Additionally, you will learn about complex DAX functions such as CALCULATE, KEEPFILTERS, and context transitions with practical exercises that enhance real-world understanding.A strong focus is placed on time intelligence, where you'll explore date table creation, commonly used time functions like SAMEPERIODLASTYEAR, and patterns for calculating YTD (Year-To-Date) and MTD (Month-To-Date) values. Participants will also become proficient in advanced table functions and relationship management, such as USERELATIONSHIP and CROSSFILTER, which are crucial for building complex models.By the end of this course, you will have gained the expertise needed to use DAX in Power BI efficiently, optimize reports, and tackle advanced analytical challenges. Whether you're looking to accelerate your decision-making processes or refine your Power BI models, this course will provide the tools and techniques needed to take your skills to the next level.
