Kabak: Proposal

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Kabak.jpg

Problem and Motivation

As a country with no natural resources, the government has always been vested in encouraging Singaporeans to reduce energy consumption and wastage in Singapore. For example, the National Environment Agency (NEA) has the energy label scheme which requires goods such as Air-conditioner, Refrigerator, Clothes Dryer and Television to be affixed with an energy label sticker depicting how much electricity they consume when used.

More recently in August 2016, Singapore Power (SP) has redesigned the utilities bill in a bid to help fellow Singaporeans track and take steps to reduce their energy and water consumption.

While there are data and statistics available on the Energy Market Authority with regards to the energy consumption by household, it is in quite a raw form with no visualization to aid users in better understanding energy consumption in Singapore. The statistics or data provided also does not link to other factors such as the population demographics, which perhaps could provide interesting insights on the usage patterns of Singaporean households. As such. while these data exist, it is not being used to allow the public to visualize the energy consumption and to make sense out of it.

Solution and Objective

Our solution is aimed at helping households to visualize the energy consumption patterns in Singapore in simple, easy to understand components and also to allow them to compare with other similar households(i.e by housing type). It will also suggest simple ways to help households conserve energy by referring to data on energy consumption so that users can enter how much they want to reduce their bill by and appropriate energy saving activities will then be recommended to meet the target set.

At the end of the day, the solution aims to provide insights or trends to users with regards to energy usage patterns so that they can take action to reduce their bill at the end of the month.

Dataset

Dataset Description

Average Monthly Household Electricity Consumption
by Postal Code (Public Housing) & Dwelling Type, 1H & 2H 2015

Link (1H): https://www.ema.gov.sg/cmsmedia/Publications_and_Statistics/Statistics/23RSU.xls

Link (2H): https://www.ema.gov.sg/cmsmedia/Publications_and_Statistics/Statistics/25RSU.xls

  • Average monthly household electricity consumption (kwh)
    • By month
    • By postal code
    • By public housing type
  • Total Average household electricity consumption (kwh)
    • By postal code
    • By public housing type

Average Monthly Household Electricity Consumption by Postal Code (Private Apartments), 2015

Link: https://www.ema.gov.sg/cmsmedia/Publications_and_Statistics/Statistics/2RSU.xls

  • Average monthly household electricity consumption (kwh)
    • By month
    • By postal code
  • Total Average household electricity consumption (kwh)
    • By postal code

Basic Demographics Characteristics (2015)

Link: http://www.singstat.gov.sg/docs/default-source/default-document-library/publications/publications_and_papers/GHS/ghs2015/excel/t7-9.xls

  • Resident Population by Planning Area/Subzone
    • By age group
    • By sex
    • By ethnicity
    • By type of dwelling

Resident Households (2015)

Link: http://www.singstat.gov.sg/docs/default-source/default-document-library/publications/publications_and_papers/GHS/ghs2015/excel/t148-152.xls

  • Resident Households (2015)
    • By household size
    • Monthly household income


Survey of Related Works

Related Works Pros and Cons
Energy consumption.PNG

Source: http://tinyurl.com/kho65tl

  • Time series data displayed in a tabular format with numerical values is hard to digest.
  • The alternating white and blue rows do not have any meaning and does not add value to the visualisation.
Energy static.PNG

Source: http://tinyurl.com/hdux9ou

  • The stacked bars is able to show overall energy consumption for the month and also the consumption for each component.
  • Green hue is used for public housing and yellow hue is used for private housing. This aids the audience in categorisation of what they are seeing.
  • Numbers are added into each bar to help in comparison for bars that look similar in size.
Energy geog.PNG

Source: http://tinyurl.com/jnzvfyg

  • The public tableau dashboard by Energy Market Authority has geographic visualisation.
  • However, it is not able to do comparison across housing types nor estates.
  • The marks on the map also do not vary in colour or size, which does not really add value to having data on a map.


Key Technical Challenges


Storyboard


Timeline and Milestones

Milestones

Kabak milestones.png


Task Allocation

Kabak timeline.png


References