|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/excel-power-tools
课程评论：没有评论
课程名称：Excel 数据分析中的强大工具 课程概述：欢迎参加 Excel 数据分析中的强大工具课程。在这为期四周的课程中，我们将介绍 Power Query、Power Pivot 和 Power BI，这三种功能强大的工具用于转换、分析和呈现数据。尽管 Excel 的灵活性和易用性长期以来使其成为数据分析的首选工具，但它也存在一些固有的局限性，比如真正的“大数据”无法完全在电子表格中处理，以及导入和清理数据的过程往往重复繁琐且容易出错。近年来，微软致力于改善分析师的整体体验，Excel 通过引入 Power Query 和 Power Pivot 进行了重大升级。 在本课程中，我们将学习如何使用 Power Query 自动化导入和准备数据以进行分析的过程。同时，我们将了解 Power Pivot 如何通过在 Excel 工作簿中提供一个分析数据库来彻底改变分析过程，能够存储百万行数据，并使用强大的建模语言 DAX 来对数据进行高级分析。最后，我们将走出 Excel，介绍 Power BI，该工具同样利用了 Power Query 和 Power BI 的架构，但使我们能够创建动态交互的报告和仪表板。 本课程是数据分析与可视化专业化的第三门课程，之前的课程包括 Excel 数据分析基础和 Excel 中的数据可视化，涵盖了数据准备、清理、可视化和创建仪表板等内容。为了最大程度地受益于本课程，我们建议您完成之前的课程或具备相关经验。本课程集中于 Excel 的强大工具，欢迎您一起加入这一激动人心的旅程。 请注意，Power Query、Power Pivot 和 Power BI Desktop 仅在 Windows 平台上可用，因此 Mac 用户需要通过 Bootcamp 或虚拟机运行 Windows 操作系统。虽然 Power Query 在 Excel 2010 和 2013 中作为插件可用，但工具的变化很大，本课程仅设计并针对 Excel 2016 及以上版本进行测试。为了获得最佳体验，推荐使用 Office 365。 大纲： 1. 欢迎与重要信息：介绍课程内容，帮助您了解课程目标，并鼓励学生与其他学习者分享自身目标。 2. 获取和转换（Power Query）：学习如何从不同来源导入数据以及根据需求组合数据集。 3. 在查询编辑器中转换数据：探讨数据导入后如何进行转换，包括数据透视和分列。 4. Power Pivot 和数据模型：了解 Excel 中的数据模型如何处理超出百万行的庞大数据，并定义表之间的数据库关系。 5. 使用 Power BI 可视化数据：实践 Power Query、M 和 DAX 的技能，创建动态互动的 Power BI 报告和仪表板，并分享给他人。
Name:Welcome and critical information
Description:Welcome to Excel Power Tools for Data Analysis. In this course, you will learn about importing and transforming data with Power Query, working with huge datasets in Power Pivot, and creating interactive reports with Power BI. This introductory material will help orient you into the course. We encourage you to think about your goals for the course and share them with your fellow learners.
Name:Get and Transform (Power Query)
Description:Often the first steps when analysing data are to import the data and combine different datasets together. In Excel, you can use Get and Transform, previously known as Power Query, to help with this. In this module, you will learn how to import data from various sources and the different ways to combine datasets depending on your requirements.
Name:Transforming data in the Query Editor
Description:Once your data is imported and combined, you then move on to transforming it. A common operation is to pivot data between wide and long formats. You can group data and split a column into multiple columns. Power Query has a few extra options that a normal PivotTable doesn't have.
Name:Power Pivot and the Data Model
Description:An Excel workbook can handle up to 1 million rows, which sounds like a lot but sometimes you have more data than that. The Data Model in Excel is only limited by the amount of memory your computer has. You can also define database-like relationships between tables. Then you can visualise your data using Power Pivot and cube functions, and create PivotTables.
Name:Visualising Data with Power BI
Description:We are moving out of Excel with this module. Power BI is Microsoft's Business Intelligence tool. You can put into practice the skills that you have learned in Power Query, M, and DAX, to create dynamic and interactive reports and dashboards in Power BI. Once you have the report looking how you want, share it with others.
Welcome to Excel Power Tools for Data Analysis. In this four-week course, we introduce Power Query, Power Pivot and Power BI, three power tools for transforming, analysing and presenting data. Excel's ease and flexibility have long made it a tool of choice for doing data analysis, but it does have some inherent limitations: for one, truly "big" data simply does not fit in a spreadsheet and for another, the process of importing and cleaning data can be a repetitive, time-consuming and error-prone. Over the last few years, Microsoft have worked on transforming the end-to-end experience for analysts, and Excel has undergone a major upgrade with the inclusion of Power Query and Power Pivot. In this course, we will learn how to use Power Query to automate the process of importing and preparing data for analysis. We will see how Power Pivot revolutionises the actual analysis process by providing us with an analytical database inside the Excel workbook, capable of storing millions of rows, and a powerful modelling language called DAX which allows us to perform advanced analytics on our data. We will finish off by venturing out of Excel and introducing Power BI, which also uses the Power Query and Power BI architecture but allows us to create stunning interactive reports and dashboards. This is the third course in our Specialization on Data Analytics and Visualization. The previous courses: Excel Fundamentals for Data Analysis and Data Visualization in Excel, cover data preparation, cleaning, visualisation, and creating dashboards. To get the most out of this course we would recommend you do the previous courses or have experience with these topics. In this course we focus on Excel Power Tools, join us for this exciting journey. Please note that Power Query, Power Pivot and Power BI Desktop are only available on the Windows platform, so Mac users will require Bootcamp running Windows or a Virtual machine with a Window O/S. While Power Query is available as an add-in Excel 2010 and 2013, the tools have changed significantly, and this course has only been designed and tested for Excel 2016 and later. For an optimal experience, we recommend Office 365.
