|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-query-training-for-excel-2010-2013-2016-powerbi/
课程评论：没有评论
课程名称：Excel Power Query 培训 - 初学者到高级水平 概述：POWER QUERY（PQ）是一款由微软为Excel用户提供的免费工具。该工具能够迅速帮助初学者成为Excel专业用户，使学习过程轻松而难忘。Power Query适用于Excel 2010 / 2013 / 2016及Power BI，在Excel 2016中被称为"获取与转换"。无论是数据发现、数据重塑还是来自不同源的数据合并（合并/混合/整合等），Power Query都能满足需求。 Power Query可以直接连接到多种数据源，包括Excel、Access、文本文件、CSV、Hadoop、Salesforce、Azure等。用户可以自动化执行提取、转换、加载（ETL）等任务，以清理数据并使其能用于后续分析（如Tableau、Power BI、Excel等）。该工具易学，即使是新手用户也能快速上手，能够提取和连接几乎所有源的数据，满足数据分析的需求。 课程特色： - 记录所有操作步骤，便于日后回顾和修改。 - 提供直观的图形用户界面，便于快速自动化。 - 学习Power Query无需编程语言知识，例如Excel VBA或SQL。 - 在业务智能或数据分析项目中发挥重要作用。 如果你每天都处理数据、定期建立多个仪表板、需要从不同来源导入数据，或者经常创建管理信息系统（MIS）报告，那么这门课程非常适合你。无论你是Excel初学者还是高级用户，Power Query培训课程都是必修课。 在课程中，你将从基础开始学习，掌握Power Query的几乎80%的功能，能够将杂乱数据转化为干净的数据，供数据分析或可视化软件使用。课程的设计旨在让你有条理地学习如何使用Power Query进行各种数据清洗工作，无需编程知识。 完成课程后，你将从Power Query新手成长为熟练用户，投资此次课程的回报将在一个月内显现，帮助你节省在Excel上的工作时间和精力。如果对培训不满意，可以在30天内申请退款。快速报名，开始学习并运用Power Query！
What is POWER QUERY (PQ)? It's a FREE tool provided by Microsoft for Excel users. Yes you read it correctly. This tool is FREE!!! And Power Query can make novice Excel user to PRO-Excel user very quickly & this training will make your journey easy and memorable. Power Query is available for ALL users of Excel 2010 / 2013 / 2016 and PowerBI. In Excel 2016 it has been renamed as "Get & Transform". This course topics can be applied for all versions of Power Query - Excel 2010 / 2013 / 2016 & Power BI. Power Query is a tool that can be used for data discovery, reshaping the data and combining data ( Merge / Blend / Consolidate, etc.) coming from different sources. Power Query can connect directly to Excel, Access, Text, CSV, Hadoop, Sales Force, Azure and many other different sources of data. You can perform and automate all the Extract > Transform > Load (ETL) tasks required to clean the data and make it usable for further analysis in Tableau, Power BI, Excel, Access, etc. Power Query is a tool. Tool that is very easy to learn even for novice excel users.A tool that can extract / connect to data from almost any source.Merge and shape data sourced to match your data analysis requirementsPrepare your data for further analysis and modelling by tools like Power Pivot, etc.Keeps sequential record of all the steps performed from source till final outputYou can review your automation steps later and easily modify it. Thus, you can focus on turning data into insight and adding true value to your company and to yourself as well. The best part is that most of the automation features in Power Query are located within its ribbon so you have to just click it with mouse and start your automation in Excel. This GUI is one of the most intuitive interfaces I have found in any tool yet. For learning about Power Query you do not need to learn or have prior knowledge about any programming languages like Excel VBA or SQL, etc. If you are planning to implement Data Analytics or Business Intelligence solutions using Power Pivot, Power View, Power Map, Power BI, Tableau, Python or R, etc. then you must learn Power Query before all these other tools. Why should you learn Power Query? Now let's try to relate how Power Query can be useful to you. See if you answer positively to any one of the questions enumerated below: Do you work with data on daily basis?Do you regularly build multiple dashboards?Do you need to import data for above reporting from different sources?You have to perform extensive data cleansing before your perform analysis?Do you create Management Information Systems (MIS) reports regularly? Are you working as part of any Data Analytics Projects / Power BI / Tableau / Business Intelligence Projects?Do you use complex / advanced Excel formulas / Excel VBA coding (macros) / SQL? You might need to perform any of the following activities before data becomes usable: Filtering out data you don't needDeleting / sorting rows, columns or blanksTransforming text, numeric, and date columns.Removing spaces and special characters from your data.Fixing the layout into tabular format so that it will work in Pivot TablesRenaming, adding / removing, Splitting / joining and reordering columnsCreating calculating columns / fields which never existed in the source data.Merging / consolidating / appending data from Text files, CSV files or database tables.Incorporating the next month (or period) data to an existing report.Perform same steps again when receive new file or data in next month .and many more laborious repetitive tasks that consumes your day in and out. If you have answered positive for any of the questions or your job looks similar then you have come to right place - Power Query Training. It does not matter if you are a novice Excel user, or Advanced Excel user, you regularly code VBA / macros to automate repetitive task in Excel, this Power Query Training course is must for you. In this course as a beginners you will learn all the features from scratch. And after completing this course you would be proficient in using almost 80% of features in Power Query. This will guide to how convert dirty data into clean data which you can provide to your Data Analytics or Business Intelligence or Data Visualization Software. Thought process behind POWER QUERY and this training course: I have noted at numerous occasions that people are not aware about these new amazing tools introduced by Microsoft. Also, few people who have heard about it but does find proper resource to learn about using this tool. Hence i thought of publishing this Power Query Training here so that you can learn in structured manner about how to perform various data cleansing task in Excel using Power Query. You DO NOT need any programming, Excel VBA coding or SQL knowledge to start using Power Query. After completing this course you would be proficient in using Power Query and can immediately apply concepts to your work. You will move from Power Query newbie to proficient user after this course. I can confidently tell you that your investment in this course will be paid off within a months by way of saving you lot of efforts and time while working on Excel. And if you are not satisfied from this Power Query Training you can get your money back within 30 days of enrolling into the course. So Enroll quickly and start learning & using Power Query.
