Energy Provider Data Warehouse Design and Implementation - Case Study

Abstract

An important issue in data warehousing is to extract, clean and design suitable multi-dimensional data models as required by organizational decision making where the main objective is to support exploring, querying, reporting and analysis. This paper shows the design and implementation of data warehouse within context of Energy Provider Company which collects various data from seven different transactional database instances and unifies them under single schema, in order to improve the reporting process.