Data Visualization Applications: Lollipop Charts - An Alternative to Bar Charts

While traditional bar charts are both straightforward and powerful for data representation, there are instances when we seek innovative alternatives to breathe new life into our reports. Enter the lollipop chart. Learn how to develop them in Excel here.

Read More

Common Issues When Entering Survey Data (and How to Solve Them)

Here, I share solutions to two challenges you are likely to come across while entering survey data: 1) coding complex question types and 2) dealing with unclear responses. Addressing these challenges will require some advanced coding that I did not cover in my first article.

Read More

Three Steps for Painless Survey Data Entry

The most exciting part about conducting a survey is seeing the results – finally your hard work has come to fruition, and you get to hear what everybody had to say! But before you can get to that step, you need to transform the stack of paper surveys on your desk into useable data.

In this article, I share my three-step system for making survey data entry as easy and painless as possible, which comes from my experience designing, entering, and analyzing survey data.

Read More