Blogger-24 Facebook-24 LinkedIn-24

Data Warehouse Model for Telecommunications

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 telecoms in Adriatic region. Also, it is open for necessary alterations and modifications required for each telecom customer. The full or partial model is used by the following clients: 

      Hrvatski telekom (T-Com,T-Mobile)
      HT Mostar
      Crnogorski telekom
      Makedonski Telekomunikacii

In the current version 1.1.5 of the model, model has more than 150 Entities (Tabels) grouped in 18 Subject areas:    

  1. Business Items Subject area
  2. CAPEX Subject area
  3. Contact Center Subject area
  4. Customer Subject area
  5. Dunning Subject area
  6. Human Resources Subject area
  7. Interconnection Subject area
  8. Inventory Management Subject area
  9. Loyalty Programm Subject area
  10. Marketing Campaign Subject area
  11. Number of Subscriptions Subject area
  12. OPEX Subject area
  13. Procurement Subject area
  14. Quality of Service Subject area
  15. Rate Plan Subject area
  16. Revenue and Collection Subject area
  17. Service Management Subject area
  18. Traffic Subject area

 

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

Visual representation of the model:


telcomodel