|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/clean-transform-and-load-data-in-power-bi/
课程评论：没有评论
**课程名称：** 在 Power BI 中清洁、转换和加载数据 **课程概述：** 本课程教授如何使用 Power BI Desktop 来连接、提取、转换、加载、建模和可视化数据。Power BI Desktop 是一个强大的工具，能够帮助您构建报告和模型数据。 课程将重点介绍数据清洁（移除数据集中不相关的数据）和数据转换（将数据从一种格式或结构转换为另一种格式或结构）的过程。您将学习如何处理未格式化的原始数据，并提取有价值的见解。 **核心内容：** * **Power BI Desktop 的作用：** 了解 Power BI Desktop 在数据分析流程中的核心功能。 * **数据清洁与转换的重要性：** 认识到数据准备对于有效分析的关键性。 * **Power Query 的强大功能：** 深入学习 Power Query 编辑器，这是 Power BI Desktop 内置的商业智能工具，用于数据清洁和转换。 * **实际操作技能：** * 简化复杂数据模型。 * 更改数据类型。 * 重命名对象。 * 数据透视（Pivot）操作。 * 处理来自各种数据源的复杂数据，使其更易于进行 DAX 计算和 Power BI 开发。 * 将数据转换为更简单、更易于理解的格式，减少 DAX 计算的复杂性。 **学习目标：** 通过本课程，您将掌握使用 Power Query 编辑器来有效地清洁和准备数据，从而为 Power BI 中的数据分析和可视化打下坚实的基础。
Power BI Desktop is an application that helps connect, extract, transform, load, model, and visualize data. Power BI Desktop also assists in building report and model data.Data cleaning is the process that removes data that does not belong in your dataset. Data transformation is the process of converting data from one format or structure into another.Data comes in an unformatted structure, and it requires a skill set to format the data and extract valuable insights from it. To analyse and extract data, we need a tool, and if someone asks me which tool I use for analysing the data; Without a second thought, I will name Power BI. Undoubtedly, Power BI transforms data in a correlative and interactive manner to analyse, extract and visualize it.Sometimes we get data from various data sources which are not in a format that can be easily transformed using simple methods in Microsoft Power BI. This might be due to the complexity and structure of the dataset. Thus, it becomes a hectic task to write simple DAX calculations from the datasets or even use it in any form in Power BI development. It is usually better to transform such datasets into forms which would require less complex DAX calculations with easily read and understood formats. This can be achieved within Power Query.Power Query has an incredible amount of features that are dedicated to helping you clean and prepare your data for analysis. You will learn how to simplify a complicated model, change data types, rename objects, and pivot data. Power query editor is the built-in Business Intelligence instrument present in Power BI Desktop to clean and transform your data. Any changes in the data are made with the help of Power Query Editor. All of the functions we will perform in this blog are done on Power query Editor.
