|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/big-data-in-excel-excel-2010-power-pivot/
课程评论：没有评论
**课程名称：** Excel 中的大数据 - Excel 2010/2013 Power Pivot **课程概述：** 本课程将教授您如何在 Excel 2010 或 2013 中直接进行大数据分析。Power Pivot 是微软推出的一款免费 Excel 插件，专为处理大型复杂数据集而设计，无需任何编程知识。 **课程特色：** * **实战导向：** 课程完全基于真实世界的用例，通过实践操作而非冗长的幻灯片进行教学。 * **素材可下载：** 教学中使用的所有素材均可供下载。 * **鼓励实验：** 鼓励学生亲自动手操作数据进行实验。 * **全面练习：** 每节课后都提供综合性练习，帮助您将新知识付诸实践。 * **随时答疑：** 讲师随时准备解答问题或讨论相关话题。 * **学习成果：** 课程结束后，您将能够： * 熟练处理大型数据集。 * 更有效地整合不同来源的数据。 * 掌握数据透视表和数据透视表的最佳实践。 * 创建交互式仪表板以回答业务问题。 * 更深入地理解数据库设计。 **预计完成时间：** 约 4 天，每天 2-3 小时（包含练习和作业）。 **课程目标：** 帮助您为大数据时代做好准备。 **课程大纲：** 无
Learn big data analytics directly in Excel 2010 or 2013. Power Pivot is free Excel add-in developed by Microsoft. It is designed to deal with large complex data sets. No programming required! Always working on real examples - the course is specifically based on real world use cases. No long slides, but rather hands on examples. All material used in lectures is available for download. Students are highly encouraged to experiment with data themselves. Comprehensive assignments will be available after each section. These will let you check newly acquired knowledge in practice. At any time I will be available to answer questions or simply discuss some interesting topic. At the end of the course you will feel comfortable in multiple areas: Working with large datasets Combine data from totally different data sources much more effectively Best practices on working with pivot tables and pivot charts Creating interactive dashboards to answer business questions Better understanding how databases are designed Taking into account exercises and assignment, course could be completed in a ~4 days 2-3 hours per day. Let's get ready for era of big data.
