Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
Great Graphs
Welcome!
Important Course Info
Ann's Contact Info
Monthly "Office Hours" Webinars for Silver and Gold Students
One-to-One Consultation for Gold Students
Introduce Yourself to the Group
What Makes a GREAT Graph? (9:37)
Analyze Your Audience
Who's Your Audience? (1:28)
Technical or Non-Technical? (5:12)
How Many Points in Time? (4:13)
How Many Decimal Places? (2:00)
Comparison Data? (1:16)
Are Viewers Expecting a Story? (5:14)
Choose the Right Dissemination Format
Which Format is Best for Each Viewer? (3:40)
The 30:3:1 Approach to Reporting (7:52)
Tool: Communications Crosswalk
Tool: Communications Plan
Choose the Right Chart
Consult a Chart Chooser (3:07)
Explore Your Dataset (2:53)
Sketch Drafts by Hand (8:50)
Explore Your Data with Sparklines
Insert Miniature Line Graphs Called Sparklines (2:32)
Insert Miniature Column Charts Called Column Sparklines (1:56)
Insert Win/Loss Sparklines (2:25)
Adjust the Vertical Y-Axis (6:37)
Add Markers (5:26)
Add New Data and Update the Data Source (4:16)
Adjust the Data Source Even More (Two Advanced Nuances) (2:26)
Remove (Clear) the Spark Lines Altogether (1:55)
Explore Your Data with Data Bars
Insert Miniature Bar Charts Called Data Bars (2:15)
Data Bars are Helpful Down Columns (But Not Across Rows) (4:10)
Adjust the Label Placement (i.e., Don't Place the Number on Top of the Bar) (15:39)
Adjust the Horizontal X-Axis (4:29)
Adjust the Color (7:34)
Adjust the Background Shading (i.e., Create a Stacked Bar Chart) (4:11)
Change Your Mind? Remove the Data Bars Altogether
Pies, Donuts, Square Pies, and Waffles
7 Guidelines for Pies & Donuts (7:47)
When Pies and Donuts Are Okay (1:16)
Alternatives to Pies & Donuts (4:47)
Square Pies, Waffles, & Icon Arrays (5:49)
Pie Chart Makeovers
From a 7-Slice 3D Pie to Bars with Icons (4:40)
From Unlabeled Pie Charts to a Comprehensive Dashboard (12:58)
From Four Different Pies to Stacked Columns (8:08)
Your Turn: Workforce Diversity
Your Turn: Mine Operator Employees
Bar Charts
Bar Chart Nuances: Scaling, Shading, Collapsing, Diverging, and Small Multiples (10:28)
There's Nothing More Boring Than a Report Full of Bar Charts... Area, Square Area, & Tree Maps (5:59)
How to Declutter Your Cluttered Stacked Bars (8:26)
Choose the Right Chart, continued
Lollipops & Dot Plots (6:35)
Progress Towards Goals (2:38)
Histograms & Population Pyramids (2:47)
Sankey & Chord Diagrams (4:46)
Before/After Comparisons (Clustered, Deviation, Slopes, Dots) (4:31)
Lines & Spaghetti Lines (5:25)
Maps! Geographic, Pin Drop, Tile Grid, Hex, and Cartograms (12:00)
Your Turn: Adding Visuals to an Annual Report
Ideas for Visualizing Qualitative Data
How to NOT Visualize Qualitative Data... (2:51)
3 Scenarios Where It's Okay to Use Word Clouds (9:05)
How to Make Word Clouds (8:56)
Annotate Your Quant Charts with Qual Data (4:53)
Color-Coded Phrases (5:21)
Sample Quotes with Photographs (9:34)
Add One Icon Per Paragraph, Takeaway Finding, or Theme (5:39)
Explain Complicated Processes with Diagrams (6:20)
Your Turn: Share Additional Examples & Resources
Chart Choosing Practice
Yes/No Survey Questions (3:44)
Check All That Apply (5:50)
Rating Scales (4:13)
Open-Ended Survey Comments (3:36)
Demographic Data on Survey Respondents (3:36)
Pre/Post Results (7:01)
Select a Software Program
Which Tools Are Available? (2:52)
Which Tool Do I Need for Which Chart??? (4:01)
Excel
Tableau
R
Power BI
Datawrapper
Write Your Reports in PowerPoint (Instead of Word!) (2:18)
Tell a Story
Tell a Story: Slope Chart Example (9:37)
Tell a Story: Bar Chart Example (3:54)
Declutter
Remove Unnecessary Ink & Apply the Squint Test (2:41)
Remove Borders (1:50)
Add White Outlines (2:05)
Remove 3D (3:02)
Remove Decorative Clip-Art... and Add Icons (3:33)
Four Places to Find Icons (13:01)
Remove Redundant Labels (6:14)
Remove Legends... and Label Directly (6:33)
Makeover 1: Tables (4:37)
Makeover 2: Cluttered X-Axis Dates (5:07)
Makeover 3: Repetition Everrrrywhere! (8:21)
Makeover 4: Redundant Tables & Graphs (9:22)
Your Turn: Declutter this Map!
Your Turn: Declutter *Your* Visualization
Clarify Your Message with Color
Brand Visuals with Custom Colors (2:59)
Find Color Codes in Style Guides (6:13)
Find Color Codes with Eyedroppers (5:40)
Find Color Codes from a Website's Page Source (2:45)
Find Color Codes with MS Paint (3:19)
Enter Color Codes in Excel (6:00)
Save Time! Create Theme Colors in Excel (8:07)
Color Inspiration If You Don't Have a Style Guide (13:38)
Ensure Legibility for People with Color Vision Deficiencies (9:26)
How to Test Your Color Palette & Your Dataviz Drafts for Color Vision Legibility (8:09)
Ensure Legibility for Grayscale Printing (& How to Test Your Graphs for Grayscale Legibility with Free Tools) (7:18)
Ensure Foreground/Background Contrast (& How to Test Drafts for Contrast with Free Tools) (6:53)
Color-Code Strategically (3:17)
Binary (1:53)
Sequential (1:19)
Diverging (4:10)
Categorical (7:56)
Highlights and Warnings (5:39)
Preattentive Attributes (4:37)
Your Turn: Re-Color This Graph! (Easy)
Your Turn: Re-Color This Map! (Advanced)
Your Turn: Re-Color *Your* Visualization
Clarify Your Message with Text
Brand Visuals with Custom Fonts (1:58)
Find Fonts in Style Guides (4:49)
State the Story in the Title (3:11)
Annotate (5:55)
Establish a Text Hierarchy (4:01)
Make Sure Text is Horizontal (3:17)
Use ALL CAPS Sparingly (1:27)
Improve Text Readability (14:12)
Your Turn: Re-Write the Text for *Your* Project
Before/After Data Visualization Makeovers
When Your Reports, Not Your Readers, Are The Problem (1:52)
Reenvisioning a University's Annual Report (12:27)
Workshop Evaluation Results (10:50)
Annual Survey Results (12:26)
Getting Started with Excel
Set Up Your Table and Insert a Brand New Chart (5:37)
Declutter the Chart (7:52)
Add Numeric Labels to a Chart (3:08)
Re-Order the Bars (3:33)
Reduce the Awkward White Space Between the Bars (2:36)
Brand with Custom Fonts (5:03)
Brand with Custom Colors (7:04)
Re-Size the Chart (and Text) (4:39)
Tell a Story with Dark Colors (4:28)
Tell a Story with a Title, Subtitle, and/or Annotation (7:25)
Move the Chart From Excel into Word or PowerPoint (6:15)
Emma Perk and Lyssa Becho on Creating One-Page Reports
What is a One-Page Report? (What is a one-pager and why would you want to create one?) (4:39)
Building the Foundations (Identifying Audience, Purpose, Prioritize Information) (5:29)
Visual Strategies (Choosing a grid, drafting layout, intentional path, hierarchy, white space) (6:11)
Final Touches (Feedback, Triple Check, Wrap-up) (5:48)
Jon Schwabish on Better Tables
Rules of Better Tables & Table Remakes (27:47)
Elissa Schloesser on Creating a Beautiful Report Cover
Getting Started: Why Cover Design is Important (0:52)
Lessons Overview (0:58)
Content (2:54)
Layout (5:17)
Style (6:27)
Pulling It All Together (3:36)
Advanced Excel Vizardry: Waffles
Step 1: Set Up Your Table (2:57)
Step 2: Insert a 100% Stacked Bar Chart (2:13)
Step 3: Declutter (3:53)
Step 4: Re-Size the Graph (5:16)
Step 5: Remove the White Space (0:54)
Step 6: Re-Color the Graph (6:19)
Step 7: Make the Remaining Waffle(s) (11:48)
Advanced Excel Vizardry: Dot Plots
Step 1: Transform Your Original Table into a Magic Table (9:30)
Step 2: Insert a Scatter with Straight Lines and Markers (2:17)
Step 3: Declutter (3:36)
Step 4: Make the Lines Skinnier (1:18)
Step 5: Remove the Zig-Zag Line (1:45)
Step 6: Make the Placeholder Line and Placeholder Dots White (2:28)
Step 7: Remove the Awkward Gray Line Along the Very Top (1:05)
Step 8: Re-Size the Dots (1:44)
Step 9: Re-Color the Dots (1:39)
Step 10: Add Numeric Labels (2:20)
Step 11: Apply Custom Colors and Fonts (1:36)
Step 12: Re-Size the Graph and the Font Sizes (4:37)
Step 13: Finalize the Built-In Legend (3:26)
Step 14: Add Category Labels (4:16)
Bonus! 2 Dots Without a Connecting Line (4:21)
Bonus! 1 Set of Dots (a Lollipop Graph) (4:23)
Bonus! Smaller Dots with Labels Beside Dots (Instead of Labels Inside the Dots) (3:02)
Bonus! Dots with Arrows (8:35)
Deven Wisner on Getting Started with Tableau
Exploring License Types & Downloading Tableau (7:29)
Tableau Compatible Data Sources (2:16)
Connecting Your Data Source to Tableau (1:05)
Data Formatting in Tableau (1:51)
Understanding Joins in Tableau (2:40)
When and How to Use a Union in Tableau (1:49)
From Sheets to Dashboards and Stories (3:31)
Sharing Your Tableau Workbook (3:14)
David G. Keyes on Getting Started with R
Why R? (4:51)
What is R? (5:29)
Working with Data in R (8:10)
ggplot and the Grammar of Graphics (10:30)
Data Viz Tricks (7:54)
Wrapping Up (2:13)
Echo Rivera on Effective Presentation Design
Download the Handout
When Does Slide Design Matter? (13:14)
Your #1 Enemy to Delivering Effective Presentations (7:25)
How Default Templates Set You Up to Fail (16:21)
What to Do Instead of Using a Template: Core Information Design Principles to Use Instead (28:56)
Handout Answer Key
Kylie Hutchinson on Effective Reporting
Is Anyone Reading Your Reports? (5:40)
Layering (5:19)
Identifying Key Messages (4:28)
Reorder Your Key Messages (4:26)
Designing Reports
What Makes a Great Report? (2:27)
Go Beyond the Report (7:07)
Scrollytelling (3:56)
Using Landscape Orientation (5:41)
Start With the "So What?" (1:35)
Visually Chunk Content With Dividers (3:17)
Apply a Text Hierarchy (2:29)
Go Beyond the Bar Chart (1:45)
Tell a Story With Dark Colors and Interpretive Text (1:49)
Add a Cover (4:32)
Designing Dashboards
What Makes a Great Dashboard? (5:13)
What is a Dashboard? The Official Definition (1:14)
Dashboard Types and their Tools (3:27)
A Single Static Dashboard (3:10)
A Series of Matching Dashboards (2:25)
Interactive Dashboards (2:43)
Sheila B. Robinson on Great Photographs
Lesson 1 (9:59)
Lesson 2 (16:33)
Lesson 3 (16:25)
Nick Visscher on Time-Saving PowerPoint & Excel Tips
Embedding Fonts (3:33)
Dynamic Excel Tables to Automatically Update Charts (3:52)
Intentionally Sort Rating Scale Data in Survey DataViz (3:50)
Embedding Non-Data Labels Into Charts (5:41)
Chris Lysy on Doing Even More with Tableau
More Data, Less Confusing (a.k.a., Why Use Tableau)
Lots of Data in a Little Space (Creating Filterable Dot Plots, Scatter Plots, and Line Charts)
Higher Resolution Choropleth Mapping (Creating Useful and Colorful Zip Code Maps)
Readable Tableau (Creating Narrative Tooltips and Action Based Labeling)
Amy Cesal on Visualizing with an Unconventional Medium
Examples
Process
Takeaways
Designing Data Placemats
What is a Data Placemat?
Step 1: Analyze Data & Design Placemats
Step 2: Facilitate an Interpretation Meeting
Step 3: Produce the Final Report or Slideshow
Next Steps
Next Steps
Recommended Resources
Get in Touch
Content
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock