|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-query-y/
课程评论：没有评论
**课程名称：** Power Query **课程概述：** 如果您曾经花费大量时间在Excel中收集、修复和合并数据，本课程将向您展示Power Query如何彻底改变您的工作方式。Power Query是Excel近十年来最重要的功能之一，它允许您从各种格式的数据源中提取数据，并只需点击几下即可完成数据清理。 **Power Query如何节省时间：** * **自动化更新：** 对于需要频繁更新的报表，您可以创建一个数据源的“查询”。每次需要更新时，只需点击“刷新”，Power Query将自动执行所有必要的数据清理步骤。 * **高效清理：** 对于混乱或非结构化的数据，Power Query提供多种功能，如“逆透视”（Unpivot）、“追加”（Append）、“联接”（Join）和“转置”（Transpose），可以即时修复数据。 Power Query的神奇之处在于它能够避免耗时的传统Excel数据清理方法，并且它不仅限于Excel数据，还可以处理来自数据库、SAP、Salesforce、SharePoint等各种数据源的数据。 **课程内容：** 本课程由拥有30多年数据经验的专家Ross Hughes教授。在短短几个小时的自主学习中，您将学习完成数据“获取、转换和刷新”的完整流程，使您的数据为快速分析和报告做好准备。 **您将学到：** * 从各种来源获取数据并进行清理的入门知识。 * 快速进行数据“转置”、“透视”和“逆透视”，使数据更具可用性。 * 如何通过“追加”和“联接”快速合并多个数据集。 * 通过移除重复项和调整参数来加速数据查询。 * 如何对查询进行故障排除并设置数据自动刷新。
If you have been wasting vast amounts of time at work trying to gather, fix and combine your Excel data before you've ever done any analysis and reporting, then let our resident Data expert show you how Power Query can transform the way you work!HOW POWER QUERY CAN PREVENT TIME WASTINGPower Query is the No.1 Excel feature added in the last decade because it can help you get data from various sources, no matter what format it is and clean it all up for you with nothing more than a few clicks! Specifically, there are two ways Power Query saves you vast amounts of time:If you have reports that are frequently updated, then you just create a ‘Query' from a source of data then all you need to do is press refresh every time you need to update, and Power Query will carry out all the little steps needed to clean up your dataIf you work with messy or unstructured data that consumes a lot of your time to clean up, then Power Query has some functions that instantly fix your data such as unpivoting, appending, joining and transposing to name a fewPower Query's magic is in saving you from all the usual ways to clean up your Excel data that are far too time-consuming. But it's not just Excel data you clean up, it's any data from most Databases, SAP, Salesforce, SharePoint and so on.HOW THIS COURSE WILL HELP YOUThis video course is taught by our in-house Data expert Ross Hughes who has over 30 years of experience working with Data in senior technical roles within major companies. In a few short hours of self-paced training, Ross will have you going through the full cycle of ‘Getting, Transforming and Refreshing' your data, after which it will be ready for quick analysis and report.Ross' experience is priceless, he shows you how to harness Power Query like few can and having him, teaching you ‘over his shoulder' is more than worth the price of the course.WHAT YOU WILL LEARN:You will learn all you need to know about Power Query to help you deal with difficult data challenges.· Introduction to getting data from various sources and cleaning it up· Rapidly transpose, pivot and un-pivot your data to make it useful· How you can quickly combine multiple data sets by appending and joining· Speed up your data queries with duplication and tweaking parameters· Troubleshoot your queries and set up auto-refreshing of your data
