|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-modeling-in-power-bi-build-powerful-data-models/
课程评论：没有评论
课程名称：Power BI中的数据建模：构建强大的数据模型 概述：数据建模是创建软件系统及其包含的数据元素简化图示的过程，使用文本和符号表示数据及其流动方式。数据模型为设计新数据库或重构遗留应用程序提供蓝图。总体来说，数据建模帮助组织有效利用其数据，满足信息的业务需求。数据模型可以被视为展示数据实体、属性及实体之间关系的流程图。它使数据管理和分析团队能够记录应用程序的数据需求，并在编写代码之前识别开发计划中的错误。此外，数据模型还可以通过逆向工程从现有系统提取，以记录在没有前期数据建模的情况下构建的关系数据库的结构，并为存储在数据湖或NoSQL数据库中的原始数据集定义模式，以支持特定的分析应用程序。 为什么要进行数据建模？数据建模是核心的数据管理学科。通过提供数据集及其业务上下文的可视化表示，它帮助确定不同业务流程的信息需求。然后，它指定将包含在应用程序中的数据元素的特征。
Data modeling is the process of creating a simplified diagram of a software system and the data elements it contains, using text and symbols to represent the data and how it flows. Data models provide a blueprint for designing a new database or reengineering a legacy application. Overall, data modeling helps an organization use its data effectively to meet business needs for information.A data model can be thought of as a flowchart that illustrates data entities, their attributes and the relationships between entities. It enables data management and analytics teams to document data requirements for applications and identify errors in development plans before any code is written.Alternatively, data models can be created through reverse-engineering efforts that extract them from existing systems. That's done to document the structure of relational databases that were built on an ad hoc basis without upfront data modeling and to define schemas for sets of raw data stored in data lakes or NoSQL databases to support specific analytics applications.Why is data modeling done?Data modeling is a core data management discipline. By providing a visual representation of data sets and their business context, it helps pinpoint information needs for different business processes. It then specifies the characteristics of the data elements that will be included in applications and in
