ISSS608 2016-17 T1 Project Team 11 - IdeaLog

From Visual Analytics and Applications
Jump to navigation Jump to search

TeamA lg.png Project A - The Non-Conventional Sales Dashboard for Company A

About

Proposal

Poster

Application

Report

Blog

 


Meeting Minutes

Idea & Research

 


Background Surveying

objective: Identify similar projects, and area(s) where we can learnt from these previous experiences:

  • Note: All the images can be found in the same website link provided.

Previous School Works

Sample & Source Feature Learning Factors

1. Demand Forecasting Application

Sample 1
  1. Neat Layout
  2. Filters are neatly displayed at the left side of the bar
  3. Instruction on how to use is clearly stated

2. Job Analysis

Sample 1
  • Gif File: Click on it if it were not moving
  • Click Here


Sample 1

Positive

  1. Interactivity among the graphs: (1) allow multiple selections of categories (2) Allow multiple selection of Time


Room for Improvement

  1. "Year Quarter reset" - not display neated, look like junk charts. (The no. were not clearly defined)
  2. Radarchart: "For display" only - missing information on how to interpret


Overall Learning Points

  1. Do not have junkcharts, and every chart display need to have a purpose & meaning to it.
  2. Interactivity : Multiple selections can be neatly done and organized as per sample.

3. Comphrensive Dashboard

Sample 3

Positive

  1. Good views of Maps: using an overview of a geographical map, with a focus view of a greographical map
  2. Good practice of analysis: From an "overview", to a detailed analysis (from geographical map, to the details that can be found in the barcharts)
  3. Assumed that all the graphical charts are inter-linked, with interactivity; it makes it easy to analysis using this dashboard


Room for Improvement

  1. Red and yellow are glaring to the eyes (Not user-friendly).

4. Comphrensive Dashboard- Coffee Chain Inc Application

Sample 4

Positive

  1. Similar business context on sales analysis : and how a geographical map can interact with the sales analysis (by other graphic charts)
  2. Minor but significant - "reset" button
  3. Provide use-case for report (to demo on how the dashboard can be interpreted)


Room for Improvement

  1. Any bar charts should have a reference line for comparisons (Will be good if the reference line can be adjusted
  2. It is not "idiot-proof" - reference to the report is required on what each of the graphic chart is about (perhaps too complicated) or the order / arrangement of the charts can be improved.


Learning Points

  1. Do a "limus test" on user-interface, especially for those without any prior business context to it. (If they can accept and interpret it, we are then sure that the bosses should be able to do so too)
  2. Reference Lines are essential/ any form of comparsions - either to the sales target, average performance etc.
  3. Layout of the graphic should follow the throught process of the reader. When required, perhaps; have to hide those graphics (via interactivity) so that the reader can focus on the graph that he/she is interpreting. (Quite impossible to be analyzing 6 graphics at the same time!)

5. Sunburst Diagram

Sample 5
  1. Simple and neat layout with sunburst diagram as the graphic to display the main results
  2. Interaction across element, and allow highlighting of bars (Timeline bar) to filter the data

6. Geographical Diagram

Sample 5
  1. Good example on how to improve the
  2. Interaction across element, and allow highlighting of bars (Timeline bar) to filter the data, such that
  • Display of the data on the map
  • Upon a click, it will display the location in depth
  • A tooltip will provide more details to the location, then
  • A price trend/ graph is displayed to show the price of the selected zoom

From the World Wide Web

Sample :

  1. Sales Dashboard with geographical analysis : https://www.pinterest.com/pin/372250725423557371/
  2. Geographical Dashboard on Sales : http://qonnections.geoqlik.com/geoqlik/proxy/qvajaxzfc/opendoc.htm?document=1%20-%20Sales%20Management_11.8.qvw&host=QVS%40aslw0026&anonymous=true
  3. Sales Dashboard 2: http://techknomatic.com/portfolio-posts/sales-dashboard/
  4. Qlikmap's feature : http://www.qlikmaps.com/#
  5. geographical map on distribution : https://interactive.twitter.com/premierleague/#?mode=team&teamId=all&country=TGO

From Company A

(Data has been masked, only the wireframe remains)

Sample from Company A

Strength:

  1. Clear indicators on KPI based on different aspect of the business

Weakness

  1. No benchmarking of performance with target and external opportunities
  2. Many tables are used instead graphics.
  3. Layout is not clean

Technical Challenges

Database Hosting

Data Preparation

Crazy Ideas

District Number mapping:

  1. District Number of Singapore : https://www.ura.gov.sg/realEstateIIWeb/resources/misc/list_of_postal_districts.htm
  2. District Number (by geographical Map) : http://www.propertyhub.com.sg/singapore-district-guide.html

Reference