HeaderSIS.jpg

IS480 Team wiki: 2008T3BG1 Phenomena

From IS480
Revision as of 13:31, 20 July 2009 by Peiqi.ang.2006 (talk | contribs) (→‎Week 11 (29 Jun - 5 Jul))
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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