The double wave data warehouse lifecycle model

Abstract

The data warehouse has played a very important role in the transformation of the state owned telecommunications company in South Africa. This transformation process concentrated firstly on targets set by government during the exclusivity period and secondly, on the preparation for competition. A new Double Wave Data Warehouse lifecycle model was developed and followed to fulfil the immediate need for information through the building of a DW and BI solution in the company. It consisted of two iterations for the development of a DW and BI solution. Wave one concentrated on the rapid implementation of a Business Critical Information Solution. In this regard management information on bad debts and debtors days were considered as Business Critical Information Solution needs. Wave 2 concentrated on modelling the ongoing requirement into a permanent dimensional model.