HeaderSIS.jpg

Difference between revisions of "IS480 Team wiki: 2008T3BG1 Phenomena"

From IS480
Jump to navigation Jump to search
 
(42 intermediate revisions by 2 users not shown)
Line 43: Line 43:
  
 
* Develop a role-based dashboard (3 Main Roles: Executive, Manager and Supervisor)
 
* Develop a role-based dashboard (3 Main Roles: Executive, Manager and Supervisor)
 +
 +
* Develop new data model
  
  
Line 49: Line 51:
 
The team comprises of 4 members as follow:
 
The team comprises of 4 members as follow:
  
*Ang Peiqi - Project Manager
+
*Ang Peiqi - Project Manager  
  
 
*Lim Hui Mien - System Analyst
 
*Lim Hui Mien - System Analyst
Line 66: Line 68:
  
 
We are fortunate to have IDS(HK) as our FYP Sponsor. Special thanks goes to Mr. Tim Collins, our sponsor, as well as Mr. Paul Fowler, liaison for IDS. We're also grateful to Ms.Sim Kiat, our Project Manager of Project F1 to oversees the project development, Mr. Tomy Kwong, our Project Governance from Hong Kong and Mr. Nicholas Tan, our Technical Support from Malaysia. Lastly, we also thank Ms. Chan Jain Shin, Technical Support from IDS(Malaysia), for coming down to Singapore to conduct Trigantic Training for our team.
 
We are fortunate to have IDS(HK) as our FYP Sponsor. Special thanks goes to Mr. Tim Collins, our sponsor, as well as Mr. Paul Fowler, liaison for IDS. We're also grateful to Ms.Sim Kiat, our Project Manager of Project F1 to oversees the project development, Mr. Tomy Kwong, our Project Governance from Hong Kong and Mr. Nicholas Tan, our Technical Support from Malaysia. Lastly, we also thank Ms. Chan Jain Shin, Technical Support from IDS(Malaysia), for coming down to Singapore to conduct Trigantic Training for our team.
 
  
 
=== Project Schedule ===
 
=== Project Schedule ===
Line 159: Line 160:
 
* Create Data Dictionary and Data Model according to new requirements - 100%
 
* Create Data Dictionary and Data Model according to new requirements - 100%
  
 +
*Minutes
 +
** Client Minutes
 +
*** ''IDS Minute 8: [[Media:IDS_Minute8.doc]]''
 +
*** ''IDS Minute 9: [[Media:IDS_Minute9.doc]]''
 +
** Supervisor Minutes
 +
*** ''Supervisor Minute 7: [[Media:Supervisor Meeting Minutes 7.doc]]''
 +
** Internal Weekly Minutes
  
  
Line 167: Line 175:
 
* Draft Mid term review - 100%
 
* Draft Mid term review - 100%
  
* Update Development Specification ( Include changes which the user has feedbacked)
+
* Update Development Specification  
 +
**''Include changes which the user has feedback for all dashboard''
  
* Update Project Schedule ( Changing requirements )
+
* Update Project Schedule  
 +
**''Due to user change requirements''
  
* Update Gap and Functional Business Requirement Document( Include changes which the user has feedbacked)
+
* Update Gap and Functional Business Requirement Document
 +
**''Include changes which the user has feedback''
 +
 
 +
*Minutes
 +
** Client Minutes
 +
*** ''IDS Minute 10: [[Media:IDS_Minute10.doc]]''
 +
*** ''IDS Minute 11: [[Media:IDS_Minute11.doc]]''
 +
** Internal Weekly Minutes
  
  
Line 186: Line 203:
  
 
* Development of Promotion Compliance Dashboard - 50%  
 
* Development of Promotion Compliance Dashboard - 50%  
**'''''Problem Faced:''' Delay in schedule to the unforeseen complexity of development''
+
**'''''Problem Faced:''' Complexity of development''
  
 
* Planning for Pricing Check Dashboard - 60%
 
* Planning for Pricing Check Dashboard - 60%
Line 194: Line 211:
  
 
* Start on Unit Test Plan for all reports - 30%
 
* Start on Unit Test Plan for all reports - 30%
 +
 +
*Minutes
 +
** Client Minutes
 +
*** ''IDS Minute 12: [[Media:IDS_Minute12.doc]]''
 +
*** ''IDS Minute 13: [[Media:IDS_Minute13.doc]]''
 +
