Database Answers TM Information Framework (Click for large image)
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
5 Steps to a successful Telecomms Data Warehouse with BI   


We would be glad to have your comments.

Getting Started : Start with a Generic Design, like this one from Customers and Purchases.

Conceptual Model for Telecomms
This is a Generic Data Warehouse design
Data Model from link above
Next Step : Design Data Mart.

Conceptual Model for Telecomms
This is a Telecomms Data Mart

This is a Business-oriented Conceptual Model

Conceptual Model for Telecomms
A Semantic Layer is a business translation layer that sits between the database and the end user. 

This means that Users can define their Reporting requirements using familiar business terminology instead of Data Modeller terms. For example, 'Customer' instead of 'Party'. We have also designed :-
  • Compoments in a Semantic Layer
  • Data Mart for Markets and Brands
  • Data Mart with Conformed Dimensions
  • a Dimensional Model / Data Mart which is very useful for providng data for Reports and Business Intelligence. An interesting perspective is shown in the Information Framework from the TM Forum, and here is Wikipedia's entry for the Telecomm Consortium's Frameworx Shared Information/ Data Model.

  • This shows the ERD for the Conceptual Model shown above

    Data Model for Telecomms


    Barry Williams
    Principal Consultant
    Database Answers Ltd.
    London, England
    June 1st. 2014


    © DataBase Answers Ltd. 2014

    About Us Contact Us