HeaderSIS.jpg

Difference between revisions of "IS480 Team wiki: 2010T2 B.I. JOE"

From IS480
Jump to navigation Jump to search
Line 255: Line 255:
 
'''<font color="#606060">Data Visualization</font>'''
 
'''<font color="#606060">Data Visualization</font>'''
 
* <font color="#606060">TreeMap</font>
 
* <font color="#606060">TreeMap</font>
* <font color="#606060">Scatter Plot</font>
+
* <font color="#606060">Scatter Chart</font>
 +
* <font color="#606060">Bar Chart</font>
 +
* <font color="#606060">Line Chart</font>
 +
* <font color="#606060">Column Chart</font>
 +
* <font color="#606060">Area Chart</font>
 
</font>
 
</font>
 
|-
 
|-

Revision as of 17:42, 12 February 2011

FYP Logo.png




Team B.I.JOE in collaboration with Integrated Distribution Services

Members

Picture Name Year Personality Portfolios Contact
BIJOE-Smiley.jpg Tan Ying Da Year 3 Visionary Shoot videos and pictures Tan Ying Da
BIJOE-Smiley.jpg Ng Wei Quan Year 3 Directionary Gym Master Ng Wei Quan
BIJOE-Smiley.jpg Marcus Yap Year 4 Roller Roll Master Marcus Yap
BIJOE-Smiley.jpg Isaac Lim Year 3 Gaming Game Master Isaac Lim
BIJOE-Smiley.jpg Sim Sing Hong Year 3 Exchanging Exchange Master Sim Sing Hong


Role Allocation

Prior coming together as a team, everyone has little or some working relation with one another. However, the team knows what is installed for them during this FYP. As such, we have decided to adopt the best fit model approach for role allocation in the team.

Using the best fit model, the team evaluated every individual on their strengths and limitations. With an open-minded environment and culture, everyone in the team shared their experiences and challenges. At the end of the sharing, the team sat together and evaluate how everyone can leverage on each other's strengths and compliment each other's shortcomings.


Roles & Responsibilities

Name Role Responsibility
Tan Ying Da Project Manager Liaison, Tester, Schedule tracking, Assistant Programmer for Secondary Panel
Ng Wei Quan Assistant Project Manager Administrative duties; minutes, Update Wikipedia, Risk mitigation, Lead Programmer for Secondary Panel
Marcus Yap Interface Designer Front-end design: user interface and graphics; Interface Designer
Isaac Lim Application Developer Lead Programmer for Primary Panel, Debug and Code Integration
Sim Sing Hong Application Developer Back-end design: Database Engineer, Debugger, Assistant Programmer for Primary Panel


FYP Supervisor

Zhu Feida, Assistant Professor of Information Systems

Project Overview

Project Title: Geospatial Dashboard for Integrated Distribution Services Analytics

Stakeholders

Stakeholder Name Designation Involvement
Sponsor Dr. Kam Tin Seong Practice Associate Professor, School of Information Systems Provide the team with project specifications. Participate in Usability Assessment and provide feedbacks.
Client Nicholas Tan Director IT Application, IDS Group Malaysia Provide data and share the current business IT system with the team.
Client Paul Fowler CIO, IDS Group Ensure that the project operates under IDS company guidelines.
End Users IDS Group Employees Merchanising and Distribution Services Departments Participate in UAT and provide feedback for functionalities.
End Users Business Principals of IDS Business Partners of IDS Group Provide feedback for functionalities.
Supervisor Zhu Feida Assistant Professor of Information Systems, SMU Advise the team on project, direct the team along course guidelines.


IDS Background

IDS Logo.jpg



The IDS Group is a leading integrated distribution and logistics services provider specializing in Value-Chain Logistics. Headquartered in Hong Kong, the IDS Group has an extensive logistics and distribution network in Greater China, ASEAN, the US and UK offering customized services to over 400 customers, including an array of multinational brands.

IDS offers a comprehensive Menu of Services ranging across the entire value chain from the conversion of raw material into finished goods in Manufacturing, through the international and in-country storage and movement of goods in Logistics, to the marketing and selling of goods to the end consumer in Distribution.

Logistics is the fundamental enabler that connects the Menu of Services to an end-to-end value chain. Our extensive and deep Asian logistics network and our US and UK logistics presence provide the platform on which to layer each of our Menu of Services along the value chain. We call this unique proposition Value-Chain Logistics.


Current Situation

Storyboard 01.jpg Storyboard 02.jpg Storyboard 03.jpg

Storyboard 04.jpg Storyboard 05.jpg Storyboard 06.jpg


Objectives