*** ''IDS Minute 14: [[Media:IDS_Minute14.doc]]''
 +
** Supervisor Minutes
 +
*** ''Supervisor Minute 8: [[Media:Supervisor Meeting Minutes 8.doc]]''
 +
** Internal Weekly Minutes
  
  
Line 219: Line 245:
 
**''Cycle Report Test Plan - 0%''
 
**''Cycle Report Test Plan - 0%''
 
**''Trend Report Test Plan - 0%''
 
**''Trend Report Test Plan - 0%''
 +
 +
*Minutes
 +
** Client Minutes
 +
*** ''IDS Minute 16: [[Media:IDS_Minute16.doc]]''
 +
*** ''IDS Minute 17: [[Media:IDS_Minute17.doc]]''
 +
*** ''IDS Minute 18: [[Media:IDS_Minute18.doc]]''
 +
*** ''IDS Minute 19: [[Media:IDS_Minute19.doc]]''
 +
*** ''IDS Minute 20: [[Media:IDS_Minute20.doc]]''
 +
** Internal Weekly Minutes
  
  
Line 224: Line 259:
  
 
* Finalise Trend Dashboard Development Specification - 100%   
 
* Finalise Trend Dashboard Development Specification - 100%   
**'''''Note:''' Refer to Dashboard Design v21.0'' [[Media:Dashboard_Presentation_v21.pdf]]
+
**'''''Note:''' Refer to [[Media: Dashboard_Presentation_v21.pdf]] ''
  
 
* Development of Promotion Compliance Dashboard - 95%  
 
* Development of Promotion Compliance Dashboard - 95%  
Line 251: Line 286:
 
**''Cycle Report Test Plan - 50%''  
 
**''Cycle Report Test Plan - 50%''  
 
**''Trend Report Test Plan - 50%''
 
**''Trend Report Test Plan - 50%''
 +
 +
*Minutes
 +
** Client Minutes
 +
*** ''IDS Minute 21: [[Media:IDS_Minute21.doc]]''
 +
*** ''IDS Minute 22: [[Media:IDS_Minute22.doc]]''
 +
*** ''IDS Minute 23: [[Media:IDS_Minute23.doc]]''
 +
** Supervisor Minutes
 +
** Internal Weekly Minutes
  
 
=== Week 12 (6 Jul - 12 Jul) ===
 
=== Week 12 (6 Jul - 12 Jul) ===
 +
 +
* Development of Promotion Compliance Dashboard - 100%
 +
 +
* Start Development for Daily Pricing Check Dashboard - 100%
 +
 +
* Start Development for Weekly Pricing Check Dashboard - 100%
 +
 +
* Start Development for Cycle & Trend Dashboard - 100%
 +
 +
* Mapping of data from FDA Database to Trigantic Database - 100%
 +
 +
*Start on Unit Test Plan for all reports - 80%
 +
**''Promotion Compliance Test Plan - Completed''
 +
**''Price Check Test Plan - Completed''
 +
**''Cycle Report Test Plan - Completed''
 +
**''Trend Report Test Plan - 40%''
 +
 +
*Start on User Acceptance Test for all reports -
 +
 +
=== Week 13 (13 Jul - 17 Jul) ===
 +
*Start on User Acceptance Test for all reports - 100%
 +
**''Promotion Compliance Test Plan - Completed''
 +
**''Price Check Test Plan - Completed''
 +
**''Cycle Report Test Plan - Completed''
 +
**''Trend Report Test Plan - Completed''
 +
 +
*Prepare for final report and presentation
 +
*Feedback session with our client
 +
*Presentation at 2pm 14th July Friday at IDS Singapore

Latest revision as of 13:31, 20 July 2009

Project F1

Project Overview

The project goal is to develop an Executive Dashboard for IDS Executives, Managers, Supervisors and Principles (IDS’s Client) to have an immediate picture of the current situation and facilitates efficient decision making for different role. It involves analyzing of business processes and requirements, designing, implementing, extensive unit testing, UAT and user training.

Developing an executive dashboard with enhanced data model that is able to provide actionable information for rapid decision making. A dashboard is able to view summary information quickly, allow further investigation by drilling down the data and it combines data from disparate sources.


