|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-power-bi-dax-super-user-intermediate/
课程评论:没有评论
**课程名称:** Power BI DAX 超级用户:为 Power 极客而生的 DAX **课程概述:** 本课程是为希望深入学习 Power BI DAX 函数语言的进阶用户设计的。在完成初级的 Power BI 数据分析课程后,您将为提升技能做好准备,并真正掌握 Power BI 公式中使用的 DAX 语言。 **主要学习内容:** * **探索30+个DAX函数:** 课程将覆盖九大类别的30多个DAX函数,包括: * 条件与逻辑函数 * 日期与时间函数 * 数学与统计函数 * 文本函数 * 迭代函数 * 时间智能函数 * 表与筛选函数 * 经典的CALCULATE函数 * 信息函数 * **公式构建与问题解决:** 学习如何分步构建 DAX 公式,使其更易于理解和使用,并将此知识应用于让度量值调用其他度量值。 * **创建度量值表:** 学习如何构建一个“度量值表”,以集中管理报告中创建的所有度量值,保持组织性和易用性。 * **滚动日历的应用:** 理解拥有滚动日历的必要性及其为处理多个日期字段的表所带来的好处,滚动日历能随着新数据的添加自动调整日期。 * **提升报告交互性:** 学习从市场获取吸引人的新视觉对象,并使用精美的切片器,从而使您的报告对用户而言更具交互性。 **课程目标:** 通过本课程的学习,您将能够自信地构建 DAX 公式以获得所需结果,并能在报告中运用具有视觉吸引力的新型视觉对象来展示数据分析成果,最终为公司提供有价值的洞察。
Welcome to my intermediate level for Power BI users who want to delve deeper into the DAX functional language. After taking my Power BI Data Analysis Course (for beginners) you now will be ready to take your skills to the next level and really get a grasp on the DAX language that is used in Power BI formulas.In this course we will implement over 30 DAX functions from across nine different categories:Conditional & Logical FunctionsDate & Time FunctionsMath & Stats FunctionsText FunctionsIterator FunctionsTime Intelligence FunctionsTable & Filter FunctionsInfamous CALCUALTE FunctionInformation FunctionsI will teach you how to problem solve your formulas and how to build them in pieces, so they are easier to understand and use that knowledge to have your measures call other measures. Not to mention learn to build a measures table to hold all the measure you will create for your report to keep them organized and all in one place.You will also learn the need to have a rolling calendar and the benefits it provides for those people who have a multitude of tables with date fields and how the table will auto adjust its dates as new data is added. All that combined with installing appealing new visuals from the marketplace and using stunning slicers to make your reports more interactive for your user. By the end of this course, you will have the confidence to build out your formulas to get the results you need and the visually appealing new visuals on your reports that show the results of your data analysis for the company!