1718t1is428T3

From Visual Analytics for Business Intelligence
Revision as of 01:11, 16 October 2017 by Kangli.low.2014 (talk | contribs)
Jump to navigation Jump to search
Logo.jpg

Proposal

 

Project Presentation

 

Project Application

 

Research Paper

 

Poster


Project Introduction and Motivation

With the continually rising prices of car prices in Singapore and the increasing polarisation of incomes in the country, our group is curious as to discover what have been the changes in the market demand for cars. Going deeper into the market, we will also show how the tastes for car brands have waxed and waned over the years. Demand for cars like Datsun and Supra have disappeared off the roads, while Fords and Audis have taken their places. Are Singaporeans starting to prefer more American and German cars than before? From this visualisation, car manufacturers are able to clearly segment the car market in Singapore and target the right group of buyers.

Target Audience

We aim to deliver a highly interactive web application that allows someone to easily navigate between a large amount of time-series data and geographical data.

Our intended audience is:

  1. Car dealers to make better forecast for car stock
  2. Prospective car buyers
  3. Potential Car Suppliers wanting to enter the Singapore vehicle market
Objectives

In this project, we will be focusing on the following:

  • To discover the trend of registered cars and the COE for different brands across time
  • To help consumers discover current and future COE trends for different cars categories (A & B)
  • Trends in Singapore car market by brand (geography, market segmentation)
Dataset

For this visualisation we need a few datasets.

  1. CIEC - List of car brands and the no. of registered vehicles (TBC)

(Awaiting confirmation by Prof. Kam)


Background Survey of Related Works
Related Works What We Can Learn

An interactive treemap indicating importers of different countries

Pic1.jpg

Source: http://atlas.media.mit.edu/en/profile/hs92/8708/

  • Uses D3.js
  • Colour indicates different continents, eg. Asia, Europe, North America etc.
  • Size indicates proportion of sales in the market
  • Hovering over the area indicates more details
  • Provides a high level view of our data and displaying the item details at the same time. It allows us to see patterns quickly when our eyes visually aggregate rectangles in the same group.

An analysis of the trend of coe in a bar chart representation

Pic2.jpg

Source: http://coe.sgcharts.com/

  • Use line graph to compare the changes of COE prices over the years.

Sunburst Diagram to visualize hierarchies in car sales

Pic3.PNG

Source: https://accessanalytic.com.au/the-top-3-new-charts-in-excel-2016/

  • Provides an overview of the breakdown of data in categories.
  • Colour can be used to highlight hierarchical groupings or specific categories.


Proposal of StoryBoard

Our Group has decided on the below storyboard in order to make it clear for users to have an overview of the geographical, car brand, prices across time.

Storyboard.PNG

Sunburst Diagram
This type of visualisation shows hierarchy through a series of rings, that are sliced for each category node. Each ring corresponds to a level in the hierarchy, with the central circle representing the root node and the hierarchy moving outwards from it. Colour can be used to highlight hierarchal groupings or specific categories. We believe that a sunburst diagram would be effective as we would be able to visualise the number of cars breaking down from region to country to car brand. We would be using chart since it is easy to implement and interactive. These are some variations of the sunburst that we are considering too.

Sunburst.jpg Sunburst2.jpg


Radial Stackbar chart
We may want to effectively compare the prices. As there would be many elements, a radial stackbar chart will allow the prices to be presented in a single view and not across the screen. We are considering adding transition from sunburst to radial stackbar chart.

Radial.PNG

Tree Map
Treemaps are used to display hierarchical data. Treemaps are economical in that they can be used within a limited space and yet display a large number of items simultaneously. We chose to use tree map, because it would give an overview of the number of cars registered by brand.

Treemap.PNG

Technical Challenges
Technical Challenges Mitigation Plan
Obtaining datasets
  1. Go through databases provided by the library
  2. Enlist help from Professor Kam for CIEC access to data
Acquiring Data, Data Cleaning
  1. Plan the cleaning process and work closely to clean and analyse all data sources
Using d3.js and Highchart to display the visualisations which we want
  1. Attend D3 Programming Workshop
  2. Designated time and roles on learning on D3 and HighCharts Libraries & Technical Tools
  3. Peer Learning
Unfamiliarity in Implementing Interactivity and Animation Tools/Techniques in Visualization App
  1. Develop a Storyboard
  2. Different specialisation on Interactivity/Animation Techniques
  3. Referred to existing data visualisations for implementation
Project Timeline

Tasks Duration Resource Status
1. Iteration 1
1.1 Brain Storm of Topics Week 6-7 All Completed
1.2 Decide and search for availability of data Week 8 All Completed
1.3 Change to a new topic & Data Gathering/Cleaning Week 9 All In Progress
2. Iteration 2
2.1 Designing of Prototype & Technical Learning Week 10 All In Progress
2.2 Technical Learning Week 11 All In Progress
2.3 Designing of Poster & Visualization Application Development Week 12 By brand: Cheryl, By region: Sarah, By country: Kang Li In Progress
3. Iteration 3
3.1 Visualization Application Development & Intergation Week 13 All In Progress
3.2 Research Paper + Final Amendments Week 14 All In Progress
Technologies and Tools

Our team has decided to focus on these few tools and libraries in order to showcase our product.

  • D3.js
  • HighChart.js
  • Tableau
  • Notepad++
  • Adobe PhotoShop
References
  • What influences COE prices?

https://www.gov.sg/factually/content/what-influences-coe-prices

Comments

Please share with us your feedback! :)