Difference between revisions of "1718t1is428T15"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Line 34: Line 34:
 
==<div style="margin-top: 10px;font-family: Helvetica; text-align: left;font-size:20px; border: 5px solid #00000000; border-radius:5px; text-align:center; background-color: #708090; color: white; padding: 2px"><span style="font-size:24px;">D</span>ataset</div>==
 
==<div style="margin-top: 10px;font-family: Helvetica; text-align: left;font-size:20px; border: 5px solid #00000000; border-radius:5px; text-align:center; background-color: #708090; color: white; padding: 2px"><span style="font-size:24px;">D</span>ataset</div>==
  
The analysis will be based on EMA dataset:
+
=== Data Source ===
 +
The analysis will be based on [https://www.ema.gov.sg/Statistics.aspx EMA dataset]:
 
* Public housing's average monthly household electricity consumption (kwh) (2013 - 2015)
 
* Public housing's average monthly household electricity consumption (kwh) (2013 - 2015)
 
* Private apartment's average monthly household electricity consumption (kwh) (2013 - 2015)
 
* Private apartment's average monthly household electricity consumption (kwh) (2013 - 2015)
  
 +
=== Data Attributes ===
 +
Public Housing
 +
* Postal code
 +
* 1-room
 +
* 2-room
 +
* 3-room
 +
* 4-room
 +
* 5-room/executive
 +
 +
Private Apartment
 +
* Postal code
 +
* Jan
 +
* Feb
 +
* Mar
 +
* Apr
 +
* May
 +
* Jun
 +
* Jul
 +
* Aug
 +
* Sep
 +
* Oct
 +
* Nov
 +
* Dec
  
 
<!-- END DATASET-->
 
<!-- END DATASET-->
Line 51: Line 75:
 
==<div style="margin-top: 10px;font-family: Helvetica; text-align: left;font-size:20px; border: 5px solid #00000000; border-radius:5px; text-align:center; background-color: #708090; color: white; padding: 2px"><span style="font-size:24px;">I</span>nspirations</div>==
 
==<div style="margin-top: 10px;font-family: Helvetica; text-align: left;font-size:20px; border: 5px solid #00000000; border-radius:5px; text-align:center; background-color: #708090; color: white; padding: 2px"><span style="font-size:24px;">I</span>nspirations</div>==
 
[[File:Hexbin inspiration.PNG ||center]]<br />
 
[[File:Hexbin inspiration.PNG ||center]]<br />
The number of public and private address points in Singapore is exceptionally large at about twenty thousands records. While this may pale in comparison to data sets that amount to tens of millions of records in size, the real challenge lies in plotting these points over a geographical region as small as Singapore. The limitation in land space coupled with the immense number of data points would result in many overlapping and cluttering of address points, making data aggregation and visualizing energy consumption extremely difficult and ineffective.
 
 
  
 
EMA publishes energy statistics on an annual basis to provide readers with a comprehensive understanding of the Singapore energy landscape through a detailed coverage of various energy-related topics. As project Enerlyst focuses on analysing households' energy consumption, only private and public households data will be used. This study will be based on EMA dataset from 2013 to 2015.  2013 data will be prepared manually whereas 2014 and 2015 data will be uploaded to the application and process on the fly.
 
EMA publishes energy statistics on an annual basis to provide readers with a comprehensive understanding of the Singapore energy landscape through a detailed coverage of various energy-related topics. As project Enerlyst focuses on analysing households' energy consumption, only private and public households data will be used. This study will be based on EMA dataset from 2013 to 2015.  2013 data will be prepared manually whereas 2014 and 2015 data will be uploaded to the application and process on the fly.
Line 78: Line 100:
 
! Week No(s). !! Task !! Status
 
! Week No(s). !! Task !! Status
 
|-
 
|-
| 3 || Form team || Completed
+
| 7 || Prepares Project Proposal || Completed
|-
 
| 4-5 || Discuss and choose a project topic || Completed
 
|-
 
| 6-9 || Research chosen project topic and data collection || Completed
 
|-
 
| 10-11 || Create project repository and web application planning ||Completed
 
|-
 
| 12 || Create project wiki || Completed
 
|-
 
| 11-15 || Develop application || Completed
 
|-
 
| 14-15 || Research report || Completed
 
 
|-
 
|-
| 16 || Finalize application || Completed
+
| 8 || Attend D3.js workshop, research on technology/tools and project wiki || Completed
 
|-
 
|-
| 16 || Finalize Poster and Research Paper || Completed
+
| 9 || Clean data, start visualisation || Incomplete
 
|-
 
|-
| 16 || Prepare for Townhall Presentation || Completed
+
| 10-11 || Continue with visualisation || Incomplete
 
|-
 
|-
| 16 || Townhall Poster Presentation || Completed
+
| 12 || Prepare poster, final report and wiki page || Incomplete
 
|-
 
|-
| 16 || Final Project Submission || Completed
+
| 13 || Poster submission and final deliverables || Incomplete
 
|}
 
|}
 
</div>
 
</div>

Revision as of 21:15, 12 October 2017

OnTheFlyLogo.png


PROJECT PROPOSAL

PROJECT POSTER

PROJECT APPLICATION

RESEARCH PAPER


Project Motivation

Experts have warned that power demand is set to double by 2030 globally despite authoritative control. High power consumption can already be observed locally. According Energy Market Authority (EMA), Singapore has faced increasing power consumption from 1965 to 2013 [1].

1718t1is428T15-Motivation.png

As Singapore is land-scarce and does not have significant renewable energy options such as hydro-power, wave, or sufficient land for mass solar energy production, energy has been a top concern in the urban nation[2]. It is thus important to promote energy saving concepts to the public as well as deploying energy saving solution island wide. However, the usual analysis tools are not enough to provide a different perspective to facilitate the deployment of the solution. Information about the energy consumption levels of residents in Singapore are often not conveyed adequately enough in data visualisation. While EMA and Singstat provide annual data and reports on energy usage in Singapore, a powerful visualisation technique should be used to gain insights effectively.


Project Objective

Our team aims to create a visualisation that leverages on energy datasets provided by EMA to perform spatial analysis to identify energy usage clusters with hexagonal binning.


Dataset

Data Source

The analysis will be based on EMA dataset:

  • Public housing's average monthly household electricity consumption (kwh) (2013 - 2015)
  • Private apartment's average monthly household electricity consumption (kwh) (2013 - 2015)

Data Attributes

Public Housing

  • Postal code
  • 1-room
  • 2-room
  • 3-room
  • 4-room
  • 5-room/executive

Private Apartment

  • Postal code
  • Jan
  • Feb
  • Mar
  • Apr
  • May
  • Jun
  • Jul
  • Aug
  • Sep
  • Oct
  • Nov
  • Dec


Related Works

Inspirations

Hexbin inspiration.PNG


EMA publishes energy statistics on an annual basis to provide readers with a comprehensive understanding of the Singapore energy landscape through a detailed coverage of various energy-related topics. As project Enerlyst focuses on analysing households' energy consumption, only private and public households data will be used. This study will be based on EMA dataset from 2013 to 2015. 2013 data will be prepared manually whereas 2014 and 2015 data will be uploaded to the application and process on the fly.


Proposed Storyboard

Technical Challenges

Timeline

Week No(s). Task Status
7 Prepares Project Proposal Completed
8 Attend D3.js workshop, research on technology/tools and project wiki Completed
9 Clean data, start visualisation Incomplete
10-11 Continue with visualisation Incomplete
12 Prepare poster, final report and wiki page Incomplete
13 Poster submission and final deliverables Incomplete


Technologies/Tools

Reference


Comments