|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-bi-desktop-dax-data-modeling-relationship-training/
课程评论:没有评论
课程名称:掌握 Power BI Desktop 中的 DAX 和数据模型 概述: 本课程提供终身访问课程材料和实践活动,并附有退款保证。如果您打算开始使用 Power BI 以及数据分析之旅,那么遵循一条正确的学习路径非常重要。本课程涵盖了数据分析的各个概念,包括数据收集的提取、转换和加载(ETL)活动;数据建模,关注数据规范化的重要性;数据表之间的关系,以理解信息的流动;DAX 的使用,以进行数据分析和处理;以及视觉分析,不仅限于数字,还有图表表示。 课程还包括与 Power Query 和 M 语言相关的内容,提供超过 6 小时的视频,利用真实世界的数据集进行说明。在完成 Power BI 查询编辑器课程后,您应该继续学习数据建模、关系和 DAX。本课程解决了许多 Udemy 上课程仅简要涵盖数据建模和关系的问题,强调正确构建数据对性能和 DAX 公式复杂度的影响。 课程详细讲解如何通过应用数据规范化的基本规则创建合适的数据模型。对于刚接触 DAX 的学习者来说,理解所写公式的结果可能是一项挑战。本课程以简单易懂的方式解释各种 DAX 公式,帮助学习者深入理解 DAX 的概念,如筛选上下文、行上下文、评估上下文、表或标量 DAX 函数、迭代器 DAX 函数、计算度量、计算列等。 如果您希望掌握 Power BI 中的 DAX 和数据模型,这门课程将为您提供宝贵的知识和技能。
**** Life time access to course materials and practice activities. Money back guarantee ****If you are planning to get started with Power BI and your data analytics journey it is very important that you follow a proper path to learn various concepts about data analytics.Gathering the data- Perform your Extract > Transform > Load (ETL) activities.Model your data - Normalizing your data is one of the critical stepRelationship between data tables - To understand the flow of informationDAX - Perform your data crunching and analysisVisual analytics - Not just numbers and but pictorial presentationI have covered ETL activities in my course titled - Power Bi Query Editor - Master Data Transformation. It have more than 6+ hours video content explaining all the concepts related to Power Query and M Language with the help of real world datasets.Once you have completed above course you must move on to next step for Data Modelling, Relationships and DAX.Currently various courses at Udemy will explain only DAX and will cover data modelling & relationship only briefly. However, structuring data properly is essential to achieving good performance in your reports and to maintaining a low level of complexity in your DAX formulas.The easiest way to create a data model in Power BI is to gather the data "as is" from a data source, define relationships, and then start designing reports. But this approach raises several issues when you have too many tables, or different levels of granularity. This course will explain in detail how you can create appropriate data models by applying fundamental rules of normalizing your data. For person starting with DAX it is little challenging as he may need to visualize in my mind what result he would get from the DAX formula he is writing. This can be confusing, so I have created this course which you will give simple and easy to understand explanation about using various DAX formulas. This course will guide you to deep understanding about various concepts of DAX like filter context, row context, evaluation context, Table or scalar DAX functions, Iterator DAX functions, Calculated Measures, Calculated Columns, etc.