Poslovna Inteligencija Telecommunications Data Warehouse Data Model is standard industry data warehouse model applicable for fixed and mobile telecommunications operators.

It is based on industry best practices, developed and applied during data warehouse system implementations in major Telecom operators in Adriatic region. Also, it is open for necessary alterations and modifications required for each customer. Implementation of full model in two large Telecom operators in Adriatic region started in 2007.

The model is based on strong Primary Key – Foreign Key relationships that will assure consistency in the model itself and in content of implemented Data Warehouse System.

Model is Developed with CA ERWin, current release is 7.2.

In current version of the model, model has more than 130 Entities grouped in 16 Subject areas:
1. CAPEX Subject area
2. Contact Center Subject area
3. Customer Subject area
4. Dunning Subject area
5. Human Resources Subject area
6. Interconnection Subject area
7. Inventory Management Subject area
8. Marketing Campaign Subject area
9. Number of Subscriptions Subject area
10. OPEX Subject area
11. Procurement Subject area
12. Quality of Service Subject area
13. Rate Plan Subject area
14. Revenue and Collection Subject area
15. Service Management Subject area
16. Traffic Subject area

Based on data represented in the model, all standard Telecommunication reporting and analysis Data Marts can be delivered.