|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-modelling-for-beginners/
课程评论：没有评论
课程名称：初学者数据建模 课程概述：数据模型是指在信息世界中，不同数据元素之间的逻辑关系和数据流。它还记录了数据存储和检索的方式。数据模型有助于表示何种数据是必要的，以及在不同业务流程中应使用何种格式。Power BI 是一种商业分析解决方案，可让您可视化数据并在组织内部分享见解，或将其嵌入到应用程序或网站中。通过连接数百个数据源，您可以通过实时仪表板和报告将数据生动呈现。数据建模是连接多种数据源的 BI 工具的一个重要特性，通过关系定义数据源之间的连接方式，从而可以对多个数据源创建有趣的数据可视化。使用建模特性，您可以在现有表上构建自定义计算，并直接在 Power BI 可视化中展示这些列。这使企业能够定义新的指标并对这些指标进行自定义计算。 您将学习到的内容包括： - 如何连接到 Microsoft Access 数据库文件 - 如何创建和管理数据关系 - 如何创建计算列 - 如何优化模型以进行报告 - 如何在数据上实现时间智能 - 如何在可视化中应用过滤器 此课程适合渴望学习数据建模基础知识的初学者。
A data model refers to the logical inter-relationships and data flow between different data elements involved in the information world. It also documents the way data is stored and retrieved. Data models help represent what data is required and what format is to be used for different business processesPower BI is a business analytics solution that lets you visualize your data and share insights across your organization, or embed them in your app or website. Connect to hundreds of data sources and bring your data to life with live dashboards and reports.Data Modeling is one of the features used to connect multiple data sources in BI tool using a relationship. A relationship defines how data sources are connected with each other and you can create interesting data visualizations on multiple data sources.With the modeling feature, you can build custom calculations on the existing tables and these columns can be directly presented into Power BI visualizations. This allows businesses to define new metrics and to perform custom calculations for those metrics.What You will Learn includes:How to connect to Microsoft Access Database FileHow to create and manage data relationshipHow to create calculated columnsHow to optimize models for reportingHow implement time intelligence on dataHow to apply filters on visuals
