DATA WAREHOUSING FOR SMALL SCALE ENTERPRISE

Abstract

This project work contains five chapters and references. The chapter one includes introduction to the data warehousing and the basic concepts to why and how data warehouses can be useful to small scale businesses, the chapter two contains literature review of the project summing up all the nitty-gritties of the data warehousing solution in view ranging from the history to facts tables and variety of dimension tables, the chapter three contains the methodology to design and develop the data warehouse as well as the necessary tools used in the development process and all of the requirements for the solution to be implemented by a user, the chapter four contains implementation details of the data warehouse highlighting the four major modules of this data warehousing solution: data source module, data integration module, data warehouse and business intelligence which may be known as reporting, the chapter five contains the summary being the result of my research and conclusion listing the recommendations and round-up.