|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-2013-dashboard-design/
课程评论：没有评论
课程名称：Excel 2013 仪表盘设计 课程概述：Excel 2013 仪表盘设计将教您如何将组织的数据转化为强大且互动的仪表盘。通过学习这些易于实施的高级技术，您可以给决策者留下深刻的印象，使自己成为不可或缺的资产。课程开始于与相关方共同制定仪表盘的愿景，然后收集数据并构建仪表盘的各个元素。最后，课程将比较适合不同规模和类型组织的分发策略。 第一部分“输出与输入”涵盖了规划最终产品的战略性方面，以及如何从数据库或Excel工作簿中引入所有必要的数据。接着，我们探讨PowerPivot，这是一座将原始数据与Excel连接的强大桥梁。PivotTables将帮助我们灵活切分数据，而图表则让重要的指标和趋势一目了然。样式设计和交互性增强了用户体验，将信息以可管理的格式呈现。有效的发布策略对于不同规模的受众至关重要，课程将介绍最有效的仪表盘分发方法。 Excel 2013 仪表盘设计将引导您完成整个项目的每个部分，从头到尾深入探讨。在学习如何执行每项任务的同时，您还将了解其带来的好处，从而能够轻松地将所学应用到您自己的仪表盘设计项目中。 作者简介：Tony Kau是Tableau Desktop 8认证专家，目前在一家财富500强企业担任报告分析师，善于将数据转化为战略商业决策。他在商业智能软件方面拥有十年的经验，热衷于高效利用数据来推动决策。他拥有俄勒冈大学的工商管理学位，背景涵盖网页设计、编程和财务分析。
Excel 2013 Dashboard Design will show you how to turn your organization's data into a powerful and interactive dashboard. By learning these easy-to-implement, advanced techniques, you can impress and empower the decision-makers in your organization, making you an irreplaceable asset. Excel 2013 Dashboard Design begins by creating a vision for the dashboard with the help of stakeholders, and then moves on to gathering the data and building each element of the dashboard. The course ends with comparing distribution strategies appropriate for every size and type of organization. The first section, Outputs and Inputs, covers the strategic aspects of planning your finished product and bringing in all of the necessary data from your database or Excel workbook. We then explore PowerPivot, a powerful bridge between your raw data and Excel. PivotTables will help us slice our data in a flexible manner, and Charts give us at-a-glance comprehension of important metrics and trends. Stylizing and Interactivity enhance the user experience and present the information in a manageable format. Publication can be problematic without proper planning, but we'll cover the most effective ways to distribute your dashboard to any type or size of audience. Excel 2013 Dashboard Design will guide you through your entire project, start to finish, covering every part of the process in depth. Since you'll not only learn how to do each task, but also why it would be beneficial for you, you'll be able to easily translate your learning into your own dashboard design project. About the Author Tony Kau is a Tableau Desktop 8 Qualified Associate, and he is putting its power to use in his role as a reporting analyst for a Fortune 500 company. His analytical background spans a decade, during which he has used a variety of business intelligence software, though none were better than Tableau. His passion is efficiently leveraging data to inform strategic business decisions. He holds a degree in Business Administration from the University of Oregon, and his background includes web design, programming, and financial analysis.
