DWSA Rapid Warehouse Solutions Solution Requirements A Different Approach to Building a Data Warehouse RWS Architecture RWS Matrix Technology Features Value Proposition Metadata - Magic or Myth RWS Metadata RWS Unplugged Staging and Test Area Integration Transformation Architecture Transformation Process Our Architecture Our Capabilities Meeting Your Needs Take The Tour

Solution Requirements

Business

The Challenge

Business users don't understand their data
Information is power "Its distribution is threatening"
New information, or new views, changes requirements
Timeliness is everything "Yesterday's issues are meaningless today."

The Needs

Involve business to:
- Confirm solutions
- Change their mind
Rapid development through automation
No penalties for rework
Return control of data and distribution to the business

ETL

The Challenge

Data from disparate systems doesn't match
Cross systems business rules difficult to model
Dirty data blows out exception handling
Users change their mind
Upstream systems constantly change

The Needs

Capture business rules once
Allow users to prototype inside the ETL process
Automate the process
- Maintaining the rules
- Defining the transforms
- Defining the target environment
Provide capacity for rework

Project

The Challenge

Development program midstream
Fixed price contract
Existing tool sets
Existing development partners
Cost constrained project
Project schedule pressure

The Needs

No upfront investment
Fixed price
Reduce development schedules
Reduce cost and time for work packages
Provide alternate approaches