|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-introduction-to-powerpivot/
课程评论：没有评论
Coursera 课程总结：Excel - Power Pivot 入门 (2024) 本课程由微软认证培训师 Barbara Evers 主讲，旨在教您如何将 Excel 升级为处理大数据的强大工具。 **课程概述：** Power Pivot 是 Exc el 的一个加载项，能够进行强大的数据分析并创建复杂的数据模型。通过 Power Pivot，您可以整合来自不同来源的海量数据，快速进行信息分析，并轻松分享您的见解。 **您将学到：** * 启用 Power Pivot 加载项并熟悉其界面。 * 管理数据关系。 * 创建 Power Pivot 报表。 * 在 Power Pivot 中创建计算。 * 创建关键绩效指标 (KPI)。 * 在 Power Pivot 中处理日期和时间。 * 运用 Power Pivot 的强大 DAX 功能。 * 在熟悉的 PivotTables 中查看分析结果。 **先修建议：** 强烈建议在学习本课程前完成“精通 Excel”系列课程，除非您已熟悉高级 Excel 主题，包括基础 PivotTables。 **课程特色：** * 超过 60 分钟的高质量高清内容。 * 采用 Bigger Brains 独特的“寓教于乐”师生互动教学风格。 通过本课程，您可以快速掌握所需的技能，并轻松地进行数据探索和分析。
Learn how to transform Excel into your big data power toolPower Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily.In this course, Microsoft certified trainer Barbara Evers will show you everything you need to know to install and start using Power Pivot in Excel. You'll learn how to add tables to data models, create and use KPIs, work with dates, and use the powerful DAX functionality. Then, you'll view the results of your work in familiar PivotTables.We strongly recommend you take our "Mastering Excel" courses before you proceed with Power Pivot, unless you are comfortable with advanced Excel topics including basic Pivot Tables.Topics covered include:Enabling the Power Pivot add-in and navigating its interfaceManaging data relationshipsCreating a Power Pivot ReportCreating calculations in Power PivotCreating a Key Performance IndicatorWorking with dates and time in Power PivotQuickly search for and find skills you want to master- then just point, click, and learn.Over 60 minutes of high-quality HD content in the "Uniquely Engaging"TM Bigger Brains Teacher-Learner style!
