Stages in a typical Data Warehousing project

Most of the guys ask me about DWH Phase in projects,so here it is:

 i.            Requirement Gathering

The Project team will gather end user reporting requirements and the remaining period of the project would be dedicated to satisfying these requirements.

                              ii.            Identify the Business Areas.

Identify the data that would be required by the Business.

                            iii.            Data Modeling

The foundation of the data warehousing system is the data model. The first step in this stage is to build the Logical data model based on the user requirements and the next step would be to translate the Logical data model into a Physical data model.

                            iv.            ETL Process: ETL is the Data Warehouse acquisition processes of Extracting, Transforming and Loading data from source systems into the data warehouse.

This requires an understanding of the business rules, the logical and the physical data models and also involves getting the data from the source and populating it into the target.

                              v.            Reporting: Design, Develop and enable the end users to visualize the reports thereby bringing value to the Data Warehouse.