To create a GeoSpatial Dashboard for IDS employees to extract information and make analysis through better visual representation of data.

Dashboard is a tool that allows data to be represented in a meaningful format and helps user in decision-making.
Key features of a dashboard are

Track Key Performance Indicators (KPI)
Use the Dashboard in-memory database and scheduler to track the movement of your KPIs over time.

Monitor KPI’s Performance throughout your organisation
Push and track targets to every level in the organisation.

Drill down through charts to underlying detail.
Apply drill paths to your charts allowing you to drill down into the underlying detail. Quickly discover the root cause of trends.

Map Visualization.
Using Geospatial technology, it allows user to have an overview of the various channels location on the map.

View in any web browser.
View data in any browser: Firefox, IE, Chrome, Opera etc. No client software is required, Dashboard runs in Adobe Flash Player.

Deploy the Dashboard server anywhere.
The Dashboard server can be easily deployed on Windows server.

Project Scope

The system is a visualization tool that provides multi-dimensional and multi-granularity views of the data based on an interactive and dynamic location visualization support.

There are 4 aspects where the system aims to fulfill.

1. Geospatial 2. Visualization 3. Customization 4. Interactivity



The entire system can be summarizes into three different modules:


1. Geospatial Module

This module provides navigation functions and map visualization for the user to view and navigate the map.

Aspect Component
Geospatial

Map Visualization

  • Marker
    • Info bubble – show characteristic of the outlet with outlet image attached. Also allow user to upload image of outlet if it is wrong or unavailable.
    • Highlighting – marker will be highlighted when filter is being executed or hovering over the data visualization.

Visualization nil
Customization

Dynamic Map ScaleImplement map scale that changes according to the zoom level.

Map Provider Selectionallows user to select their preferable map provider as well as reduce reliance on one map provider.

Icon Manager

  • Filter outlet – checkbox for user to shortlist the outlet they would like to see.
  • Icon selection – allows user to select the customized icon to represent particular outlet.
  • Upload customized icon – upload new customized icon.

Interactivity Navigation
  • Tool pad – Allows user to move up, down, left, right of the map.
  • Zoom Slider – Allows user to zoom in and out of particular region.
  • Home – Bring user back to default navigation settings.

Dynamic Map ScaleImplement map scale that changes according to the zoom level.


2. Data Module

Aspect Component
Geospatial nil
Visualization

Data Visualization

  • TreeMap
  • Scatter Chart
  • Bar Chart
  • Line Chart
  • Column Chart
  • Area Chart

Customization

Time Series Recordto see data changes over time both on the data visualization and map visualization.

Snap shot – allow users to print geographic image to be shown in report.

Interactivity nil

This module provides views for data both in data visualization way as well as map visualization way.



  • Configuration – allow users to manipulate visualization options.


3. Geospatial/Data Link Module

Aspect Component
Geospatial nil
Visualization nil
Customization nil
Interactivity

Focus Marker – when data is being selected at the data visualization, it will focus and zoom on the marker.

This module allows interactivity between Geospatial and Data module. Whenever user made a selection on a module, the other module will compliment the other module in other form of visualization.

  • Search by attributes – search data point according to categories, location or Key Performance Indicator (Refer to Project Scope)
  • Spatial search – perform search within x meter of the area on the given spot to find out if the promotion is effective around the area.
  • View Data – view whole data set in table form.



Project Management

Project Metrics

Bug Metric

Bug Metric v2.png

Schedule Metric


Project Schedule


FYP Schedule 30.12.10 v4 image v1.gif


Current Project Status

  • Phase 2



Progress Summary

Phase 1

  • Completed map layout
  • Data retrieval
  • Screen layout
  • Primary visualisation
  • Secondary visualisation
  • Usability assessment


Phase 2

  • Completed overall layout (Map, Treemap, other visualisations)
  • Search by KPI & Categories
  • Finalised Treemap algorithm
  • Created groups and nodes
  • Researching new API (Juicekit)


Phase 3

  • Treemap Visualisation
  • Linked view of Treemap with Map components
  • Data Viewer with built-in Bullet Chart


Team Calendar and Important Dates

Team Calendar


Important Dates

  • Start 16 May 10 & 3 Oct 10 (3 months before)
  • Proposal 16 Jun 10 (29 teams) & 3 Nov 10 (2 months before)
  • Acceptance 9 Aug 10 (26 accepted) & 27 Dec 10 (1 week before)
  • Registration 16 Aug 10 & 3 Jan 11 (1st day of class)
  • Midterm 27 Sep 10 & 14 Feb 11 (week 7)
  • Poster 8 Nov 10 & 28 Mar 11 (week 13)
  • Final presentation 22-28 Nov 10 & 11-17 Apr 11 (week 15)
  • Finals 28 Nov 10 & 17 Apr 11



