Hi there! I’m Angie Ficek and I’m a program evaluator at a small evaluation consulting firm called Professional Data Analysts, Inc. (PDA) in Minneapolis, MN. In a previous post, Stephanie wrote about adding standard deviations to a dataviz. I responded to her post with an example of…
Blog
What the Hell is Wrong with the Projector & How to Fix It
Meet a hero. This is Kailen Brooks. A few months ago, I was giving a workshop on data visualization to about 40 people at the AEA Summer Institute when pretty much everything that could have gone wrong almost did. Someone’s spilled drink ran dangerously close to my computer.
Adding a Benchmark Line to a Graph
This simple line packs so much power. Adding a benchmark line to a graph gives loads of context for the viewer. Here’s how to make one right inside Excel. It’s so easy you might pass out. My data table looks like this: I have my data and I have the benchmark…
Embracing Data Visualization in Evaluation: A Management Perspective
Friends! I’m so happy to have Rakesh Mohan guest blogging for me. He is one helluva guy. He is the Director of the Office of Performance Evaluations, an independent agency of the Idaho State Legislature. In other words, his eval clients are lawmakers. You ask me for examples of reporting in…
An Incomplete List of Females in Data Visualization
I rewrote this post 4 times, in an effort to give it a calm and professional tone. And then I thought “Ah fuck it, this is my blog and I can say whatever I want.” I’m writing this post because I just listened to an interview about data visualization. It…
How to Make Horizontal Dumbbell Dot Plots in Excel
In case it wasn’t clear, I freakin love dot plots. They are amazingly easy to read, beautifully simple in their display. I was making these babies for some clients a little while ago, before and after dots for about 25 variables in one graph.
Labels are Used Sparingly
This post is about how to avoid inducing claustrophobia in your data visualizations. Too much text on a graph clutters it up, making readers feel suffocated. So let’s address the checklist item Labels are used sparingly. Sometimes, too much text isn’t the issue. Take…
How to Rock the Text in your Data Visualization
You only get a little bit of text in your graph. Here’s how to make sure you get the most mileage out of it.
Choosing a Color Picking Tool
Giant Wes Anderson fan writing you here. So I loved loved loved it when I saw this Wes Anderson Color Palette blog. It’s like several of my happy worlds colliding into rainbows and unicorns. The blogger pulls color palettes from scenes in various Wes Anderson movies. This screenshot is…
Easy Bullet Charts in Excel
Here is what a normal bullet chart looks like: There are usually areas of performance in the background (acceptable/unacceptable, in this case), a target line, and an actual bar the represents your real value. Bullet charts kick ass for showing part-to-whole relationships for single data points,…