Integrated data warehousing for telecommunication industries

Data warehousing provides an excellent opportunity in transforming operational data into useful and reliable information to support the decision making process in any organization. Data Warehouse (DW) generalizes and consolidates multidimensional (MD) data. Hence, DW has become an important platform for Online Analytical Processing (OLAP) which is based on a MD data model. In this paper, we propose an integrated data warehouse system for the telecommunication companies in Bangladesh .Our integrated DW provides a common framework based on temporal data from different telecommunication operators rendering their services. We develop a dimensional model architecture, data extraction methodology, transformation and loading techniques which provides analytical options with the implementation of relational OLAP.