|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-data-analyst-excelpowerquerypowerpivotpivotcharts/
课程评论：没有评论
课程名称：Excel 数据分析师 - Excel/PowerQuery/PowerPivot/PivotCharts 课程概述： 本课程介绍了Microsoft Excel在数据分析中的应用，Excel是最流行的数据分析工具之一。课程中将深入探讨Excel内置的透视表功能，透视表被广泛认为是最强大的分析工具，能够轻松导入、探索、清洗、分析和可视化数据。透视表通过对存储在表格中的数据进行汇总和重新排列，强化了数据分析的有效性。 数据排序是数据分析中至关重要的一环，学员将学习如何按一列或多列对数据进行升序或降序排序。同时，Excel的过滤功能能根据特定标准临时显示相关数据，帮助用户集中关注数据集中的重要领域。 课程还将介绍Power Query，这一功能支持通过外部来源（如文本文件、CSV文件、网页或Excel工作簿）将数据导入Excel，并对其进行清洗和准备。学员将了解到Power Pivot的数据建模技术，可以创建数据模型、建立关系，并进行计算，适用于处理大型数据集，并能够在高效环境下构建复杂的计算。 此外，课程将详细讲解透视表和透视图的概念，透视表聚合来自更大表格的单个项目，并通过选择的聚合函数进行统计计算，而透视图则是透视表的视觉化表现。 本课程旨在帮助学员掌握Excel的高级数据分析技能，为数据管理与决策提供有力支持。
Microsoft Excel is one of the most popular applications for data analysis. Equipped with built-in pivot tables, they are without a doubt the most sought-after analytic tool available. It is an all-in-one data management software that allows you to easily import, explore, clean, analyse, and visualize your data. Pivot tables are known for being the most purposeful and powerful feature in Excel. We use them in summarizing the data stored in a table. They organize and rearrange statistics (or "pivot") to bring crucial and valuable facts to attention. It helps take an extremely large data set and see the relevant data you need in a crisp, easy, and manageable way.Sorting data is a very critical and vital part of Data Analysis. You can sort your Excel data by multiple columns or even a single column. The sorting is done in ascending or descending order as well.What is Filter in Excel? The filter in excel helps display relevant data by eliminating the irrelevant entries temporarily from the view. The data is filtered as per the given criteria. The purpose of filtering is to focus on the crucial areas of a dataset.Power Query allows a user to import data into Excel through external sources, such as Text files, CSV files, Web, or Excel workbooks, to list a few. The data can then be cleaned and prepared for our requirements.Power Pivot is a data modelling technology that lets you create data models, establish relationships, and create calculations. With Power Pivot you can work with large data sets, build extensive relationships, and create complex (or simple) calculations, all in a high-performance environment, and all within the familiar experience of Excel.A pivot table is a table of grouped values that aggregates the individual items of a more extensive table within one or more discrete categories. This summary might include sums, averages, or other statistics, which the pivot table groups together using a chosen aggregation function applied to the grouped values.A pivot chart is the visual representation of a pivot table in Excel. Pivot charts and pivot tables are connected with each other.
