|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/introducing-get-and-transform/
课程评论：没有评论
课程名称：介绍：获取与转换 / PowerQuery 概述： 本课程旨在帮助您将 PowerQuery 整合到您的工具集中，彻底改变您使用 Excel 的方式。Microsoft 的 PowerQuery（在 Excel 2016 中称为获取与转换）提供了一系列理想的工具，适用于访问本地和外部数据集、清理和重新构架信息为可用的格式、跨多个数据表进行查找和合并，以及构建信息丰富且功能强大的报告。 该课程适合任何新接触 PowerQuery 的用户，适用于各个级别的 Excel 用户。您将成为一个能够创建和编辑查询的用户，无需具备编码或 Excel 公式的知识。 课程亮点： - 解决繁琐的数据复制粘贴工作，轻松从不同来源生成数据请求。 - 通过数据标准化和清理组件快速提升数据处理效率。 - 用 PowerQueries 替代冗长且容易出错的 Excel 公式，大大提高工作效率。 - 学习如何使用 PowerQuery 界面进行直观的数据分析，而无需深入编写代码。 在课程的最后几节课中，您将了解到 M 语言的基础知识，通过自定义列创建工具以及 Microsoft Power Query M 语言参考中的函数部分，助您构建自定义计算。这些计算将为您未来深入学习 PowerQuery 打下良好的基础。 本课程还为您迈向更高级的 PowerQuery 课程做准备，是进入 PowerPivot 和某些 Power BI 内容的良好起点。课程结束时，您将能够自信地使用 PowerQuery 编辑器，并能够在 Power BI 中构建数据获取。 总之，PowerQuery 将使您超越Excel的局限，让数据分析变得更加高效且容易。
Incorporate PowerQuery into your toolset to revolutionize how you use Excel.Microsoft's PowerQuery (Get and Transform in Excel 2016) offers a wide variety of tools ideal for accessing local and external data sets, cleaning and re-framing information into usable structures, working across multiple data tables to perform lookups and combinations, and building informational and powerful reports.This course is for anyone new to PowerQuery and applicable to any level of Excel user. You will become a capable query creator and editor with no coding or Excel formula knowledge required. Access the world beyond Excel's boundariesEver copy and paste data from one workbook into another?What about from a webpage?Have you ever asked your database administrator for a data report to work with, and gone through a dozen iterations (and multiple weeks) before having something you could adequately use in Excel?Ever abandoned a project because automating data from an external source seemed too daunting or might have required VBA?PowerQuery can solve all of these issues. You will build data requests against these alternative sources quickly and easily, while incorporating data standardization and cleaning components into that same request. Replace many tedious and error-prone Excel formula-based approaches.This course will teach you how to perform effective data analysis that takes a fraction of the time to put together. Replace your vast spreadsheets packed with VLOOKUPs, SUMIFS, SUM, COUNTIFS, and more with PowerQueries that can be created with your mouse via clean and incredibly easy to use interfaces.These Excel functions provide some function of merging, linking, and aggregating. The PowerQuery tool includes mechanisms for performing these operations that make these functions seem quaint and outdated. Why write three columns of SUMIFS if you can get the same results with a single GROUP BY command without needing to write any formulas at all?A brief glimpse of PowerQuery's usefulness and capabilities...This course is designed for all Excel users since PowerQuery is designed for all users - not just power users capable of building incredible Excel worksheets with functions, VBA, and mystical trickery. As such, the course focuses almost exclusively on using the PowerQuery ribbon to perform every action. We do not dive into the Advanced Editor to interact with the M Language at all.In the last few lessons of the course, you will be introduced to the M Language through the custom column creation tool and introduced to the functions section of Microsoft's Power Query M Language Reference to assist you in building those custom calculations. These calculations are a great place to learn about how to interpret and use the functions in preparation for more advanced applications.Expand YOUR horizonsThis course will prepare you for more advanced PowerQuery courses and can serve as a good starting point for launching into PowerPivot and certain Power BI content. By the end of this course, you should feel comfortable in the PowerQuery Editor. This means that you'll be meaningfully capable of building data acquisition within Power BI by the end of this course, as the Excel PowerQuery Editor is simply the Power BI Query Editor minus a few advanced features.
