Blog

Musings about capacity building, program evaluation, and data visualization.

Visualizing Data Projections in Excel

Visualizing Data Projections in Excel

Recently, a colleague asked me how to visualize projections in Excel. The pressure was on, and they needed to wow their boss with their skills. The hardest part of a projection graph is, well, the actual projections. If you already have that data, like this group did, then making an informative graph is simple with just a few tweaks to the Excel default.

read more
Opportunities & Outcomes Mapping: Moving from Confusion to Clarity

Opportunities & Outcomes Mapping: Moving from Confusion to Clarity

Years of working with nonprofits, community coalitions, foundations, and state agencies has taught me one thing: data is messy! But that doesn’t mean that data has to be confusing. Opportunities and outcomes mapping offers a 3-step process to help organizations reconnect with your vision and values. This process will transform your team to move from data to insight to action so you can do your good work even better.

read more
Shifting into Solopreneurship: Wearing the Hat of Business Owner

Shifting into Solopreneurship: Wearing the Hat of Business Owner

In my evaluation work, I wear many hats, often balancing multiple roles each day: consultant, coach, collaborator, writer, designer, advocate. Right now the hat I am most proud of is solopreneur. In 2021, I took the leap to move to full-time solopreneurship and run my own business. This is something I had been dreaming about and planning for years. So in true evaluator fashion, I spoke to colleagues – both new and experienced – during the planning process to hear about their work in the field.

read more
Shifting Data Visualization Feedback From Criticism to Curiosity

Shifting Data Visualization Feedback From Criticism to Curiosity

Years ago, when I first learned about data visualization, I went all in. I read books and blogs, listened to podcasts, attended workshops, and poured over the guiding principles. I thought that if I understood the rules, then I could get it “right.”

But focusing on getting things “right” presents challenges. It perpetuates dichotomous thinking and stifles creativity. It often prioritizes Western ways of thinking and leaves out community voice. It raises criticism rather than encouraging conversation.

read more
How To Design Reports that Actually Inform Decisions

How To Design Reports that Actually Inform Decisions

Too often we hide our findings in dense text-based reports. Our clients have to sift through pages upon pages of narrative to find the gems. This is all while they navigate competing demands for their attention and time. Odds are that your report becomes just another thing on their ever growing to-do list. There’s a better way!

read more