The Qtel principle activities are mobile phone services, broadband solutions etc.serving both consumer an business markets. Headquarted in Doha,Qatar the company is ambitiously growing its global business on the basis of its emerging markets.

Business Case:

In order to improve the understandability, performance and extensibility of the data warehouse, we have applied the techniques and concepts of dimensional modeling to the entire data modeling (rather than the more operations-oriented entity-relationship modeling).

Project included the following activities:

• Generation of dimensional tables and values
• Extraction and calculation of values from fact tables
• Building of hierarchies
• Loading the data into SAP BO data 4source

Tools & Technologies:

IBM Datastage, Oracle 10g/11g.