Establishing 'Making it Happen' as a 'Formal & Predictable' Discipline

DW Maintenance Enhancement

Execution-MiH ENCYCLOPEDIA → Enterprise Intelligence → SECTION - Data-Warehouse/Mart →

CHAPTER -

Data Warehouse Project Plan- Work Break-Down Structure

We have covered many diverse topics in Data Warehouse Section. This chapter is dedicated to bring them all into a list and sequence of activities that you will do to make a data warehouse project happen. We have covered different data warehouse topics at various stages. This chapter puts them all together in an integrated fashion. Though most of the activities here are linked to the data warehouse, may of them are linked to the overall BI including OLAP and end-user tools. One has to note that Data Warehouse initiative is not implemented alone. It is always associated with the implementation of the end-user tools (like query tools, data mining tools, reporting tools...). We will have one topic page assigned to each major phase of a Data Warehouse project.

Topics

Data Warehouse Project Definition

Project definition phase comes before the data warehouse project initiation phase. This is the hazy phase, where the idea of Data Warehouse takes shape

Data Warehouse Project Initiation Phase

Data warehouse project initiation is the stage, where the first level assessment of the Data Warehouse scope, cost and time estimate is done. This is mainly achieved by prioritizing the business themes for Data-Warehouse.

Data Warehouse Business Requirements Gathering Phase

This is the stage of business requirements gathering at a detailed level. This includes interviews, detailed reporting and analytics requirements followed by assessment of current IS-IT environment.

Data Warehouse Modeling and Analyze Phase

This is the stage where you translate the business requirements into detailed dimensional modeling.

Data Warehouse Design Phase

Data Warehouse design phase is hinged around the extraction, transformation and loading phase. It is advisable to do a test run on a simple schema, before getting down to a full design of your enterprise data warehouse.

OLAP + Data Warehouse Design Phase

Data Warehouse can be considered incomplete without the OLAP server layer. This topic covers the design work needed around OLAP and for OLAP+DW combination.

Physical Database Design and Implementation

The physical data-warehouse database design and implementation includes setting naming standards, designing database tables & columns, setting aggregation plan and resource handling parameters.