Difference between revisions of "Kabak: Proposal"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
 
(21 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
[[File:kabak.jpg|center|150px]]
 
 
<!--Sub Header Start-->
 
<!--Sub Header Start-->
 
{| style="background-color:white; color:white padding: 5px 0 0 0;" width="100%" height=50px cellspacing="0" cellpadding="0" valign="top" border="0" |
 
{| style="background-color:white; color:white padding: 5px 0 0 0;" width="100%" height=50px cellspacing="0" cellpadding="0" valign="top" border="0" |
  
−
| style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: bold; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #000000; border-top:1px solid #000000; font-family:helvetica"> [[Kabak | <b>Home</b>]]
+
| style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: bold; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #000000; border-top:1px solid #000000; font-family:Trebuchet MS; background-color:#FFFFFF;"> [[Kabak | <font color="#35383c"><b>HOME</b>]]
  
−
| style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: bold; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #000000; border-top:1px solid #000000; font-family:helvetica"> [[Kabak: Proposal | <b>Proposal</b>]]
+
| style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: bold; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #000000; border-top:1px solid #000000; font-family:Trebuchet MS; background-color:#35383c;"> [[Kabak: Proposal | <font color="#FFFFFF"><b>PROPOSAL</b>]]
  
−
| style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: bold; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #000000; border-top:1px solid #000000; font-family:helvetica"> [[Kabak: Poster | <b>Poster</b>]]
+
| style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: bold; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #000000; border-top:1px solid #000000; font-family:Trebuchet MS"> [[Kabak: Poster | <font color="#35383c"><b>POSTER</b>]]
  
−
| style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: bold; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #000000; border-top:1px solid #000000; font-family:helvetica"> [[Kabak: Application | <b>Application</b>]]
+
| style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: bold; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #000000; border-top:1px solid #000000; font-family:Trebuchet MS"> [[Kabak: Application | <font color="#35383c"><b>APPLICATION</b>]]
  
−
| style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: bold; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #000000; border-top:1px solid #000000; font-family:helvetica"> [[Kabak: Research Paper | <b>Research Paper</b>]]
+
| style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: bold; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #000000; border-top:1px solid #000000; font-family:Trebuchet MS"> [[Kabak: Report | <font color="#35383c"><b>REPORT</b>]]
 +
 
 +
| style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: bold; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #000000; border-top:1px solid #000000; font-family:Trebuchet MS"> [[Project_Groups | <font color="#35383c"><b>OTHER PROJECT GROUPS</b>]]
 
|}
 
|}
 +
 
<!--Sub Header End-->
 
<!--Sub Header End-->
 
<br/>
 
<br/>
Line 20: Line 22:
 
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.
 
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 some visualization and basic interactivity 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.  
+
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 some visualization and basic interactivity 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. <br/>
  
 
=Solution and Objective=
 
=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.
 
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.
+
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. <br/>
 +
 
 +
=Dataset=
 +
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 +
|-
 +
! style="font-weight: bold;background: #35383c;color:#FFFFFF;width: 50%;font-family:Trebuchet MS" | DATASET
 +
! style="font-weight: bold;background: #35383c;color:#FFFFFF;font-family:Trebuchet MS" | DESCRIPTION
 +
|-
 +
|
 +
<p>Average Monthly Household Electricity Consumption <br> by Postal Code (Public Housing) & Dwelling Type, 1H & 2H 2015</p>
 +
<p>'''Link (1H)''': https://www.ema.gov.sg/cmsmedia/Publications_and_Statistics/Statistics/23RSU.xls </p>
 +
<p>'''Link (2H)''': https://www.ema.gov.sg/cmsmedia/Publications_and_Statistics/Statistics/25RSU.xls </p>
 +
||
 +
* 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
 +
|-
 +
|
 +
<p>Average Monthly Household Electricity Consumption by Postal Code (Private Apartments), 2015</p>
 +
<p>'''Link''': https://www.ema.gov.sg/cmsmedia/Publications_and_Statistics/Statistics/2RSU.xls  </p>
 +
||
 +
* Average monthly household electricity consumption (kwh)
 +
**By month
 +
**By postal code
 +
* Total Average household electricity consumption (kwh)
 +
**By postal code
 +
|-
 +
|
 +
<p>Basic Demographics Characteristics (2015)</p>
 +
<p>'''Link''': http://www.singstat.gov.sg/docs/default-source/default-document-library/publications/publications_and_papers/GHS/ghs2015/excel/t7-9.xls  </p>
 +
||
 +
* Resident Population by Planning Area/Subzone
 +
**By age group
 +
**By sex
 +
**By ethnicity
 +
**By type of dwelling
 +
|-
 +
|
 +
<p>Resident Households (2015)</p>
 +
<p>'''Link''': http://www.singstat.gov.sg/docs/default-source/default-document-library/publications/publications_and_papers/GHS/ghs2015/excel/t148-152.xls</p>
 +
||
 +
* Resident Households (2015)
 +
** By household size
 +
** Monthly household income
 +
|}
 +
