Data Warehouse Models

Data Warehouse Model for Insurance

Poslovna Inteligencija Insurance Data Warehouse Data Model (PI Insurance DWH Model) is a standard industry data warehouse model applicable for both life and non-life insurances. Based on data represented in the model, all standard insurance reporting and analysis Data Marts can be delivered.
 
PI Insurance DWH Model is based on industry best practices, developed and applied during data warehouse system implementations in Basler osiguranje Zagreb. Also, it is open for necessary alterations and modifications required for each insurance customer.
 
PI Insurance DWH Model is based on strong Primary Key - Foreign Key relationships that will assure consistency in the model itself and in content of implementation Data Warehouse System. Physical model implementations can be in every standard RDBMS.
 
PI Insurance DWH Model is developed with CA ERWin and will require ERWin license to view or change. Model can be exported to any other standard database modeling tool format.
 

Read more: Data Warehouse Model for Insurance

Parent Category: Solutions

Data Warehouse Model for Banking

Poslovna Inteligencija Banking Data Warehouse Data Model is standard industry data warehouse model, business oriented, designed to support different business needs from regulatory and daily/weekly/decade/monthly operational and management reporting to very complex ad hoc analysis and simulations. Model is based on industry standards and implementation best practices, proven in real implementation projects. It has extremely flexible design and, besides the implementation of enterprise-wide data warehouse solution, offers banks a choice to implement fully functional modules (departmental data marts) according to their needs. Since the model is designed in a way to support the iterative implementation, the Bank may, at any time, decide to extend the existing solutions with new modules, while retaining the full functionality of the existing solutions during the implementation of new modules. PI Banking Data Warehouse model is open for changes and additional customization. Updates are available on regular basis. 

 

Model is fully implemented in:

 
      Hypo Alpe Adria Bank, Sebia
 
Parts of that model are in use in:
 
      Erste & Steiermärkische Bank d.d., Croatia
      Sberbank d.d., Croatia 
 

Model is developed with CA ERWin, and major subject areas in current version 2.1 are:

  • Location
    • Geographic locations
    • Electronic locations
  • Party
    • Organization
    • Individual
    • Legal Entity
    • Financial Institution
    • Provider
    • Customer
    • Human Resource
    • Party relations
  • Account
    • Customer Account
    • General Account
    • Competitor Account
    • Limit
    • Payment Plan
    • Payment Cards
    • Account conditions
    • Account relations
  • Transaction
    • General Ledger Account
    • Transaction Statement
    • Transaction Entry
    • Event
  • Resource Item
  • General Ledger
    • General Ledger Balance
    • General Ledger Average Balance
    • General Ledger Summary
  • Portfolio
    • Credit Portfolio
    • Deposit Portfolio
    • Customer Portfolio
    • Credit Risk Portfolio
  • Profitability
    • Customer Profitability
    • Product Profitability
    • Organization Unit / Cost Centre Profitability
    • Location Profitability
    • Channel Profitability
    • Activity Based Costing Analysis
    • Profitability Analysis
    • Transaction Profitability Analysis
  • Basel II
  • IFRS
  • Anti-Money Laundering
  • Asset and Liability Management
  • Regulatory compliance
  • 360 Degree View of Customer
    • Customer Summary
    • Customer Behavior Analysis
    • Customer Loyalty
 
banking_model_small
Parent Category: Solutions

Data Warehouse Model for Telecommunications

Poslovna inteligencija Telecommunications DWH Data Model

Poslovna Inteligencija Telecommunications Data Warehouse Data Model is standard industry data warehouse model applicable for fixed and mobile telecommunications operators, covering both traditional Business Intelligence requirements and Big Data Analytics. It is based on industry best practices, developed and applied during data warehouse system implementations in major telecoms. Also, it is open for necessary alterations and modifications required by each customer. Full implementations or parts of the model are in use in:

      • Croatian Telecom and T-Mobile Croatia (DT Group), Croatia
      • Montenegro Telecom (DT Group), Montenegro
      • JP Hrvatske Telekomunikacije d.d., Mostar, Bosnia and Herzegovina
      • Two large mobile operators in North Africa
      • One large mobile operator in Asia 

The model is based on strong Primary Key – Foreign Key relationships that will assure consistency in the model itself and in content of implemented DWH System.Logic of the model is following TM Forum's Information Framework Shared Information Data Model (SID), as a common reference model that service providers, software providers, and integrators use to describe enterprise management information. Based on data represented in the model, all standard Telecommunication reporting and analysis Data Marts can be delivered.

Model is Developed with CA ERWin. In current version 2.1 of the model, model has more than 340 Entities (Tables) grouped in 29 Subject areas, grouped in five main functional groups. Subject Areas functional grouping is as follows:

Common Business

    • Business Items and KPI’s Subject Area
    • Party Subject area
    • Product Subject area
    • Location Subject area
    • ETL Process Execution Audit Subject Area

Customer, Account & Subscriber

    • Customer Subject area
    • Rate Plan Subject area
    • Sales Subject area
    • Number of Subscriptions Subject area
    • Loyalty Program Subject area
    • Contact Center Subject area
    • DM - Churn Prediction
    • Marketing Campaign Subject area

Revenue & Usage

    • Recharge Subject area
    • Revenue and Collection Subject area
    • Dunning Subject area
    • Traffic Subject area
    • Traffic Aggregations Subject area
    • Interconnection Subject area
    • Subscriber Location Subject area

Finance & HR

    • CAPEX Subject area
    • OPEX Subject area
    • Procurement Subject area
    • Human Resources Subject area

Infrastructure, Workflow & Inventory

    • Inventory Management Subject area
    • Project Subject area
    • Quality of Service Subject area
    • Resource Capacity Management Subject area
    • Service Provisioning Management Subject area

Telco DWH Model brochure available for download

Visual representation of the model:

 telco dwh model

Parent Category: Solutions

Subscribe to newsletter

Name:
Email:
slika19

 

ferari mini logo


6774 – FAIR

minpo_trans

cisex-member-128x128px_red

SGS_ISO-9001_TCL_HR

ISO 27001 Slika 2

AmCham Member 2015 Logo

Services

Through education and training we allow our clients to completely utilize implemented tools in everyday business. We provide trainings for specific tools, DWH and BI methodologies and tailor made training for the purposes of specific projects.

Read More...

We provide services needed for successful design, development and implementation of Big Data Processing and Analytics systems. Big data analytics is the concept of data analysis and deriving useful information from large volumes of data that is rapidly being generated in modern business.

Read More...

MDM system provides a holistic, single view of foundational business entities, commonly referred to as master data such as customers, employees, citizens, locations and products. Successful MDM projects facilitate better operational efficiency, higher customer loyalty and successful compliance efforts.

Read More...

Strategic consulting is a service provided by our top management consultants who have wide expertise in business processes in most industries in design and implementation of various types of business strategies.

Read More...

Our methodology for managing and supervising of projects is characterized by the speed in which first useful results are produced, efficiency in implementation, the flexibility of the methodology, the effectiveness of risk management, quality assurance and optimization of project documentation.

Read More...

Implementation  of intelligent information systems for support of the business decision making process is our primary field of activity. According to our clients' needs and expectations, we will provide either turnkey solutions or work together with our clients experts on implementation projects.

Read More...

Nearshoring services

Our company is providing nearshoring development services for implementation of DWH/BI/PM systems for clients in different countries in EU. We can combine shorter on-site visits with majority of the activities done off-site through secure connection.

Read More...


Technologies

In order to view this object you need Flash Player 9+ support!

Get Adobe Flash player

Powered by RS Web Solutions