|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-power-tools-master-class-power-query-power-pivot-and-power-view/
课程评论：没有评论
课程名称：Power Query 和 Power View - Excel 强大工具大师班 课程概述： Power Query 通过直观且一致的体验提升了 Excel 的自助业务智能 (BI)，能够从多种数据源中发现、组合和精炼数据，如关系型、结构化和半结构化数据、OData、Web、Hadoop、Azure Marketplace 等。Power Query 将数据的强大能力带给普通的商业用户和 Excel 用户。Power View 则提供了互动式的数据探索、可视化和呈现体验，便于数据分析师、业务决策者和信息工作人员进行直观的即席报告。 课程总结： Power Query 是 Excel 的一个附加组件，适用于 Excel 2010 Professional Plus 和 Excel 2013。在 Excel 2016 中，它被称为“获取和发现数据”。Power Query 可以被形容为 Excel 用户的 SQL（无需掌握 SQL 的知识）。它允许用户从多种来源查找数据、组合数据、转换数据，进而使数据能够用于报告和数据分析。学习如何设置查询以从多个源提取数据、转换不同类型的数据，并了解如何使用 Power Query 自动化日常任务。 Power View 在 Excel 2013 和 SharePoint Server 2010 中可用。在 Power View 中，用户可以快速创建各种可视化，包括表格、矩阵、气泡图和小型多图集。每个想要创建的可视化都以表格为起点，并可以轻松转换为其他可视化形式，以确定最佳展示数据的方式。学习使用各种类型的 Power View 图表和地图可视化数据，以辅助业务决策，并设置层次结构使可视化更为互动。 课程内容： 课程的第一部分将从基础知识开始，学习如何设置 Power Query。您将下载示例数据进行实践，并通过案例研究学习如何利用组织内部的不同文件类型数据（如文本文件和 Excel 文件），结合外部数据（来自网页），准确计算潜在市场规模、实际市场规模和公司所占市场份额。此案例研究将为您提供 Power Query 的扎实工作知识。 接下来，我们将探讨 Power Query 的一些高级功能。您将学习使用被称为 M 的语言，如何查询不同类型的文件以及数据文件夹，还将学习如何排序“坏数据”，并使用 Power Query 自动化重复任务。此外，您将学习如何以及何时使用以下图表可视化数据： • 列和条形图 • 饼图 • 折线图 • 散点/气泡图 您将学习如何设置层次结构，使这些图表更具互动性，从而使分析更深入，并学习如何在地图上可视化数据。通过示例数据，您还将学习如何通过可视化轻松发现数据趋势，从而使业务决策变得更简单和可操作。 如果您希望将 Excel 技能提升到更高级别，并为您的组织带来业务分析和数据的力量，那么此课程非常适合您。
Power Query enhances self-service business intelligence (BI) for Excel with an intuitive and consistent experience for discovering, combining, and refining data across a wide variety of sources including relational, structured and semi-structured, OData, Web, Hadoop, Azure Marketplace, and more. Power Query brings the power of Data to the ordinary business and the Excel user. Power View is an interactive data exploration, visualization, and presentation experience. It provides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workers COURSE SUMMARY Power Query is an Excel add-in, available in Excel 2010 Professional Plus and Excel 2013. In Excel 2016 it is known as Get and discover data. Power Query can be described as SQL for Excel users (without the need for knowing SQL). It allows uses find data from multiple sources, combine data, transform data, and make the data usable for reporting and data analytics. LEARN HOW SET UP QUERIES TO EXTRACT DATA FROM MULTIPLE SOURCES, TRANSFORM DATA OF DIFFERENT TYPES AND LEARN HOW TO USE POWER QUERY TO AUTOMATE DAILY TASKS. MICROSOFT'S EXCEL, WHICH INCLUDES POWER QUERY, IS NOW PART OF A BI SYSTEM. IF YOU WANT TO IMPROVE YOUR EXCEL SKILLS FAR BEYOND THE BASIC LEVEL AND BRING BUSINESS ANALYTICS AND DATA TO YOUR ORGANISATION THEN THIS COURSE IS FOR YOU Power View is available in Excel 2013 and SharePoint Server 2010. In Power View, you can quickly create a variety of visualizations, from tables and matrices to bubble charts and sets of small multiple charts. For every visualization you want to create, you start with a table, which you can then easily convert to other visualizations, to determine which one best illustrates your data.LEARN TO USE POWER VIEW CHARTS AND MAPS OF ALL TYPES TO VISUALIZE DATA TO AID BUSINESS DECISIONS AND SET UP HIERARCHY TO MAKE VISUALIZATIONS MORE INTERACTIVE MICROSOFT'S EXCEL, WHICH INCLUDES POWER VIEW, IS NOW PART OF A SELF SERVICE BI SYSTEM. IF YOU WANT TO IMPROVE YOUR EXCEL SKILLS FAR BEYOND THE BASIC LEVEL THEN THIS COURSE IS FOR YOU CONTENTS AND OVERVIEW In section one of this course we will start at the very basics and learn how to set up Power Query. In this section you will find sample data to download, so you can practice along. You will then work though a case study on how an organisation can use internal data of different file types, such as Text files and Excel files, and then combine this data with External data from the web to accurately calculate the potential market size, the actual market size and the portion of the market held by the company. This case study will give you a solid working knowledge of Power Query.Next we will look at some more advanced features of Power Query. You will be introduced to the language use, which is known as M, you will learn how to query not just files of different types but also Folders of data. You will also learn how to sort "Bad Data" and user Power Query to automate reoccurring tasks. You will also lean learn how, and when to visualize data using • Column and Bar Charts• Pie Charts• Line charts• Scatter/bubble chartsYou will learn how to set up hierarchy and make these charts more interactive to give deeper analysis and how to visualize data on MapsIn addition to this through the sample data, will look at how trends in data are easily spotted using visualization, making business decisions easier and actionable.
