SAP Technology Innovation Platform team won the 2nd place in the Clean & Green hackathon in Singapore!
The event (taking place from 26 to 27 April 2013) is the first ever hackathon organized by National Environment Agency of Singapore. It is also the first hackathon with a theme of safe guarding environment, conserving energy, and changing people’s behavior for sustainable development in Singapore. Two other SAP colleagues — Naveen and Daniel — and I, together with two PhD candidates from local universities (Peng Shuai from NTU and Yong Sheng from NUS) formed a team HANAVis and participated in the event.
While the most of the other 20 participating teams focused on mobile application or website development, we tried to leverage our strength on data analysis and visualization using HANA. Our interest went to the largest data datasets provided in the hackathon — the log files of two popular apps (Weatherlah and Trafficlah) in Singapore. The logs contain weather and traffic data in Singapore for around one and a half year, and are 6GB and 1GB in size, respectively. Without using HANA, other teams were not even able to open the file. We imported the data to HANA and data processing became as simple as working with excel spreadsheets.
We were able to create hourly plots for traffic intensity and incidents, to draw real-time heat maps of vehicle density, and correlate weather and traffic to predict traffic jams with rain forecast before the congestion starts to form up. We also proposed to design an app which promotes public transportation during raining weather to reduce traffic on the road. To be honest, it feels great to have several “wow” moments during a three minute pitch.
The guest of honor, Minister for the Environment and Water Resources of Singapore, Dr. Vivian Balakrishnan also joined us for a discussion after the event. He shared with us his belief in using data analysis to make Singapore a greener city, and showed his great interest in HANA. We were the runner up team, but HANA is surely the biggest star.
This has been a great experience for me and my fellow team mates. For Peng Shuai and Yong Sheng, the speed and power of HANA had blown their mind. We learnt, hacked, made friends, and had fun. What can you ask for more (possibly free beers ;>)?