Blog

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

Kenya Goes Digital With the 2019 Population and Housing Census!

Posted by: Gitahi Ng'ang'a on

“It is my sincere hope that all Kenyans will appreciate the key role that statistics play in our everyday life.” – Henry Rotich, Cabinet Secretary, The National Treasury and Planning The Kenya National Bureau of Statistics (KNBS) is preparing to conduct the country’s 8th population census in August 2019. A census, by definition, is the…
Read more