|
|
|
|
|
|
BiPM ENCYCLOPEDIA →
Business 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
|
|
|
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 intiation 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.
|
| |
|
|
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.
|
| |
|
|
This is the stage where you translate the business requirements into detailed dimensional modeling.
|
| |
|
|
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.
|
| |
|
|
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.
|
| |
|
|
The physical data-warehouse database design and implementation includes setting naming standards, designing database tables & columns, setting aggregation plan and resource handling parameters.
|
| |
|
|
|
|
|
|
All Chapters in "Data-Warehouse/Mart." Section
|
|
|
|
| Tags - See all |
| |
| |
| Back |
Free 
Subscribed 
Trial 
Not Sub.