|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/the-complete-dax-bootcamp-from-beginner-to-advanced/
课程评论：没有评论
**课程名称：** Power BI DAX 从入门到精通全能训练营 **课程概述：** 本课程旨在帮助学员全面掌握Power BI中的数据分析表达式（DAX）语言，从基础知识到高级技巧。即使您对Power Query中的数据连接和转换基础，以及数据建模基础没有深入了解，本系列课程也包含了入门所需的数据转换和建模基础知识，确保您能为DAX的学习打下坚实基础。 **课程亮点：** * **扎实的基础：** 回顾数据连接、Power Query数据转换基础以及数据建模要点，建立牢固的知识体系。 * **DAX精髓：** 深入理解DAX引擎，掌握行上下文和筛选上下文，学习计算表、计算列和度量值，区分隐式与显式度量值。 * **聚合函数：** 精通SUM、MIN、MAX、AVERAGE、COUNT、DISTINCTCOUNT、COUNTROWS等核心DAX聚合函数。 * **高级DAX技巧：** 掌握CALCULATE函数、上下文转换、变量和度量值表的运用，实现动态计算。 * **迭代器函数：** 学习SUMX、MINX、MAXX、AVERAGEX、COUNTX等迭代器函数，进行表级迭代和复杂计算。 * **筛选函数：** 运用FILTER、ALL、ALLEXCEPT、ALLSELECTED等筛选函数，有效管理和操控数据上下文。 * **信息函数：** 学习SELECTEDVALUE、HASONEVALUE、ISBLANK、ISEVEN、ISODD、ISTEXT、ISFILTERED、CONTAINSSTRING、INSCOPE等信息函数，进行高效的数据评估。 * **逻辑函数：** 应用IF、AND、OR、SWITCH、COALESCE等逻辑函数，创建稳健、动态的DAX表达式。 * **数学函数：** 使用ABS、VALUE、MOD、ROUND、DIVIDE等数学函数，进行精确计算和数据转换。 * **文本函数：** 精通CONCATENATE、CONCATENATEX、LEFT、RIGHT、UPPER、LOWER、LEN、REPLACE、SUBSTITUTE、FORMAT等文本处理函数。 * **表函数：** 掌握CALCULATETABLE、DISTINCT、VALUES、SUMMARIZE、ADDCOLUMNS、SELECTCOLUMNS、UNION、GENERATESERIES等表函数。 * **关系函数：** 理解RELATED、RELATEDTABLE、USERELATIONSHIP、CROSSFILTER等关系函数，管理数据间关系。 * **排名与Top N：** 学习TOPN和RANKX函数，实现数据集的排名和Top N筛选。 * **时间智能函数：** 掌握TODAY、DATE、NOW、CALENDAR、CALENDARAUTO等时间函数，以及YEAR、MONTH、QUARTER、WEEKNUM等日期拆分函数。深入学习TOTALYTD、TOTALQTD、TOTALMTD、DATESYTD、DATESQTD、DATESMTD、DATEADD、PARALLELPERIOD、SAMEPERIODLASTYEAR、DATESINPERIOD、EDATE、EOMONTH、PREVIOUSYEAR、PREVIOUSQUARTER、PREVIOUSMONTH、PREVIOUSDAY、NEXTYEAR、NEXTQUARTER、NEXTMONTH、NEXTDAY、STARTOFYEAR、STARTOFQUARTER、STARTOFMONTH、ENDOFYEAR、ENDOFQUARTER、ENDOFMONTH、DATEDIFF等函数，进行全面的时间段分析。 * **计算组：** 学习创建和管理计算组，优化DAX表达式，提升报表效率。 * **DAX语句：** 培养撰写和优化DAX语句的能力，实现高效的数据分析和报表制作。 * **视觉计算：** 利用上一项、下一项、第一项、最后一项、折叠、展开、累积总计和范围等功能，丰富可视化效果。 **附加特性：** * **实用技巧：** 学习简化DAX计算、提升效率的实用技巧。 * **实操练习：** 通过大量动手练习，巩固关键概念和技术。 * **解题详解：** 提供详细的练习解答，加深理解，提升实战能力。 **课程目标：** 学完本课程后，您将能够熟练运用DAX进行强大的数据分析和报告制作，充分释放Power BI的数据分析潜力。
Dive into the world of Data Analysis Expressions (DAX) in Power BI with my comprehensive course, designed to take you from fundamentals to advanced techniques. This course is ideal for those who have a basic understanding of data connecting and transformation fundamentals in Power Query, as well as data modeling basics (no worries even you don't have fundamental knowledge of data transformation and modeling, I have covered Data transformation and modeling fundamentals to get started DAX).Course Highlights:Fundamentals covered: Refresh your knowledge on data connecting and transformation fundamentals in Power Query and data modeling essentials to ensure a strong foundation.DAX Essentials: Understand the DAX engine, including row context and filter contexts, and explore calculated tables, calculated columns, and measures. Learn the differences between implicit and explicit measures.Aggregation Functions: Master core DAX functions for aggregation such as SUM, MIN, MAX, AVERAGE, COUNT, DISTINCTCOUNT, and COUNTROWS.Advanced DAX Techniques: Delve into CALCULATE functions, context transition, and the use of variables and measure tables for dynamic calculations.Iterator Functions: Learn to apply iterator functions like SUMX, MINX, MAXX, AVERAGEX, and COUNTX to iterate over tables and perform complex calculations.Filter Functions: Utilize filter functions including FILTER, ALL, ALLEXCEPT, and ALLSELECTED to manage and manipulate data contexts.Information Functions: Explore functions like SELECTEDVALUE, HASONEVALUE, ISBLANK, ISEVEN, ISODD, ISTEXT, ISFILTERED, CONTAINSSTRING, and ISINSCOPE for effective data evaluation.Logical Functions: Apply logical functions such as IF, AND, OR, SWITCH, and COALESCE to create robust and dynamic expressions.Mathematical Functions: Use mathematical functions like ABS, VALUE, MOD, ROUND, and DIVIDE for precise calculations and transformations.Text Functions: Master text manipulation with functions such as CONCATENATE, CONCATENATEX, LEFT, RIGHT, UPPER, LOWER, LEN, REPLACE, SUBSTITUTE, and FORMAT.Table Functions: Learn to handle tables with functions like CALCULATETABLE, DISTINCT, VALUES, SUMMARIZE, ADDCOLUMNS, SELECTCOLUMNS, UNION, and GENERATESERIES.Relationship Functions: Understand relationship functions such as RELATED, RELATEDTABLE, USERELATIONSHIP, and CROSSFILTER for managing data relationships.Ranking and Top N: Implement TOPN and RANKX functions to rank and filter top results in your datasets.Time Intelligence Functions: Master time-based calculations using DAX functions like TODAY, DATE, NOW, CALENDAR, and CALENDARAUTO. Learn to manipulate and analyze dates with functions such as YEAR, MONTH, QUARTER, WEEKNUM, and perform advanced time period calculations with TOTALYTD, TOTALQTD, TOTALMTD, DATESYTD, DATESQTD, DATESMTD, DATEADD, PARALLELPERIOD, SAMEPERIODLASTYEAR, DATESINPERIOD, EDATE, EOMONTH, PREVIOUSYEAR, PREVIOUSQUARTER, PREVIOUSMONTH, PREVIOUSDAY, NEXTYEAR, NEXTQUARTER, NEXTMONTH, NEXTDAY, STARTOFYEAR, STARTOFQUARTER, STARTOFMONTH, ENDOFYEAR, ENDOFQUARTER, ENDOFMONTH, and DATEDIFF for comprehensive time-based analysis.Calculation Groups: Learn how to create and manage calculation groups to streamline your DAX expressions and enhance reporting efficiency.DAX Statements: Develop proficiency in writing and optimizing DAX statements for effective data analysis and reporting.Visual Calculations: Enhance visualizations with calculations that include previous, next, first, last, collapse, expand, running sums, and ranges.Additional Features:Tricks and Tips: Discover practical tips and tricks to streamline your DAX calculations and improve efficiency.Assignments: Apply your learning with hands-on assignments designed to reinforce key concepts and techniques.Solution Walkthroughs: Review detailed solutions to assignments, gaining deeper insights and understanding to enhance your skills.By the end of this course, you'll be equipped with the skills to leverage DAX effectively for powerful data analysis and reporting in Power BI.
