Join Bill Shander for an in-depth discussion in this video Working with the data: trends data, part of Designing a Data Visualization.
- Okay, so now we have our spreadsheet of data…and it's starting to get cleaned up.…Got rid of all the junk down here,…all these extra tables we're not using.…We have our components worksheet…in really good shape, with all the data…we need to work with.…And now we're gonna do something similar…with the Trends tab.…So, just like last time, I'm gonna be deleting…rows and columns that we're not gonna be using.…So I'm gonna delete, first of all,…these extra rows at the top.…Right click, delete, and I'm going to…make sure that all of my columns…that I'm gonna be using are labeled,…so, my first column, I'm just gonna label Rank.…
We have Country.…I'm actually only gonna be using…some of these year columns, so for instance…I'm gonna be using 1980, 1990, 2000,…and 2013, so I'm sort of moving labels down here…so that they're all in the same row.…And the reason that I'm not using some of these…intermediate columns is that we're gonna be…doing these little line charts…just showing the change overtime from 1980 to 2013,…and I'm just gonna put four dots in place,…
The UN Human Development Index used in this course is a perfect example: a composite number used to rank countries on how well they're doing across a range of measures (such as health, wealth, and education). Instructor Bill Shander shows how to make this index data tangible and approachable by imagining the story and visual approach first. He then builds the design in Adobe Illustrator, capitalizing on some automation and scripting abilities the program offers. Start watching for unique insights into the entire data visualization process.
- Working with the data
- Sketching and wireframing your design
- Roughing out the visual design components
- Manually creating the design in Illustrator
- Using Illustrator scripting to improve accuracy, speed, and repeatability
- Designing callout boxes, legends, labels, and more