|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/data-modeling-in-power-bi
课程评论:没有评论
课程名称:Power BI 数据建模 课程概述:本课程是微软 Power BI 分析师专业证书的一部分。该专业证书由一系列课程组成,为使用 Microsoft Power BI 进行数据分析的职业生涯提供了良好的起点。在本课程中,您将学习如何使用 Power BI 创建和维护数据模型中的关系,并使用多种模式进行建模。您还将探索 DAX 的基础知识,这是 Power BI 的表达语言,并向您的模型添加计算,以创建相关元素。 课程大纲: 1. **数据建模概念** - 描述:本模块介绍数据建模及其创建所使用的模式。 2. **在 Power BI 中使用数据分析表达式 (DAX)** - 描述:本模块介绍 DAX 语言,探索 DAX 的语法并通过多个业务用例进行讲解。该模块还将 DAX 与以前关于数据库表的课程内容结合,并介绍时间智能的概念。 3. **优化 Power BI 中模型的性能** - 描述:本模块探讨优化过程,examines Power BI 中实现优化的工具和方法,包括使用性能分析器和 DirectQuery 功能。该模块还将深入探讨 DAX 及其在现实世界中的应用。 4. **最终项目与评估:Power BI 中的数据建模** - 描述:在本模块中,您将对课程中涉及的关键技能进行评估。该模块总结了课程内容,并反思主要学习目标,同时包含一个课程项目,将学习内容整合为一个实际的整体。 通过此课程,您将能够掌握 Power BI 的数据建模能力,并为未来的数据分析职业生涯打下坚实的基础。
Name:Concepts for data modeling
Description:This module introduces data modeling and the schemas used to create them.
Name:Using Data Analysis Expressions (DAX) in Power BI
Description:This module introduces the learner to the DAX (Data Analysis Expressions) language. The module explores the syntax of DAX using multiple business use cases. The module also integrates DAX with previous lessons on database tables and their use and introduces the concept of time intelligence.
Name:Optimize a model for performance in Power BI
Description:This module explores the optimization process and examines the tools and methods to achieve this in Power BI, including using performance analyzer and DirectQuery features. This module also dives deeper into DAX and its use in the real world.
Name:Final project and assessment: Modeling data in Power BI
Description:In this module, you will be assessed on the key skills covered in the course. This module summarizes the course and reflects on the primary learning objectives. The module also contains the project for the course, which encapsulates the learning into a practical whole.
This course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate consists of a series of courses that offers a good starting point for a career in data analysis using Microsoft Power BI. In this course, you'll learn how to use Power BI to create and maintain relationships in a data model and form a model using multiple Schemas. You'll explore the basics of DAX, Power BI's expression language, and add calculations to your model to create elements a