Blog

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

Why long data eats wide data for lunch

Posted by: Gitahi Ng'ang'a on

Usually, most datasets have one obvious unit of analysis. For example, if you’re collecting data on patients, then the unit of analysis is the patient. Assuming a patient has the variables Name, Sex and Age, a sample dataset with 3 cases might be tabulated as follows. Name Sex Age Alice Female 30 Bob Male 40…
Read more