Characteristics of Executive Dashboard:

  • Real-time information (data must be retrieved/posted in a scalable way)
  • Data may be from different data sources/backend
  • Links up the related information (ie. events / news)
  • Provide drill downs function
  • Customization for different users


Project Scope

The F1 project has been split into different phases. Our team will kick start the project (first phase) and expected deliverables for this phase is a well-tested dashboard. We will be spending more time analyzing the current business challenges on useful and actionable information, identifying the business intelligence requirements to support the business decision, and enhance on the existing data model.

Build on Trigantic application and enable for data drill down up to detail level:

  • Trace & Track (Real-time Analytical Dashboard)
  • Strategic overview dashboard
  • Key Performance Index (KPI) Dashboard
  • Summary Report


Main Project Scope:

  • Analyze the current business challenges
  • Identifying the business intelligence requirement
  • Develop a role-based dashboard (3 Main Roles: Executive, Manager and Supervisor)
  • Develop new data model


Team Phenomena

The team comprises of 4 members as follow:

  • Ang Peiqi - Project Manager
  • Lim Hui Mien - System Analyst
  • Lim Junwei, June - Database Analyst
  • Tan Zhi Jia - Business Analyst


FYP Supervisor

We are glad to have Professor Benjamin Gan as our supervisor as well as being a mentor to us.


Our Client

We are fortunate to have IDS(HK) as our FYP Sponsor. Special thanks goes to Mr. Tim Collins, our sponsor, as well as Mr. Paul Fowler, liaison for IDS. We're also grateful to Ms.Sim Kiat, our Project Manager of Project F1 to oversees the project development, Mr. Tomy Kwong, our Project Governance from Hong Kong and Mr. Nicholas Tan, our Technical Support from Malaysia. Lastly, we also thank Ms. Chan Jain Shin, Technical Support from IDS(Malaysia), for coming down to Singapore to conduct Trigantic Training for our team.

Project Schedule

Project Schedule.gif


Weekly Progress

Week 1 (20 Apr - 26 Apr)

  • Submission of Project Proposal - 100%
  • Attending Trigantic Training at IDS Singapore, conducted by Ms. Chan Jain Shin (IDS Malaysia) - Attended
  • Change Project Schedule to Iterative Approach - 100%
  • Update Risk - 100%
  • Update Wiki - 100%
  • Documentation of Trigantic Training - 60%
  • Market Research - 50%


Week 2 (27 Apr - 3 May)

  • Submission of Trigantic Training Documentation - 100%
  • Submission of Project Proposal - 100%
  • Attend IS480 Briefing - Attended
  • Market Research - 100%


Week 3 (4 May - 10 May)

  • Attended Hyperion Training at IDS Hong Kong, conducted by Mr. David Koo - Attended
  • Attended FDA Work Flow Presentation at IDS Hong Kong, conducted by Mr. Stephen Tsang and Mr. Ng Kam Bor - Attended
  • Gather user requirement at IDS Hong Kong from Ms. Betty Tsang and Mr. Micheal Beverly - 100%


Week 4 (11 May - 17 May)

  • Documentation of Hyperion Training - 100%
  • Summary of 3 Main Report (Promotion Compliance, Price Check, Trend Report) - 100%
  • Gap Analysis - 0%
  • Draft Business Functional Requirement - 100%
  • Draft Design of the Dashboard - 50%


Week 5 (18 May - 24 May)

  • Environment Setup (Access Right not given) - 60%
  • Dashboard Design - 80%
  • Draft Gap Analysis - 60%
  • Business Functional Requirement Report - 100%


Week 6 (25 May - 31 May)

  • Environment Setup (Access Right Given) - 100%
  • Dashboard Design - 100%
  • Draft Gap Analysis - 100%
  • Data Model - 80%
  • Familiar with Oraclas - 30%
  • Presentation on the Design of the Dashboard - Pending for IT / User Approval


Week 7 (1 Jun - 7 Jun)

  • Setup Database environment in Trigantic - 100%
  • Start Phase 1 development : Promotion Compliance (Using Dummy Data) - 10%
  • Create Data Dictionary and Data Model according to new requirements - 100%


Week 8 (8 Jun - 14 Jun)

  • Create Database Schema in Oracleas - 100%
  • Draft Mid term review - 100%
  • Update Development Specification
    • Include changes which the user has feedback for all dashboard
  • Update Project Schedule
    • Due to user change requirements
  • Update Gap and Functional Business Requirement Document
    • Include changes which the user has feedback


