How to Make a Heat Table in Microsoft Excel

Apr 14th, 2015 / Data Visualization
Just because I adore graphs doesn’t mean that I shun tables. I insert the occasional table inside the body of my report. When creating traditional tables, I follow the Dark Horse Analytics guide. When I’m presenting tables in a presentation, webinar, or full-color report, I create heat tables. Today I’m covering how to make a heat table in Microsoft Excel.
More »

How Data Visualization Supports Decision Making

Sep 10th, 2014 / Data Visualization
The only thing I love more than analyzing research data is analyzing personal finance data. Not too long ago, a friend was trying to decide whether to continue renting his current apartment or to purchase a similarly-sized condominium. I couldn’t make the decision for him, but I could help him crunch the numbers.
More »

Introducing the Data Visualization Checklist

May 14th, 2014 / Data Visualization
This post has been a long time coming. Stephanie Evergreen and I knew some time ago that evaluators and social scientists had a thirst for better graphs, a clear understanding of why better graphs were necessary, but they lacked efficient guidance on how, exactly, to make a graph better. So we’re happy to introduce the data visualization checklist.
More »

The Data Visualization Design Process: A Step-by-Step Guide for Beginners

May 1st, 2014 / Data Visualization
Visualizing numbers in charts, graphs, dashboards, and infographics is one of the most powerful strategies for getting your numbers out of your spreadsheets and into real-world conversations. But it can be overwhelming to get started with data visualization. In this step-by-step data visualization guide for beginners, I’ll walk you through the data visualization design process so that you can transform your spreadsheets into stories.
More »