|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-power-bi-dax-foundation-from-scratch/
课程评论：没有评论
**微软 Power BI DAX 从零开始 课程总结** 本课程旨在帮助学习者掌握 Microsoft Power BI 中的 DAX（Data Analysis Expressions）语言，从而解锁 Power BI 报告的高级功能。DAX 是一种强大的函数库，用于创建公式和表达式，极大地简化数据分析和报告流程。 **课程内容概要：** * **DAX 概念与应用：** 学习者将深入理解 DAX 的核心概念，并学会如何创建计算列、度量值、表和快速度量值。 * **核心 DAX 函数详解：** 课程将重点介绍 DAX 函数库中最常用和最具影响力的函数，涵盖以下类别： * **日期和时间函数：** WEEKDAY, EDATE, EOMONTH, DATEDIFF, TODAY, NOW * **文本函数：** FORMAT, COMBINEVALUES, LEFT, RIGHT, FIND, UPPER, LOWER, UNICHAR, REPT * **逻辑函数：** IF, Nested IF, AND, OR, SWITCH * **关系函数：** RELATED, CROSSFILTER, RELATEDTABLE * **X 函数：** SUMX, RANKX * **筛选函数：** CALCULATE, ALL, EARLIER, FILTER, LOOKUPVALUE * **统计函数：** DISTINCTCOUNT * **时间智能函数：** DATESYTD, DATEADD, SAMEPERIODLASTYEAR * **信息函数：** CONTAINS * **表操作函数：** SUMMARIZECOLUMNS * **问题导向的学习模式：** 课程采用“问题陈述-解决方案”的模式，通过实际问题引入 DAX 函数，并逐一剖析表达式的每个组成部分，确保学习的易懂性。 **课程目标：** 通过本课程，学习者将能够运用 DAX 函数构建复杂的计算和分析，从而在 Power BI 中创建更深入、更有洞察力的报告，并有效地解决数据分析中的挑战。
If you are someone dealing with reporting, with the help of DAX functions you can unlock the advanced power of reporting in Power BI. These functions will help you get better data insights. DAX or Data Analysis Expression is a library of functions and operators, using which you can create formulas and expressions. This will help you with creating powerful formulas to ease your data analysis and reporting process. This course is designed in a Problem Statement - Solution format where we start with the problem to which a solution is sought with the help of DAX functions where each component of the expression is clearly explained in easy-to-understand terms,What is in store for you? In this course, you will1. Understand the concept of DAX and how to create calculate column, measure, tables, and quick measures2. From the exhaustive list of DAX functions, we will be looking into the most frequently used functions from the family of Date and Time function - WEEKDAY, EDATE, EOMONTH, DATEDIFF, TODAY, NOWText function - FORMAT, COMBINEVALUES, LEFT, RIGHT, FIND, UPPER, LOWER, UNICHAR, REPTLogical function - IF, Nested IF, AND, OR, SWITCHRelationship function - RELATED, CROSSFILTER, RELATEDTABLEX-function - SUMX, RANKXFilter function - CALCULATE, ALL, EARLIER, FILTER, LOOKUPVALUEStatistical function - DISTINCTCOUNTTime intelligence function- DATESYTD, DATEADD, SAMEPERIODLASTYEAR Information function- CONTAINSTable manipulation function- SUMMARIZECOLUMNS