Week 9 (15 Jun - 21 Jun)

  • Finalise Development Specification- 70%
    • Note: Waiting for user sign off for trend dashboard in Hong Kong
    • Price Check - 100%
    • Promotion Compliance - 100*
    • Trend Report - 0%
  • Finalise Gap and Functional Business Requirement Document - 100%
  • Development of Promotion Compliance Dashboard - 50%
    • Problem Faced: Complexity of development
  • Planning for Pricing Check Dashboard - 60%
  • Mapping of data from FDA Database (Promotion Compliance)- 50%
    • Note: Waiting for Hong Kong to load data into PY_FDAHKF1 Database
  • Start on Unit Test Plan for all reports - 30%


Week 10 (22 Jun - 28 Jun)

  • Finalise Trend Dashboard Development Specification - 80% (Waiting for user feedback)
    • Note: Trend Dashboard split into 2 Part, namely Cycle Report and Trend Report
  • Development of Promotion Compliance Dashboard - 80%
    • Problem Faced: Drill-down functionality, Parameter Passing and Limitation of Trigantic
  • Start Development for Pricing Check Dashboard - 30%
  • Mapping of data from FDA Database to Trigantic Database - 40%
    • Note: Create view and materialized view during mapping of data to Trigantic
    • Promotion Compliance Data Mapping - Completed
    • Daily Price Check Data Mapping - 50%
    • Weekly Price Check Data Mapping - 0%
    • Cycle Report Data Mapping - 0% (Waiting Hong Kong side to finalize trend dashboard development specification)
    • Trend Report Data Mapping - 0% (Waiting Hong Kong side to finalize trend dashboard development specification)
  • Start on Unit Test Plan for all reports - 50%
    • Promotion Compliance Test Plan - Completed
    • Price Check Test Plan - Completed
    • Cycle Report Test Plan - 0%
    • Trend Report Test Plan - 0%


Week 11 (29 Jun - 5 Jul)

  • Development of Promotion Compliance Dashboard - 95%
    • Note: Design of dashboard
  • Start Development for Daily Pricing Check Dashboard - 70%
    • Problem Faced: Calendar and Parameter cannot pass value with white space
  • Start Development for Weekly Pricing Check Dashboard - 30%
    • Problem Faced: Calculation for Mode Price
  • Start Development for Cycle & Trend Dashboard - 0%
    • Problem Faced: Data haven port into Trigantic
  • Mapping of data from FDA Database to Trigantic Database - 60%
    • Note: Create view and materialized view during mapping of data to Trigantic
    • Promotion Compliance Data Mapping - Completed
    • Daily Price Check Data Mapping - Completed
    • Weekly Price Check Data Mapping - Completed
    • Cycle Report Data Mapping - 0% (Waiting Hong Kong side to map data into PY_FDAHKF1 Database, before we can map data to Trigantic)
    • Trend Report Data Mapping - 0% (Waiting Hong Kong side to map data into PY_FDAHKF1 Database, before we can map data to Trigantic)
  • Start on Unit Test Plan for all reports - 50%
    • Promotion Compliance Test Plan - Completed
    • Price Check Test Plan - Completed
    • Cycle Report Test Plan - 50%
    • Trend Report Test Plan - 50%

Week 12 (6 Jul - 12 Jul)

  • Development of Promotion Compliance Dashboard - 100%
  • Start Development for Daily Pricing Check Dashboard - 100%
  • Start Development for Weekly Pricing Check Dashboard - 100%
  • Start Development for Cycle & Trend Dashboard - 100%
  • Mapping of data from FDA Database to Trigantic Database - 100%
  • Start on Unit Test Plan for all reports - 80%
    • Promotion Compliance Test Plan - Completed
    • Price Check Test Plan - Completed
    • Cycle Report Test Plan - Completed
    • Trend Report Test Plan - 40%
  • Start on User Acceptance Test for all reports -

Week 13 (13 Jul - 17 Jul)

  • Start on User Acceptance Test for all reports - 100%
    • Promotion Compliance Test Plan - Completed
    • Price Check Test Plan - Completed
    • Cycle Report Test Plan - Completed
    • Trend Report Test Plan - Completed
  • Prepare for final report and presentation
  • Feedback session with our client
  • Presentation at 2pm 14th July Friday at IDS Singapore