|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/power-query-fundamentals
课程评论:没有评论
课程名称:Power Query 基础知识 课程概述:在这个在线的 Power Query 基础知识课程中,我们将探索数据转换和自动化的世界。您将学习如何从多个不同源提取数据,并将其转换为更适合分析的格式。我们会展示如何自动化数据连接和转换,以及如何从多个文件中提取和整合数据。最后,我们将介绍如何处理常见错误。 Power Query 对于任何专注于 Excel 的分析师至关重要。 课程大纲: 1. 入门 2. 基础转换 3. 提取信息 4. 数据整合 5. 处理错误 6. 资格评估
Name:Getting Started
Description:
Name:Basic Transformations
Description:
Name:Extracting Information
Description:
Name:Consolidating Data
Description:
Name:Dealing with Errors
Description:
Name:Qualified Assessment
Description:
In this online Power Query Fundamentals course, we’ll explore the world of data transformation and automation. You’ll learn to extract data from multiple different sources, and transform it into layouts more suited to analysis. We will show you how to automate data connections and transformations, as well as how to extract and consolidate data from multiple files. Finally, we’ll end by looking at how to deal with common errors. Power Query is absolutely essential for any Excel focused analyst,