Download our papers
Improve your decision-making process based on quality data using advanced analytics and be a part of digital transformation. Extract consumer insights to learn more about their preferences and reinvent the customer experience.
Telco DWH Model is a standard industry data warehouse model applicable for Communications Service Providers (CSPs), Mobile Network Operators (MNOs), Multiple System Operators (MSOs), Mobile Virtual Network Operators (MVNOs), Fixed Telco and VoIP Service Providers. It covers all your traditional Business Intelligence requirements, regulatory requirements including GDPR and IFRS 15 and Big Data Analytics requirements.
Telco DWH model
®
Highlights
Based on industry best practices and open for all necessary modifications to adjust to individual telecom customer needs
Based on a strong Primary Key – Foreign Key relationships that assure consistency in the model itself and in the content of the implemented Data Warehouse System
Developed with ERWin but exportable to any other standard database modelling tool formats
Consists of more than 700 Entities (Tables) grouped in 44 Subject areas, with more than 8.000 attributes, more than 1.100 relationships and more than 1.800 keys
Telco DWH Model® is TM Forum Frameworx 18.5 Certified! The model's logic follows TM Forum's Information Framework Shared Information Data Model (SID), a common reference model that service providers, software providers, and integrators use to describe enterprise management information. Based on data represented, it allows delivery of all standard Telecommunication reporting and analysis Data Marts.
Telco DWH model
®
Benefits
Delivers competitive advantage by enabling clean data consolidation across multiple systems
Supports rapid implementation of warehousing solutions with meaningful data
Facilitates a structured approach to subsequent customization and extension of the data warehouse
Enables business users to effectively control and reduce time taken to scope their requirements, as well as subsequent customization and extension of the data warehouse
Provides a solid basis for management reporting and relationship management supporting decision making and executive information applications
Reduces the risk of failure by facilitating an incremental approach to delivering integrated data warehouse solution
Comprehensive – collecting content from multiple client engagements and turning it into a suite of related Subject Areas – with a proven methodology and models that require minimal customization
Currently used by several operators, large and small, around the world
Fosters collaboration and approval between business and IT to turn business requirements into actionable solutions
Minimizes development costs
Telco DWH model
®
Details
Conformance of Telco DWH model® with TM Forum’s business process framework (etom) and information framework (sid)
We are committed to providing our customers with an industry standards-based model designed to support and adjust to our customers’ different needs from reporting and analysis to complex simulations and prediction models.
Telco DWH Model is TM Forum Frameworx 18.5 certified and a 100% SID compliant – it is using the same naming and terminology for aggregated business entities in business domains. Our model is using standard SID modelling patterns and building on existing SID architecture and involving some common Telco terms like Rate Plan (Tariff Plan) and detailed product classification (Billing products, Devices, SIM Cards, Vouchers, Packages…) Also, Telco DWH Model Dimensional data is organized around SID horizontal domains (Market/Sales, Customer, Product/Service, Resource, Engaged Party, Enterprise, Common Business Entities)
Big data analytics enabled
Telco DWH Model is also addressing new Big Data Analytics requirements, related to data from sensors, Machine to Machine data and Internet of Things. The model supports location-based analytics and content analytics functionalities and provides a foundation for integrating of structured and non-structured data for the unified analytical layer.
- Common business and infrastructure tables
- Invoice and payment, dunning
- Contact center
- Cas tables
- Loyalty program
- Finance (Capex & Opex)
- Usage and recharge tables
- Marketing campaign, market share Churn prediction
- Inventory
We are producing and collecting anenormous amount of data. Implementation of Telco DWH model enabled us to achieve competitive advantage by allowing clean data consolidation across multiple systems, minimized our development cost and helped us transform our business requirements into solution that works best for us.
– Andrija Derežić, CIO at United Group
We are member of the one of the world’s largest mobile telecommunications companies, with over 133 million customers across 12 markets, which speaks a lot about extent of our needs when it comes to managing our collected data. Ooredoo Algeria recognized Telco DWH model as a model that allowed us to reduce the risk of failure, manage our data better and minimize development cost while at the same allowing modifications that we need when we need them.
– Badredine Allouche, Chef de service DWH
Telco DWH model has been proven to be flexible and easy to use which enabled faster time to the market of CT products and significantly easier maintenance. It did not require any changes since the implementation few years ago, besides integration with new systems, which is the best indication of its quality.
– Jovana Mihajlovac, Head of Enterprise IT solutions
Petrol is a company that operates in several industries; Oil and Gas, Retail and Utility. Different business requirements are challenging to fit to same reporting structures. Retail DWH model is covering most of our important business areas. It is flexible, easy to use and modify so implementation of selected Subject area is quite fast. Subject areas designed in the model are also great reference for Business Analysts when elicitating and structuring business requirements.
– Andreja Štirn, Director business intelligence
Download the resource
Telco DWH model
®
Get a real-time insight in…
PI Telco DWH model® is a standard industry data warehouse model applicable for fixed and mobile telecommunications operators, covering traditional Business Intelligence requirements including GDPR and IFRS 15, Big Data Analytics and IoT requirements. More than ten mobile, fixed and broadband operators at three continents with more than 45 million subscribers are using PI Telco DWH Model for their analytical systems.
Telco DWH model® is an exclusive intellectual property of Poslovna Inteligencija. PI grants a nontransferable and nonexclusive right to use the Telco DWH model®, with delivered customizations and extensions to its Customers who purchased the model.
Telco DWH model is a standard industry data warehouse model applicable for fixed and mobile telecommunications operators, covering traditional Business Intelligence requirements.
Data warehouse models
Improve your decision-making process based on quality data using advanced analytics and be a part of digital transformation. Extract consumer insights to learn more about their preferences and reinvent the customer experience.
Gain insight into customer trends and historical data – optimize discounting, improve retention and segment your customer base to effectively acquire new customers. Data warehouse provides the basis for quality analysis of available data by deriving accurate information.
Make informed and data-driven decisions and transform information into meaningful actions. Turbulent times of saturated markets and new regulations, highlight the importance of the availability of the right information at the right time for the (re)insurance industry.
Retail DWH model ® is standard industry data warehouse model applicable for retailers and wholesalers, covering traditional Business Intelligence requirements, regulatory requirements and Big Data Analytics requirements.
Download our papers
Latest blog posts