Draw Insights with Crosstabs Reports in Google Sheets

4.5
24 个评分
提供方
Coursera Project Network
在此指导 项目中,您将:

Understand the benefits of using pivot tables to create crosstabs reports and access Google Sheets.

Create a pivot table and visually organize the data with communication in mind.

Understand how statistics can support communicating the data story in crosstabs reports.

Clock2 hours
Intermediate中级
Cloud无需下载
Video分屏视频
Comment Dots英语(English)
Laptop仅限桌面

Crosstabs reports present select slices of data in a matrix format making it easier to visualize patterns and explore similarities and differences between categories or variables. In this course, we’ll explore the pivot-table tactics applied in Google Sheets to create crosstabs reports, conduct a preliminary—exploratory—analysis of the data within the report, and learn how visually presenting data in a crosstabs report can aid the user in their discovery of insights that tell the data’s story. By the end of this course, you will be able to apply pivot table tactics to create crosstabs reports and share data in your business’s domain. 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.

您要培养的技能

Data AnalysisVisual AnalyticsCommunicating about DataBusiness IntelligenceExploratory Data Analysis

分步进行学习

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

  1. Access Google Sheets

  2. Import data into Google Sheets

  3. Begin Exploratory Data Analysis and design report

  4. Create pivot table and visually organize the data into a crosstabs report

  5. Format the crosstabs report

  6. Add evidence to support the data's story

指导项目工作原理

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

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

审阅

来自DRAW INSIGHTS WITH CROSSTABS REPORTS IN GOOGLE SHEETS的热门评论

查看所有评论

常见问题

常见问题

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