Articles
Our latest articles are below, or you can filter by category using this dropdown:
Optimizing Excel Charts by Right Justifying Y-Axis Labels
In this article, we'll show you an easy way to align y-axis labels in Excel charts and Microsoft applications. It's a simple but important step to make sure your data visualizations are clear and accurate.
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.
Data Visualization Best Practices: A Practical Guide for Getting the Most out of your Data Viz
Want visuals that best express your data story? Here are some ideas to clean up those charts and help make them pop.
How to combine data from multiple sources for cleaning and analysis.
This article walks you step-by-step through the process we use when merging datasets from multiple sources.
Chart Templates: The Time Saver You Should Be Using
Chart templates will alleviate the pains of trying to reformat every new chart from scratch. From adjusting text size and font to formatting bar width and colour, a template will save you a significant amount of time in drafting your next evaluation report.
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.
Preventing Mistakes in Survey Data Entry
When entering survey data, it is important that it is accurate, easy to analyze, and fast. Use these tips to prevent mistakes from the beginning.
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.