Telco DWH model is a standard industry data warehouse model applicable for fixed and mobile telecommunications operators, covering traditional Business Intelligence requirements.
Our Telco DWH Model® is implemented in more than 10 mobile, fixed, and broadband operators on 3 continents, with more than 40 million total subscribers. Extract usage insights to learn more about customer preferences and reinvent their company experience.
Our 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 & regulatory requirements including GDPR, IFRS 15 and Big Data Analytics.
Become Big Data Analytics Enabled
We adress new big data analytics requirements related to data from sensors, machine to machine data, and IoT. The Telco DWH Model® supports location based analytics, content analytics functionalities, and provides a foundation for integrating structured / non structured data for the unified layer.
Telco DWH Model
®
Highlights
Based on industry best practices and open for all necessary modifications to adjust to individual telco 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 format
Consists of more than 700 Entities (Tables) grouped in 44 Subject areas, with more than 8.000 attributes, 1.100 relationships and 1.800 keys
Telco DWH Model
®
Benefits
Currently used by several operators, large and small, around the world
Minimizes development costs
Delivers a competitive advantage by enabling clean data consolidation across multiple systems
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
Supports rapid implementation of warehousing solutions with meaningful data
Facilitates a structured approach to 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 an 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
Fosters collaboration and approval between business and IT to turn business requirements into actionable solutions
Telco DWH Model
®
Details
Our Telco DWH Model® is TM Forum Certified!
We are committed to providing our customers with an industry standard-based model, designed to support and adjust to our customers’ different needs from reporting and analysis to complex simulations and prediction models.
Since 2019, our Telco DWH Model® is conformant with TM Forum’s business process framework (etom) and information framework (sid). It is using the same naming and terminology for aggregated business entities in business domains, and incorporates SID modelling patterns. We building on existing SID architecture and involve some common Telco terms like Rate Plan (Tariff Plan) and Product Classification (Billing products, Devices, SIM Cards, Vouchers, Packages).
The dimensional data of our Telco DWH Model® is organized around SID horizontal domains (Market/Sales, Customer, Product/Service, Resource, Engaged Party, Enterprise, Common Business Entities).
- 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
Download the resource
Download our
PI
Telco DWH Model
Ebook!
Make data driven decisions and transform information into meaningful actions.
Our 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.
Learn more about Telco customer preferences and reinvent their user experience.
Optimize discounting, improve retention, and segment your customer base to effectively acquire new Banking customers.
Saturated markets and new regulations highlight the importance of the right information available at the right time for the Insurance industry.
Cover traditional business intelligence, regulatory, and big data analytics requirements for the Retail & Distribution industry.
