|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/data-visualization-dashboards-excel-cognos
课程评论：没有评论
课程名称：Excel 和 Cognos 的数据可视化与仪表板 课程概述： 本课程涵盖数据可视化和仪表板开发的基础步骤。学员将通过创建 Excel 等电子表格中的各种图表，开始用数据讲述故事的过程。探索电子表格的不同工具，如重要的透视表功能和创建仪表板的能力，学习每种工具如何独具特性地转化数据。课程还将介绍流行的分析工具 IBM Cognos Analytics，学员将通过该工具创建交互式仪表板。 通过完成本课程，学员将基本理解如何将电子表格作为数据可视化工具。学员能够有效创建数据可视化，如图表和图形，并认识到这些可视化在传达数据分析结果中的重要性。整个过程无须编写代码，通过学习 Excel 和 IBM Cognos Analytics 的基础数据分析，学员将具备描述数据分析师使用的常见仪表板工具的能力，设计并创建云平台上的仪表板，并提升中级数据可视化的自信心。 课程中包含众多实践实验和最后项目。每个实验将使学员获得创建基本和高级图表的实践经验，随后继续通过电子表格和 IBM Cognos Analytics 创建仪表板。课程结束时，学员将使用 IBM Cognos Analytics 创建一组数据可视化，并构建一个可以与同伴、专业社区或潜在雇主共享的交互式仪表板。 本课程不要求学员具备数据分析或计算机科学的先前经验。开始学习所需的仅为基本的计算机素养、高中水平的数学，能够访问现代网页浏览器（如 Chrome 或 Firefox），创建 Microsoft 帐户以访问 Excel for the Web，以及对 Excel 电子表格的基本理解。 课程大纲： 1. **使用电子表格可视化数据** - 介绍图表和 Excel 函数的基础，学习如何创建基本图表和透视图。理解图表在讲述数据驱动故事中的重要角色。 2. **使用电子表格创建可视化和仪表板** - 学习创建高级图表和可视化，并了解仪表板的基础知识，以及如何使用电子表格创建简单仪表板。 3. **使用 Cognos Analytics 创建可视化和仪表板** - 介绍另一种仪表板解决方案 Cognos Analytics，探索其平台功能，创建可视化，构建简单仪表板，并发现其高级功能。可选地，探索 Google Looker Studio 创建可视化和构建仪表板。 4. **最终项目** - 恭喜您完成本课程的模块！在这一模块中，您将完成一个由同伴评分的最终作业。作业的第一部分，使用提供的样本数据创建 Excel 电子表格的可视化；第二部分，使用 Cognos Analytics 或 Google Looker Studio 创建可视化并将其添加到仪表板中。
Name:Visualizing Data Using Spreadsheets
Description:In this module, you will be introduced to the basics of charts and the Excel functions that are used to create basic charts and pivot chart visualizations. By learning how to manipulate these features and creating visualizations, you will begin to understand the important role charts play in telling a data-driven story.
Name:Creating Visualizations and Dashboards with Spreadsheets
Description:In this module, you will learn about creating advanced charts and visualizations and learn about the basics of dashboarding and how to create a simple dashboard using a spreadsheet.
Name:Creating Visualizations and Dashboards with Cognos Analytics
Description:In this module, you will be introduced to another dashboarding solution called Cognos Analytics. After registering with Cognos Analytics, you will then explore the platform capabilities by creating visualizations, building a simple dashboard, and discovering its advanced features. Optionally, you can explore Google Looker Studio to create visualizations and build dashboards.
Name:Final Project
Description:Congratulations! You have now completed the modules for this course. In this module, you will complete the final assignment that will be graded by your peers. In the first part of the final assignment, you will use provided sample data to create some visualizations using Excel for the web. In the second part of the final assignment, you will create some visualizations and add them to a dashboard using Cognos Analytics or Google Looker Studio.
This course covers some of the first steps in the development of data visualizations using spreadsheets and dashboards. Begin the process of telling a story with your data by creating the many types of charts that are available in spreadsheets like Excel. Explore the different tools of a spreadsheet, such as the important pivot function and the ability to create dashboards and learn how each one has its own unique property to transform your data. Continue to gain valuable experience by becoming familiar with the popular analytics tool - IBM Cognos Analytics - to create interactive dashboards. By completing this course, you will have a basic understanding of using spreadsheets as a data visualization tool. You will gain the ability to effectively create data visualizations, such as charts or graphs, and will begin to see how they play a key role in communicating your data analysis findings. All of this can be accomplished by learning the basics of data analysis with Excel and IBM Cognos Analytics, without having to write any code. By the end of this course you will be able to describe common dashboarding tools used by a data analyst, design and create a dashboard in a cloud platform, and begin to elevate your confidence level in creating intermediate level data visualizations. Throughout this course you will encounter numerous hands-on labs and a final project. With each lab, gain hands-on experience with creating basic and advanced charts, then continue through the course and begin creating dashboards with spreadsheets and IBM Cognos Analytics. You will then end this course by creating a set of data visualizations with IBM Cognos Analytics and creating an interactive dashboard that can be shared with peers, professional communities or prospective employers. This course does not require any prior data analysis, or computer science experience. All you need to get started is basic computer literacy, high school level math, access to a modern web browser such as Chrome or Firefox, the ability to create a Microsoft account to access Excel for the Web, and a basic understanding of Excel spreadsheets.