<br/>
 +
 
 +
=Survey of Related Works=
 +
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 +
|-
 +
! style="font-weight: bold;background: #35383c;color:#FFFFFF;width: 50%;font-family:Trebuchet MS" | RELATED WORKS
 +
! style="font-weight: bold;background: #35383c;color:#FFFFFF;font-family:Trebuchet MS" | PROS AND CONS
 +
|-
 +
|
 +
[[File:energy_consumption.PNG|400px|center]]
 +
<p><center>'''Source''': http://tinyurl.com/kho65tl</center></p>
 +
||
 +
* 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.
 +
|-
 +
|
 +
[[File:energy_static.PNG|400px|center]]
 +
<p><center> '''Source''': http://tinyurl.com/hdux9ou </center> </p>
 +
||
 +
* 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.
 +
|-
 +
|
 +
[[File:energy_geog.PNG|400px|center]]
 +
<p><center> '''Source''': http://tinyurl.com/jnzvfyg </center></p>
 +
||
 +
* 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.
 +
|}
 +
<br/>
 +
 
 +
=Key Technical Challenges=
 +
[[File:kabak_techchallenge.png|800px|center]]
 +
<br/>
 +
 
 +
=Storyboard=
 +
[[File:kabak_storyboard.jpg|800px|center]]
 +
<br/>
 +
 
 +
=Timeline and Milestones=
 +
=== Milestones ===
 +
[[File:kabak_milestones.png|1000px|center]]
 +
<br/>
 +
=== Task Allocation ===
 +
[[File:kabak timeline.png|500px|center]]
 +
<br/>
 +
 
 +
=References=
 +
1. http://www.channelnewsasia.com/news/singapore/utilities-bill-redesigned/3002418.html <br/>
 +
2. http://www.e2singapore.gov.sg/Households/Saving_Energy_At_Home/HEA.aspx <br/>
 +
3. https://services.spservices.sg/elect_audit_frameset.asp <br/>
 +
4. https://www.ema.gov.sg/Singapore_Energy_Statistics.aspx <br/>
 +
5. http://www.singaporepower.com.sg/irj/servlet/prt/portal/prtroot/docs/guid/6024ae5b-746a-2e10-3bbe-c705f591cc8f?spstab=Our%20Services
 +
 
 +
<br/>
  
 
=Comments=
 
=Comments=
−
Feel free to hit us up in this section on how we can improve our project!
+
Your feedback is important to us. Please let us know how we may improve.

Latest revision as of 20:23, 22 November 2016


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 some visualization and basic interactivity 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

Kabak techchallenge.png


Storyboard

Kabak storyboard.jpg


Timeline and Milestones

Milestones

Kabak milestones.png


Task Allocation

Kabak timeline.png


References

1. http://www.channelnewsasia.com/news/singapore/utilities-bill-redesigned/3002418.html
2. http://www.e2singapore.gov.sg/Households/Saving_Energy_At_Home/HEA.aspx
3. https://services.spservices.sg/elect_audit_frameset.asp
4. https://www.ema.gov.sg/Singapore_Energy_Statistics.aspx
5. http://www.singaporepower.com.sg/irj/servlet/prt/portal/prtroot/docs/guid/6024ae5b-746a-2e10-3bbe-c705f591cc8f?spstab=Our%20Services


Comments

Your feedback is important to us. Please let us know how we may improve.

Retrieved from ‘https://wiki.smu.edu.sg/1617t1IS428g1/index.php?title=Kabak:_Proposal&oldid=6842’