The core principles for developing a proficient data warehouse

A Data warehouse is a repository of information gathered from multiple sources, stored under a unified schema, at a single site. We know that Data warehousing is the most leading, reliable & important technology which is used today by more companies for planning, forecasting, and management to use the minimum resources. Data Warehouse is the centralized store of detailed data from all relevant source systems, allowing for ad hoc discovery and drill-down analysis by multiple user groups. Various implementation factors play critical role to successful data warehouse (DW) project implementation. DW has unique characteristics that need to consider during implementation. There is little empirical research about implementation of DW to get success. Determining factors affecting DW success are important in the deployment of this DSS technology by organizations. A major research has been done in this field regarding design and development of data warehouses and a minor research still needs to be done for better utilization the data warehouse. An area which needs special attention from research community is data warehouse implementation & maintenance.

We know that, the project may be failure due to the poor management of designing the data warehouse. This is the major factor for data warehouse project in the company. Without proper management desired results are nearly impossible to attain from a data warehouse. Unlike operational systems data warehouses need a lot more management and a support team of qualified professionals is needed to take care of the issues that arise after its deployment including data extraction, data loading, network management, training and communication, materialized view and some other related tasks. So, that the topic of my research is to explore the impact of the selected factors, under organizational, project-related and environmental dimensions, on data warehouse projects.