|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-excel-for-large-data-sets/
课程评论：没有评论
课程名称：学习如何使用Excel处理大数据集 课程概述：欢迎参加本课程。本课程将教您如何更高效地使用Excel处理大数据集。您将学习从多个来源加载数据的各种方法，以及如何将数据导入Excel、使用不同技术汇总数据，并理解和运用处理大数据集时的最佳实践。课程内容包括如何使用数据模型组织大型数据集，利用Excel表格和数据透视表汇总数据。此外，您还将学习Microsoft Power BI的基础知识，掌握加载大数据、建模数据及利用Power BI提供的优秀可视化功能来可视化数据并制作报告的方法。成功完成此课程后，您将能够在最短的时间内处理大数据集，并从数据中获得深刻见解。您将能够迅速对大数据进行汇总和报告，效率达到分钟级别。 课程内容涵盖： - 数据加载 - 数据处理和清理 - 使用Excel表格 - 使用数据透视表 - 数据汇总、搜索和筛选 - 数据建模 - 创建和使用度量值 - Power BI基础 - 数据可视化
Welcome.This course will teach you on how to become more effective in working with large datasets using Excel.You will learn various ways to load data from various several sources, to import your data into excel, to summarize your data in excel using various techniques and to understand and use best practices when working with large data sets.You will learn how to use data models to organize your large data set, to use excel tables and pivot tables to summarize your data. You will also learn the basics of using Microsoft Power Bi to load large data, to model your data and using great visuals provided by Power BI to visualize your data and make reports.After successful completion of this course, you will be able to spend the shortest amount of time to work with your large data sets and create amazing insights from your data.You will be able to quickly take large data and make summaries and reports from it, within minutes.Areas you will cover:Loading data.Data manipulation and clean up.Using Excel tables.Using Pivot Tables.Summarizing, searching and filtering data.Data Modeling.Creating and using measures.Power Bi Basics.Data Visualization.
