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
Skill Level Intermediate
Creating Infographics with Illustratorwith Mordy Golding4h 16m Intermediate
1. Getting to the Idea
2. Getting to the Visual Approach
Sketching and wireframing8m 22s
3. Roughing Out the Design Elements
4. Bringing the Visuals to Life
Next steps2m 21s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.