Three Things You Can do to Make Your Data Tables More Visual

Link: https://policyviz.com/2021/03/02/three-things-you-can-do-to-make-your-data-tables-more-visual/

Graphic:

Excerpt:

One last option is to add sparklines. Sparklines are small line charts that are typically used in data-rich tables, often at the end of a row or column. The purpose of sparklines is not necessarily to help the reader find specific values but instead to show general patterns and trends. Here, the sparklines show all five years of data, which allows us to omit three columns of numbers, lightening and simplifying the table. This approach lets us show the full time series in the sparklines while just showing the two endpoints in the table cells.

Author(s): Jon Schwabish

Publication Date: 2 March 2021

Publication Site: PolicyViz

Analyzing Census Data in Excel

Link: https://www.census.gov/data/academy/courses/excel.html

Description

Excel is a very popular tool among all data users. It can be leveraged to unlock the value of open data of all kinds, and it is particularly well-suited to transforming, analyzing, and visualizing Census data. This course will show how to use Excel to access, manipulate, and visualize Census data.  It will also tools for doing advanced statistical analysis.

After completing this course, you will be able to:
    ✓    Access data from the Census Bureau using the American FactFinder
    ✓    Format tables for data analysis
    ✓    Perform basic and advanced analysis of Census data using Excel
    ✓    Create data visualizations such as sparklines, hierarchical charts, and histograms

Author(s): Andy Hecktman, Alexandra Barker

Date Accessed: 27 February 2021

Publication Site: U.S. Census Bureau