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-on-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)
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 (6:31)
Ensure Legibility for People with Color Vision Deficiencies (9:07)
Ensure Legibility for Grayscale Printing (& How to Test Your Graphs for Grayscale Legibility with Free Tools)
Ensure Foreground/Background Contrast (& How to Test Drafts for Contrast with Free Tools)
Color-Code Strategically
Examples of Binary, Sequential, Diverging, Categorical, and Highlight Color-Coding
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
Font Inspiration When You Don't Have a Style Guide
How to Tell Which Font It Is with Free Tools
Serif vs. Sans Serif
State the Story in the Title
Add Subtitles to Documents
Annotate
Left, Right, Centered, and Justified Alignment
Establish a Text Hierarchy
Horizontal, Vertical, and Diagonal Labels
Title Case, Sentence Case, and ALL CAPS
How to Objectively Measure Text Readability
How to Lower Your Document's Reading Level
Place Text Beside Graphs
Your Turn
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)
Sheila B. Robinson on Engaging Audiences with Graphs
Create and Clean (5:45)
Enhance and Embellish
Story and Substance
Advanced Excel Vizardry
Waffles
Diverging Stacked Bar Charts
Small Multiples Bars
Population Pyramids
Dot Plots
Line Charts
Slope Charts
Small Multiples Line Charts
Deven Wisner on Getting Started with Tableau
Exploring License Types & Downloading Tableau
Tableau Compatible Data Sources
Connecting Tableau to Your Data Source
Data Formatting in Tableau
Understanding Joins in Tableau
When and How to Use a Union in Tableau
From Sheets to Dashboards and Stories
Sharing Your Tableau Workbook
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)
David G. Keyes on Getting Started with R
What is R?
Why Use R?
How to Get R and RStudio Set Up
Data Viz in R: Overview of ggplot and the Grammar of Graphics
Best Practices for Data Viz in R: Themes
Best Practices for Data Viz in R: Using Facets to Make Small Multiples
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)
Echo Rivera on Effective Presentation Design
Download the Handout
When Does Slide Design Matter?
Your #1 Enemy to Delivering Effective Presentations
How Default Templates Set You Up to Fail
What to Do Instead of Using a Template: Core Information Design Principles to Use Instead
A Slide Makeover Example
Handout Answer Key
Jon Schwabish on Better Tables
10 Rules of Better Tables
Table Remakes
Elissa Schloesser on Creating a Beautiful Report Cover
Getting Started: Why Cover Design is Important
Choosing Your Title: Pick Something That Is Meaningful
Selecting Your Image(s)
Page Layout Design Advice: Hierarchy and Visual Interest
Choosing Fonts and Color: Set the Tone for the Report Design Inside
Pulling It All Together
Amy Cesal on Visualizing with an Unconventional Medium
Examples
Process
Takeaways
Kylie Hutchinson on Effective Reporting
One-Size Reports Aren't Always Effective
Layering
Identifying Key Messages
Making Key Messages Sticky
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
Designing Dashboards
What is a Dashboard? The Official Definition
Dashboard Types and their Tools
A Single Static Dashboard
A Series of Matching Dashboards
Interactive Dashboards
Next Steps
Next Steps
Recommended Resources
Get in Touch
Selecting Your Image(s)
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock