Scribd
Upload
775 views1 page

Data Warehouse Delivery Process

The document outlines a structured process for delivering a data warehouse, starting from IT strategy development to securing funding and justifying investment. It includes steps for defining business requirements, creating technical blueprints, and building the infrastructure for data management. The process emphasizes continuous evolution to adapt to changing business needs and automate various data handling tasks.

Uploaded by

sriharini sriram S
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
775 views1 page

Data Warehouse Delivery Process

The document outlines a structured process for delivering a data warehouse, starting from IT strategy development to securing funding and justifying investment. It includes steps for defining business requirements, creating technical blueprints, and building the infrastructure for data management. The process emphasizes continuous evolution to adapt to changing business needs and automate various data handling tasks.

Uploaded by

sriharini sriram S
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Data Warehouse Delivery Process

1. IT Strategy: Develop a strategy to secure and retain funding for the project.
2. Business Case Analysis: Justify investment and identify projected business benefits.
3. Education & Prototyping: Experiment with data analysis, educate the team, and use
prototyping for progress.
4. Business Requirement: Define the logical model, source systems, business rules, and
query profiles.
5. Technical Blueprint: Create architecture plans to meet long-term requirements,
including server and data mart design.
6. Building the Vision: Develop the first production deliverable and establish
infrastructure for data extraction and loading.
7. History Load: Load historical data into the warehouse, creating additional tables as
needed.
8. Ad-Hoc Query: Configure tools for users to generate database queries for analysis.
9. Automation: Automate processes like extracting, loading, transforming, backing up,
restoring, and generating aggregates.
10. Extending Scope: Add new data sources and data marts to address evolving business
needs.
11. Requirement Evolution: Continuously update the system to reflect changing
business requirements.

You might also like