IS428 2016-17 Term1 Assign1 Chua Feng Ru

From Visual Analytics for Business Intelligence
Revision as of 20:50, 28 August 2016 by Fengru.chua.2013 (talk | contribs) (Added Tools Utilised)
Jump to navigation Jump to search

Abstract

Housing and residential properties have always been a hot topic in Singapore. Even with the cooling measures in place since 2013, the property market has yet to "cool down", and this means that there are opportunities for insights within the data. This project aims to allow students to go through the phases of 1) Data Compilation, 2) Data Cleaning & Transformation and 3) Visual Analysis of Data. The trends and analysis will be presented in an infographical form, where the static visualizations used in the infographics will be created by Tableau software. Lastly, policy recommendations will be recommended based on the trends or analysis.

Problem and Motivation: A description of the problem you have addressed, explaining the why is it relevant, what are the main variables involved, and what development policy questions you intend to address.

Approaches: Describe the approaches used for examining and analyzing the data

Tools Utilized

This section describes the technologies used in the following phases of the project:

1. Data Compilation For this phase, I generally used SAS Enterprise Guide to compile the data (Transactional-data in particular), which comes in a few parts, to a single Comma-Seperated-Value (CSV) file.

2. Data Cleaning & Transformation SAS Enterprise Guide was used to clean and transform the values, such as stock housing units, and in between the data is also being generated in visual form in SAS to allow me to validate if the data.

3. Visual Analysis of Data Tableau is used to create different visuals to allow exploratory data analysis. The visuals that are appropriate are then used to create the infographics. For the creation of infographics, XXX from Mac OS is used, wbich allows the creation of high resolution pictures.


Results: Describe how the results of your work may contribute to improve the use of data for development.