|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/building-bi-with-pivot-tables/
课程评论：没有评论
**课程名称：** Excel 数据透视表大师班：Excel 报表与仪表板 **课程概述：** 本课程专为希望通过数据透视表快速汇总海量数据（从几十行到数千行）并构建报表和仪表板的学员设计。您将学习如何高效地获取和清理源数据，并以易于理解的表格和可视化方式呈现数据，从而进行深入分析。课程还将深入探讨分析数据的最佳方法，以及如何进行数据的层层钻取和汇总。 完成本课程后，您将能够自信地进行数据采集、清理，并通过数据透视表和仪表板进行分析。本课程面向希望提升 Excel 技能的初学者和中级用户。您应具备基本的 Excel 操作能力，了解公式会更有帮助。即使您对数据透视表完全陌生，本课程也能从零开始教授您数据收集、清理、设置，以及如何使用数据透视表和数据透视表图表构建仪表板。 **讲师介绍：** Ken Puls 是一位 Excel MVP、知名博主、会议演讲者，也是《M is for Data Monkey》（一本关于 Excel Power Query M 语言的指南）的合著者。
Building Business Intelligence with Pivot Tables is an online video course that is perfect for anyone looking to build reports and quickly summarize 10s to 1,000s of rows of data quickly. This course will provide the analyst with the best ways to source and clean up source data for reporting. As the data is cleansed, the course will show you how to present the data in a way that is easy to use for analysis by presenting data in both tabular and visually. The course will further explore the best ways to analyze the data and drill in and out of data By the end of this course, you will feel confident sourcing data, cleansing it, and analyzing it through pivot tables and dashboards. This is a course aimed squarely at the beginner/intermediate Excel users looking to take their skills to the next level. Before starting this course, you should be comfortable working in Excel. Knowledge of a variety of formula can be helpful, although is by no means necessary. While those comfortable with Pivot Tables are likely to pick up new tricks to make their lives easier, the course is designed to take someone with absolutely no Pivot Table knowledge and teach them how to collect, clean and set up the data, present it in Pivot Tables and build dashboards using Pivot Charts. The instructor, Ken Puls, is an Excel MVP, blogger, conference speaker, and co-author of "M is for Data Monkey" - a guide to the M language in Excel Power Query.
