Data Warehouse/Decision Support

Methodology

Crestone Systems uses Rapid Database Marketing™ Methodology to develop marketing information systems that consistently exceed client expectations. The methodology ensures that systems can be delivered as expected and that all phases of a project, including testing and implementation are appropriately planned. Crestone Systems customizes this methodology to accommodate each project. The methodology consists of the following high-level steps:

I.  Information Gathering/Document Requirements

1.   Determine Database Objectives
Ø Document Database Objectives
Ø Identify User Base
Ø Identify Potential Volume
Ø Collect Representative Materials

2.    Develop Business and Systems Requirements
Ø Identify Tools and Technologies
Ø Develop Logical Data Model
Ø Develop Process and Data Flow Models
Ø Document Business Requirements
Ø Identify Security Requirements

3.    Create Hardware/System Infrastructure Recommendation
Ø Conduct On-Site Assessment
Ø Create System Configuration Recommendation

II.  Transform and Load Physical Database

4.    Install Physical Environment
Ø Hardware
Ø System and Database Software
Ø Physical Database Install

5.    Perform Data Cleansing, Validation, Matching and Transformation

6.    Create Periodic Load Process
Ø Create Periodic Load Design
Ø Build Periodic Load Process
Ø Test Periodic Load Process

III. Build Analytical/End User Front End/Applications

7.    Create Application(s) *
Ø Create Application Components
Ø Create Forms
Ø Create Database Components
Ø Package and Test The Components
Ø Convert Legacy Data

8.    System and User Test
Ø Create Test Plan
Ø Conduct System and User Tests

9.    Create User Documentation
Ø Develop System and User Documentation
Ø Develop Training Materials

10.  Final Review and Approval
Ø Review System with Client

IV. Deployment

11.  Deliver and Deploy Application(s) and Analytical Environments
Ø Create Final Application
Ø Implement Training Strategy
Ø Monitor Performance