Join Bill Shander for an in-depth discussion in this video Working with the data: calculating the rank variances, part of Designing a Data Visualization.
- So now we have these numbers…that are the numbers I really wanted.…The difference between each country's ranking…for the different components…compared to its overall ranking.…And what we can do is to take…a quick look at the data,…and get a sense of what that all means,…is use Excel's conditional formatting,…which is kind of a neat thing.…And by the way,…we're doing some things in Excel here,…I'm going over it relatively quickly.…There a lots of other great courses here on lynda…to learn about how to use Excel,…so feel free to refer to those courses.…You can learn a lot.…
What we're gonna do here is,…I'm gonna select just these cells…for these rank differences,…and, quick way to do that by the way…is if I just click into the cell,…Command Shift or Control Shift on PC,…and then right arrow,…will automatically select all those cells…that are touching each other…and not go past the space…that has nothing in it after that.…And then, same thing, I can just…Command Shift down arrow,…and it'll select all of them.…So now all three of these columns are selected.…
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