Project Documentation

Project Proposal

Proposal


Design Considerations

Sequence Diagram

Click on the images for details


Search Function
Sequence-diag-1.jpg

Map Provider Function
Sequence-diag-2.jpg


Treemap


How to understand and read a treemap

Treemap-example-1.jpg
Example: National Visualization and Analytics Center: Illuminating the Path: The Research and Development Agenda for Visual Analytics p.90

There are three things you need to know to understand how to read a treemap:

1. Treemaps show hierarchical data.
Treemaps are often used to show hierarchical data in which each "parent" can have many "children" but each "child" only has one "parent". A good example of this type of data is the biological classification of species, which starts with Kingdom at the highest level, followed by Phylum, Class, Order, Family, Genus, and finally Species. Most treemaps have fewer layers, like the SmartMoney Map of the Market which classifies publicly traded companies into industries, resulting in just two levels (i.e. industry, company).

2. Treemaps show two measures simultaneously using the size and color of boxes.
Size of the boxes represent a quantity measure where the individual box sizes must sum up to the category in which they exist. Think of a series of pie charts wherein all the slices of each pie chart must add up to the whole, precluding the use of growth rates or dates or any other data that doesn't aggregate.

Color in a treemap is used to show a range of values distinct from the size measure. Color is better suited to a measure of performance or change such as growth over time, average conversion rate, or customer satisfaction. Not only does color give an indication of a measure for an individual item in the treemap, the collective heatmap effect conveys a broader understanding the full data set.

3. Treemaps use interactive features for exploration.
Showing all the data at once in a treemap would overwhelm users and undermine the value of the visualization. To reveal data gradually as the user expresses interest, most treemaps offer interactive features including: 1) selectors to let the user decide what the size and color should represent; 2) zooming to allow the user to drill-in to layers, simultaneously narrowing the scope the data and revealing deeper layers; 3) detailed data about an individual branch or leaf presented as a tooltip or area outside the treemap; 4) highlighting of specified items based on a user search or selection.

Given their ability to show a comprehensive view of a system in an structured fashion, treemaps can be very instructive. The easiest thing to pick out are the items that are both big (by size of the box) and bad (by color intensity). For example, if you have a treemap of financial costs for your organization, the big, red colored boxes are going to be the costs that are worth your attention and changing significantly.

abstracted from http://www.juicekit.org/demos/treemap4flex/


Current Project Challenges (Updated Weekly)

as of 10/02/2011


Inconsistent Data Format

Client is co-operative and kind enough to provide us with operations data ranging from day-to-day to monthly transactions. This valuable data gives us an in-depth information and idea of the company’s operations. From the data, we are able to gather insights and identify what are some of the problems the company is facing.

However, the greatest challenge to our team is the inconsistent data provided by the various departments of the company. Every individual department has its own set of data and data dictionary. Together with the vast amount of data, cleaning up and massaging of data requires some time.


Converting of Data Language

IDS is based in Hong Kong. As such, most of the end-users are Chinese native. Parts of the data are being input using Chinese characters. As such, when using such data, we would have to ensure the conversion of the data from .xls format into .dbf, data is not being lost in the midst of it.


Treemap API

Treemap visualization is one of the key data visualization models in our project. Having to synchronize the treemap visualization with live data is one of the key challenge is our project.

There are several APIs that are open-source in the market. Each of them has their pros and cons and currently, we are evaluating and exploring each option.


Dynamic filter for Treemap


Transform Application into mobile platform



Team Reflection and Learning Outcomes

As of 26/12/2010

  • Identify key benefits of utilising visual analytics in a company.
  • Identify if a specific requirement is a functional or non-functional requirement.
  • Design and implement a spatial enabled business intelligence application prototype using real-life scenarios.
  • Identify key project implementation risks and propose possible solutions to minimise any risks identified.
  • Monitor project implementation schedule using a Gantt chart (MS Project).
  • Applied search for case studies, sample applications and coding examples from social media such as blogs, user forums.
  • The ability to handle spatially-enabled business data.
  • Understand the end users’ technical requirements.
  • Using development software such as Flex Builder to design RIA-based visual analytics application.
  • Have a better understanding on Flex 4, Flash Builder 4, PHP, Action-script 3 and Database.


Project Supervisor Meeting Minutes

Supervisor Meeting 01

Project Sponsor Meeting Minutes

Sponsor Meeting 01

Sponsor Meeting 02