Ann's Blog Evaluation, Data Analysis, & Dataviz

How to Present Data When You’re Presenting: Storyboarding Your Data Visualizations in Videos, Webinars, Presentations, and More

How to Present Data When You’re Presenting: Storyboarding Your Data Visualizations in Videos, Webinars, Presentations, and More

I remember the exact moment when I discovered–and got addicted to–data visualization. I was an internal evaluator at a 300-person human services organization. Being an internal evaluator means your “clients” are your coworkers who work down the hall from you. You talk to each other about…

Continue reading →

=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 →

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