Dashboard Day 3: Rural demand of electricity in India

by Jamie Bassett

Day 3: Rural Electricity Demand in India

An awful day for me. I spent a long time desperate trying to match the headers from the PDF with the raw data, which was not a success. It was hard as the PDF parse on Alteryx would not take into account the difference between a Question and a sub question (ie, sometimes the questionnaire was 8 different answers to choose from, but Alteryx thought it was 8 different questions).

An example..

The raw contained over 500 different questions, often in survey format (1=Disagree, 2=Neutral, 3=Agree.. etc). This meant I created calculated fields in Tableau to make sense of the data.

With not much time, I decided to focus on the sources of income, thinking agriculture would have a lower percentage of houses without electricity.

I really hope tomorrow is a better day…

Reflections from the Data School

1 mins read

Thu 21 Nov 2019

Dashboard Week Day 4: The non-Tableau day

1 mins read

Thu 24 Oct 2019

Dashboard Week Day 2: House of Commons rules

2 mins read

Tue 22 Oct 2019

Dashboard Week Day 1: Design Census 2019

3 mins read

Mon 21 Oct 2019