Please scroll horizontally in order to see the complete Data Warehouse Navigator

Sequencing Chart        
Step Diagram
Step 1: Determine User's Needs  
  • Does the company need a data warehouse ...or even a data mart?
  • What are the business objectives?
  • Where do I get the data from?
  • Perform cost/benefit analysis, project estimation and risk assessment
Step 3: Hardware Platform  
Where should the data warehouse or data mart be housed?
  • Which hardware platforms do we already have?
  • Determine cost, interopability and staff training considerations.
  • Determine hardware based on Return on Investment (ROI).
Step 4: Data Modeling  
Building an Information Model
  • How do I use a data model to express relationships between the data?
  • Resolve access and usage issues.
  • Determine the logical and physical design of the data warehouse or data mart.
Step 5: Metadata Repository  
How do I keep track of what means what, who can access it and how it will be accessed?
  • Build a repository.
  • Determine the business user's view of the metadata repository.
Step 6: Data Aquisition & Cleansing  
How do I...
  • Extract
  • Cleanse
  • Scrub
  • Reconcile
  • Aggregate
  • Summarize from various sources for the data warehouse or data mart?

Step 7: Transformation, Transportation, Population  
How do I build the data warehouse or data mart?
  • Transform the data.
  • Transport the data.
  • Populate the data warehouse or data mart.
Step 8: Middleware Connectivity  
How do I connect the source data to the target data warehouse or data mart?
  • Ongoing connection
  • Direct data access
Step 9: Prototyping, Querying & Reporting  
How do I:
  • Implement a prototype with user involvement?
  • Develop applications?
  • Use query and reporting tools?
Step 10: Data Mining  
How do I find patterns in the data?
  • How can those patterns be used for revenue growth?
  • How can tools be used to further identify patterns in the data warehouse or data mart?
Step 11: Online, Analytical Processing (OLAP)  
  • How can users analyze the data?
  • How can the neccessary number of dimensions be determined?
  • How can users see the data represented in multiple dimensions?
  • How can they use the OLAP tools?
Step 12:: Deployment & Sales Management
How can I provide security, backup, recovery and the necessary capabilities for a production data warehouse or data mart?
  • How can resources be allocated best?
  • How can the growth of the data be accommodated?
  • How can everything be kept running smoothly?