Ann's Blog Evaluation, Data Analysis, & Dataviz

=vlookup(): One Excel function to rule them all

=vlookup(): One Excel function to rule them all

I’m celebrating 100,000 YouTube views with an article on my favorite spreadsheet function: vlookup! Vlookup is for merging and combining datasets, like when you’ve got program participants’ demographic data in one place and their scores or outcomes in another place. I can’t tell you how many…

Continue reading →

Who knew dataviz could be so easy? [Guest post by Stephen Alexander]

Who knew dataviz could be so easy? [Guest post by Stephen Alexander]

For the record, I had no clue that data visualization could be easy. As someone who’d spent two years working to understand and improve an organizational dashboard (not to mention an evaluation process), perhaps I should have known better. My assumption, for whatever reason, was…

Continue reading →

Please: Don’t use default colors in your chart

Please: Don’t use default colors in your chart

I’ve got a lot of dataviz skeletons in my closet. This beauty comes from my second week as an evaluator: Border, grid lines, tick marks…. A legend instead of direct labeling… A generic title instead of a “so what?” title… You get the idea. Today I…

Continue reading →

Avoiding diagonal text in your charts, and other shameful mistakes I made before I knew better

Avoiding diagonal text in your charts, and other shameful mistakes I made before I knew better

I’ve been building portfolios of my work for a while. Over the past year or so I’ve been building an online portfolio of speaking and writing engagements. Before that, I collected paper copies of reports I worked on: Before The great sobering thing about portfolios is that…

Continue reading →

Introducing the Data Visualization Checklist

Introducing the Data Visualization Checklist

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…

Continue reading →

Page 1 of 25 1 2 3 4 5 ... Last →