Run a Sparkline Trend Analysis in Google Sheets

4.8
12 个评分
提供方
Coursera Project Network
在此免费的指导 项目中,您将:

Understand sparkline charts and how visualizing data with these small charts can aid an analysis.

Understand how the SPARKLINE function allows creation of small charts within a spreadsheet.

Visualize and understand how to conduct exploratory data analysis (EDA) with line, bar, column, and win/loss sparkline charts.

在面试中展现此实践经验

Clock2 hours
Beginner面向初学者
Cloud无需下载
Video分屏视频
Comment Dots英语(English)
Laptop仅限桌面

We have all experienced a moment, when taking in complex information, where understanding crystalizes when a visualization is included to help convey the data story. Sometimes this is an artfully created graphic and other times it is a simple bar chart that helps us suddenly grasp the meaning of a data set. Sparklines are simple, tiny charts that offer a quick visualization of a data set within a worksheet cell. Sparklines are an important tool in an analyst’s toolbox to visually analyze data while conducting an exploratory analysis to uncover possible patterns and quickly grasp trends in a data set. By the end of this course you will understand use cases for inserting sparklines into a spreadsheet and you will be able to confidently create line, bar, column, and win/loss sparkline charts in any spreadsheet software. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

必备条件

Some familiarity with spreadsheet software is helpful, but not required.

您要培养的技能

Handling Large Data SetsData AnalysisData Visualization (DataViz)Communicating about DataBusiness Intelligence

分步进行学习

在与您的工作区一起在分屏中播放的视频中,您的授课教师将指导您完成每个步骤:

  1. Review sparkline charts and how they communicate data within a spreadsheet.

  2. Identify use cases for sparkline trend analysis.

  3. Access and import data into Google Sheets.

  4. Conduct exploratory data analysis (EDA) and create line and bar sparkline charts.

  5. Conduct EDA and create column and win/loss sparkline charts.

指导项目工作原理

您的工作空间就是浏览器中的云桌面,无需下载

在分屏视频中,您的授课教师会为您提供分步指导

常见问题

常见问题

还有其他问题吗?请访问 学生帮助中心