Can Your Dataviz Have an Influence on School Reopening Plans?

Our organizations collect all this data—through surveys, assessments, interviews, and so on—and then what? The default: The data just sits there inside a Dusty Shelf Report. But what if your data could actually inform real-life decisions? I recently sat down with Vivian Jefferson from Loudoun County Public Schools, a growing district in the Washington, D.C. metro area who shared that her graphs had been featured on the news (!!!).
More »

Visualizing Your Annual Survey Results: Four Makeovers That Didn’t Work, and the Fifth That Did

Virtually every organization conducts satisfaction surveys of one kind or another. I’m going to show you the before version followed by five makeovers. The first makeover didn’t work. The second makeover didn’t work. The third makeover didn’t work. The fourth makeover didn’t work. Just as I was about to give up, I found a winning design with my fifth attempt!
More »

How to Visualize Workshop Evaluation Results

I give dozens of workshops, webinars, and conference keynotes each year. Which means I receive dozens of evaluation surveys each year. After my sessions, the clients who sponsored the workshop ask their participants to rate my session and often times a software program automatically compiles the results. I’m grateful for this automated reporting technology. But, at the same time, survey scanning tools drive me crazy.
More »

How to Visualize Pre/Post Survey Results in Microsoft Excel

May 9th, 2017 / Data Visualization, Reports
Does your organization collect data through online surveys or paper surveys? Do you need an easy, effective way to visualize survey results in Microsoft Excel? Surveys are one of the most common ways to collect information. In this blog post, we’ll depict how participants’ knowledge changed after participating in an educational program at a museum. Bonus: You can even download the Microsoft Excel spreadsheet and the Microsoft Word document that I used to create these data visualization makeovers.
More »