|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-bi-dax/
课程评论：没有评论
课程名称：Power BI DAX 大师班 - 指标与计算列 概述：本课程旨在让学习者从初学者成长为DAX领域的专业人士，深入掌握Power BI中通过指标和计算列进行高级分析的技巧。DAX是一种强大的语言，可以帮助用户挖掘数据中的高级洞察。但许多人在学习初期会感到迷茫和沮丧，缺乏清晰的学习路径和支持。为此，我设计了这门课程，让您能够系统地、轻松地掌握DAX，用于在Power BI中进行高级分析。 在课程中，您将从基础开始，逐步学习DAX，了解如何创建自定义列或使用更高级的计算。课程包含实际案例，您可以下载销售数据进行练习，确保您能够通过实践巩固所学知识。完成课程后，您将具备独立进行DAX分析的能力，并对DAX、指标和计算列有全面的理解。 课程内容包括： - DAX基础知识：指标与计算列的基本概念、指标与计算列的区别、过滤上下文与行上下文、数据模型中的DAX、聚合函数、逻辑运算符和IF语句、自动创建日期特征的综合数据表等。 - 高级主题：如SUMX和AVERAGEX等基于行的函数、累计总和、移动平均、变量、RANKX、自定义Top-N过滤、CALCULATE的使用及其相关过滤函数（ALL、ALLSELECTED、ALLEXCEPT、FILTER、VALUES）的正确应用、快速测量的使用及其最佳实践、时间智能功能（如年初至今、日期到月份等）及其重要时间智能函数的操作方法等。 通过本课程，您将获得在Power BI中使用DAX进行分析的必要知识和技能，从而提升您的数据分析能力。
From beginner to profesional in DAX - Master advanced analysis in Power BI with Measures & Calculated Columns DAX is a really powerful language if you want to get all the advanced insights from your data. Wether you want to create custom columns or use more advanced calculations with Measures and realize the full potential of Power BI - DAX is the key to that. Yet I know that many people feel discourage because they don't know where to start and without help it can be a bit frustrating and difficult. That's why I have created this course!In this course you will finally be able to learn DAX for your advance analysis in Power BI - and that in an easy and well structured way.Get a fundamental understanding right from the beginningIn this course I will teach you everything clearly by looking at actual examples. Therefore we will be looking together at some sales data that you will also be able to download - so you can work and practise as much as you want.Step by step you will then learn everything you need to know regarding DAX, Measures and Calculated Columns in Power BI.At the end of this course you will be able to do your own analysis in DAX. At this point it will be easy for you to do and learn more in DAX because you have gained a fundamental understanding in DAX, Measures and Calculated Columns.What you will learn in this course?· DAX fundamentals:· fundamental understanding of Measures & Calculated Columns · Measures vs. Calculated Columns· Filter context vs. row context · DAX in the data model· Aggregation functions· Logical Operators and IF-Statements· Automatically create comprehensive data tables with date features · Advanced topics:· Row based functions such as SUMX & AVERAGEX· Running Totals, Moving Average· Variables· RANKX· Custom Top-N-filtering· CALCULATE· All you need to know about CALCULATE· Filter functions· ALL, ALLSELECTED, ALLEXCEPT· FILTER, VALUES· How to use them the right way· Quick Measures· All you need to know about Quick Measures & how to use them properly· Time Intelligence· Year-to-Date, Date-To-Month etc.· The most important time intelligence functions and the right way to work with them· And much more!
