Analytics And Intelligent Systems

NUS ISS AIS Practice Group

Dashboard – 5 Questions — October 30, 2016

Dashboard – 5 Questions

Our chosen dashboard for the “5 Questions” assignment came from the Sales domain. It showed a rich and progressively granular view of a company’s sales performance in the US. We summarized the key questions that this dashboard can answer, as detailed below.

Additionally, we also highlighted two areas where the dashboard can be made more effective. The detailed report on this can be accessed Continue reading

Geo-spatial Visualization and Analytics —

Geo-spatial Visualization and Analytics

We selected Olympic 2016 as our Geo-spatial Analytics and Visualization topic because of its truly global nature encompassing all countries and also since it was a live event during the course of the assignment making our journey an evolutionary one.

We gathered data from multiple sources on the current and last (2012 London) Olympic. To put country performances in perspective and to assess impact of different socio-economic indicators on medals standing, we collected data on several economic and lifestyle indicators from ~10 different online sources. Additionally, we used Twitter data for a global sentiment analysis on Olympic, 2016. Continue reading

Dashboard for Corrupt Practices Investigation Bureau (CPIB) —

Dashboard for Corrupt Practices Investigation Bureau (CPIB)

To create a comprehensive and actionable dashboard, we start by analyzing CPIB as an entity, their mission, vision and different functions. These help us categorize and prioritize different types of relevant information, in line with CPIB’s focus and goals. Following points summarize our key insights and motivations behind creation of the final dashboard.

CPIB Vision: A Leading Anti-Corruption Agency that upholds Integrity and Good Governance towards Achieving a Corruption-free Nation

How can we measure Integrity?
Continue reading

Predicting Daily Bicycle Demand for Capital Bikeshare —

Predicting Daily Bicycle Demand for Capital Bikeshare

Executive Summary

Our business problem is to predict total bicycle demand for the next day using different Day, Weather and past Demand information.  While Day information for the next day is known beforehand, Weather information is known only up to the current day.  Furthermore, past demand information is available only till the previous day since total demand for current day is not known before day end.  Additionally, our business goal revolves around profit maximization where loss due to over or under prediction is asymmetric ($2 for each unit of over-prediction vs. $1 for under-prediction).

We use a combination of ARIMA based time series forecasting, along with five different single model approaches. These methods are Continue reading

Dashboard for National Climate Change Secretariat —

Dashboard for National Climate Change Secretariat

National Climate Change Secretariat
            -Creating a climate resilient global city that is well positioned for green growth

How can we measure global climate change?

  • ›The Climate Change Performance Index is an instrument designed to enhance transparency in international climate politics.
  • ›Aim: To put political and social pressure on those countries which have failed to take ambitious action on climate protection.

How is the ranking done based on CCPI Index?

  • ›The CCPI ranking is qualified in relative terms rather than absolute terms.
  • ›Countries with high rankings have no reason to sit back and relax.
  • ›Even if all countries were as involved as the front runners, efforts would not yet be sufficient to prevent dangerous climate change.
  • ›Hence, no country was awarded the rank of 1st, 2nd or 3rd.

Singapore – Quick Facts

  • ›Rank – 56
  • ›Performance – Very Poor
  • ›Share of GDP – 0.42%
  • ›Share of Population – 0.08%
  • ›Share of Global Carbon di-oxide Emissions – 0.14%
  • ›Share of Global Primary Energy Supply – 0.19%

What is the primary cause behind climate change?


  • ›Climate change is a product of greenhouse gases such as carbon dioxide.
  • ›It is  released from the burning of fossil fuels.
  • ›Leads to Green-House Effect.
  • ›Increased concentrations of greenhouse gases with fossil fuels becomes too much of a good thing, leading to warming the planet up.

Are there any major calamities because of such a global issue?


  • ›A rise in the overall average temperature per year leads to rise in sea level.
  • ›With tropical climate and heavy rainfall, Singapore is prone to floods.
  • ›Major devastation causing floods were observed in the mid 20th century.
  • ›2008 onwards, preventive measures and mitigation strategies were implemented to prevent loss of life and property.

How well can we mitigate in times of stress?

›Flood control Measures Implemented:

  • ›Flood Canals made
  • ›Drainage made efficient in new housing areas
  • ›Marina Barrage

Is there an alternative to reduce such a threat?

  • ›Energy-related CO2 emissions showed an increase in 2011. However, there are signs of a slowdown in the growth of emissions.
  • ›Renewable energies are growing rapidly. In 2014, approximately 59% of capacity additions to global electricity generation were additions of renewable energy capacity.

How well the alternative resources have performed?

  • ›Use of Solar Energy has brought down carbon emissions, and thus in turn brought down overall rise in temperature.
  • ›Installed capacity became approximately 5 times more in 2015 as compared to 2013.
  • ›Renewable Energy Resources are the key to stabilize global temperatures and thus prevent ozone layer depletion.


  1. ›!/vizhome/CombinedDashboardsver3_3/Main
  2. ›
  3. ›
  4. ›
  5. ›

Link to view the Dashboard –

View the Dashboard on Tableau Public



Submitted By:

  1. Abdulhannan Patel – A0148494R
  2. Gurkiran Kaur – A0148595M
  3. Harish Kusumanchi – A0150353R
  4. Valluru Chandana Reddy – A0148547U
Dashboard for National Research Fondation — October 28, 2016
Geovisualisation – Heatmap — October 18, 2016

Geovisualisation – Heatmap

There are different ways and methods for mapping geospatial, statistics and temporal data.


For data visualisation of locational data, various techniques can be implemented, such as dot plot map, bubble plot map, Isarithmic map, particle flow map, Cartogram, Dorling Cartogram, network connection map, and others.


One of the most useful map display is using Heatmap (Choropleth map), which is always used to visualise the concentration of occurrences (represent Point of Interest).