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

From IS480
Jump to navigation Jump to search
Line 179: Line 179:
===<div style="background: #b6c5ff; padding: 12px; font-weight: bold"><font color="black" size="4">Project Schedule</font></div>===
Detailed project schedule of our team can be found at the link below.
[http://dl.dropbox.com/u/1303923/FYP/ProjectSchedule_v2.xlsx Latest Project Schedule]
===<div style="background: #b6c5ff; padding: 12px; font-weight: bold"><font color="black" size="4">Current Project Status</font></div>===
===<div style="background: #b6c5ff; padding: 12px; font-weight: bold"><font color="black" size="4">Current Project Status</font></div>===

Revision as of 22:04, 26 February 2011

FYP Logo.png
FYP Title.jpg

Team B.I.JOE

in collaboration with Integrated Distribution Services




Role Responsibilities


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.

Project Overview

Project Title: Geospatial Dashboard for Integrated Distribution Services Analytics



IDS Background


Current AS-IS Model


TO-BE Model




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 Visualization

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.

Data Visualization -

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

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

Aspect Component
Geospatial -

Data Visualization

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

Users will be able to select different type of charts to best represent their data of interest and also view and filter unstructured quantitative data that are organized in hierarchies.

View Data – view whole data set in table form.


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.

Configuration – allow users to manipulate visualization options.

Interactivity -

3. Geospatial/Data Link Module

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.

Aspect Component
Geospatial -
Visualization -

Search by attributes – search data point according to categories, location or Key Performance Indicator.

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.


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

Project Technical Specifications


Project Management

Use Case




Project Metrics

Bug Tracking

Schedule Tracking

Current Project Status

  • Iteration 6

Progress Schedule






Team Calendar

Team Calendar

Project Documentation

Project Proposal


Project Resources

FYP Resources.png
  • Development Environment: Flash Builder 4, Notepad++
  • Test Environment: Firefox, Chrome with Flash Player
  • SDK & Language: FLEX 3.5 (AS3), PHP
  • Libraries & APIs: Modest Map, Flare, Juicekit for Visual Analytics
  • Deployment: XAMPP
  • Database: PostgreSQL, PostGis
  • Project Management: MS Office, Google Cal, Google Docs, Dropbox, Subclipse
  • Graphics: Photoshop

Useful Resources

  • How to understand and read a treemap. [1]

Challenges Faced

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

Translate application into mobile platform

Creating interactivity in drag & drop graphs from scratch

Team Reflections and Learning Outcomes

  • 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


S/N Date Detailed Minutes Download Follow Up Actions from Meeting
1. 22 December 2010 Supervisor Meeting 01 * Re-arrange project acceptance presentation
* Improve on the technical specifications


S/N Date Detailed Minutes Download Follow Up Actions from Meeting
1. 13 January 2011 Supervisor Meeting 02 * Upload all documentations on Wiki page
* Firm up project specifications with the client
* Do a video recording of the video conference with IDS Hong Kong
2. 21 January 2011 Supervisor Meeting 03 * Follow up with the suggestions made by Supervisor


S/N Date Detailed Minutes Download Follow Up Actions from Meeting
1. 11 February 2011 Supervisor Meeting 04 * Send a copy of Mid Term Presentation slides to Supervisor by 14 Feb

Project Sponsor Meeting Minutes


S/N Date Detailed Minutes Download Follow Up Actions from Meeting
1. 23 December 2010 Client Meeting 01 * Amend project requirement and schedule


S/N Date Detailed Minutes Download Follow Up Actions from Meeting
1. 5 January 2011 Client Meeting 02 * Client will send the necessary data and data structure to the team
* Schedule a video conference with IDS stakeholders
2. 12 January 2011 Client Meeting 03 * Client will be following up with the requests from the team
3. 19 January 2011 Client Meeting 04 * Include improvements and suggestions provided by Client
4. 26 January 2011 Client Meeting 05 * Schedule an internal meeting to re-discuss on the feedbacks provided by the Client and how the team can work on the inputs


S/N Date Detailed Minutes Download Follow Up Actions from Meeting
1. 2 February 2011 Client Meeting 06 * Prepare video conference presentation schedule and deliverables
* Request for additional data to bring up database
2. 7 February 2011 Client Meeting 07 * Hold an internal meeting within the team to follow up with the requests from IDS Hong Kong
3. 9 February 2011 Client Meeting 08 * Decide to decline the request of changing the development application to be iPhone and iPad ready
4. 14 February 2011 Client Meeting 09 * Improvements must be reflected before mid term presentations

Design Considerations

Design Consideration