|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-bi-data-modeling-2024/
课程评论：没有评论
Coursera 课程《Power BI - 数据建模 (2024)》摘要 本课程由微软培训师 Kathy Snizaski 主讲，旨在教授学员如何使用 Power BI 设计和构建结构良好的数据模型。Power BI 是一个强大的数据分析和报告工具。 **课程主要内容包括：** * **数据源连接：** 识别可用的数据源，并了解如何连接到 Excel 文件、CSV 文件以及 SharePoint 列表数据，还可以手动输入数据作为数据源。 * **数据加载设置：** 在导入数据前，确定数据加载设置（DirectQuery 与导入模式的区别）。 * **数据转换与清洗：** * 评估数据完整性，检查列的质量、分布和概要。 * 修改数据类型，并学习使用“应用步骤”进行数据处理。 * 掌握多种转换数据的方法，包括合并表格、按分隔符拆分列、取消透视字段等。 * **数据模型关系：** * 管理表格之间的关系。 * 确定关系类型（基数）。 通过本课程的学习，学员将能够熟练运用 Power BI 构建高效的数据模型，从而更好地进行数据分析和可视化。
Learn to use Power BI to design and build a well-structured data model.Power BI is a powerful tool for analyzing and reporting data. In Power BI Data Modeling, Microsoft Trainer Kathy Snizaski demonstrates how to use Power BI for building and transforming working data models. You'll learn how to connect to various data sources, transform data, and build relationships between tables.Kathy will show you how to identify which data sources are available for connection and how to determine Data Load settings before importing data. You'll see how to connect to Excel files, CSV files, and SharePoint list data and how to manually enter data to load as a data source.You'll learn how to clean data by first determining the data integrity and then changing the data types and working with applied steps. You'll also learn how to transform the data using multiple tools as well as how to manage relationships between tables and determine cardinality. By the end of this course, you will have the information you need to effectively use Power BI to build your data models.Topics covered include:Identifying which data sources are available for connectionExplaining the difference between a direct query and importing dataDetermining Data Load settings before importing dataConnecting to Excel and CSV files and to data stored in a SharePoint listEntering data to load as a data sourceDetermining the integrity of the data by previewing the column quality, distribution, and profileChanging data types and working with applied stepsMerging tablesSplitting columns by a delimiterUnpivoting fields within a queryManaging relationships between tablesDetermining cardinality
