Blog

Why Cleaning Your Survey Data is a Waste of Time

Posted by: Gitahi Ng'ang'a on

“Prevention is better than cure.” – Proverb Do you spend days cleaning your survey data at the end of the data collection process? Well, you might want to rethink your approach. Now, don’t get me wrong. There are many datasets for which it makes perfect sense to perform data cleaning. Survey data just isn’t one…
Read more

5 Common Data Visualization Mistakes to Avoid

Posted by: Gitahi Ng'ang'a on

“There is no such thing as information overload. There is only bad design.” – Edward Tufte It feels like data is everywhere these days. And it is. Few reports are complete without some form of data presentation. Eye-catching visualizations can be the difference between a dreary report and one that is both easy and informative…
Read more

Part 3: How to work a pivot table like a pro

Posted by: Gitahi Ng'ang'a on

In Part 2 of this series, we examined a few pivot table configurations and the types of summaries that can be created using them. We also discussed the concept of measures and dimensions. In this installment, we shall run through the actual process of preparing pivot tables. There are many tools for creating pivot tables….
Read more

Part 2: How to work a pivot table like a pro

Posted by: Gitahi Ng'ang'a on

In the first part of this series, we discussed a few data summaries that can be a bit challenging to prepare. In this installment, we shall look at various pivot table configurations and how they can help answer the questions raised earlier more easily.  The first thing to understand about pivot tables is that they…
Read more

Part 1: How to work a pivot table like a pro

Posted by: Gitahi Ng'ang'a on

One of the most common questions we receive on our support channels is how to meaningfully summarize large datasets. Often, people are clear about the end result, they just don’t know how to get there. Many of the desired summaries can be easily achieved using pivot tables. Pivot tables are an incredibly powerful data processing…
Read more