Data ware House for Insurance
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.
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 ERWin and will require ERWin license to view or change. Model can be exported to any other standard database modeling tool format.
Visual representation of Main Subject Area, which consists of all PI Insurance DWH Model Entities:
In PI Insurance DWH Model, semantic data model is actually integrated with logical data model in several ways: relationships between the various entities are named and they describe type of relationships, naming conventions for entities and attributes is respected throughout the model, and all attributes have a domain. Domains are not only generic (String, Number, Date), but also context-specific and descriptive of attribute role (Name, Address, ID, Telephone Number).
PI Insurance DWH Model is customizable per customer specific requests. There are several types of customizations, for instance customizing of existing Entities including changing attribute properties (name, type, and description), adding new attributes, adding indexes etc., creating of new Entities if there is a requirement for a new dimension or new aggregation, adding new Subject areas with multiple entities that will cover new business areas and customizing of physical model – defining partitions, block sizes etc.
Datawarehouse model for banking
Data Warehouse provides the basis for quality analysis for available data by deriving accurate information from data. In recent years, banks have accumulated large amounts of data from business and now it is time to turn data into money, and we can help you in that process.
Our Banking Data Warehouse Model is standard industry data warehouse model, business oriented and 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.
Visual representation of the Model
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 Warehousemodel is open for changes and additional customization. Updates are available on regular basis.
Model is fully implemented in Addiko bank, Serbia, and parts of that model are in use in Erste & Steiermärkische Bank d.d. and Sberbank d.d.
current version of this model has more than 450 entities which have been clustered in 5 different practical groups
Data ware House for telecom
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.Our 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.
Visual representation of the model
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.
The current version of the model consists of more than 450+ Entities (Tables) grouped in 35 Subject areas, which are grouped into 5 functional groups:
Full implementations or parts of the model are in use in telecommunication companies such as Croatian Telecom and T-Mobile Croatia (DT Group), Montenegro Telecom (DT Group), JP Hrvatske Telekomunikacije d.d., two large mobile operators in North Africa and one large mobile operator in Asia.
Datawarehouse model for retail
PI Retail DWH model is based on strong Primary Key – Foreign Key relationshipsthat will assure consistency in the model itself and in a content of implemented Data Warehouse System. Physical model implementations can be in every standard RDBMS and also in any ODBC-compliant NoSQL environment.
PI Retail DWH model is developed with ERWin and will require ERWin license to view or change. ERWin license is not part of PI Retail DWH model ® license, but we can also provide an ERWin license if needed. The model can be exported to any other standard database modeling tool format.
In the current version of the model, the model has more than 300 Entities (Tables) grouped in 30 Subject areas.
MODEL CUSTOMIZATIONS
PI Retail DWH model ® is customizable per customer specific requests. There are several types of customization:
- Customizing of existing Entities including changing attribute properties (name, type, and description), adding new attributes, adding indexes etc.
- Creating of new Entities if there is a requirement for a new dimension or new aggregation
- Adding new Subject areas with multiple entities that will cover new business areas
- Customization of physical model – defining partitions, block sizes etc.
PI RETAIL DWH MODEL BENEFITS
PI Retail DWH model
contains a comprehensive set of subject areas, including a physical warehouse design, as well as a business terminology model and analysis templates that accelerate the development of business applications / a decision support system. PI Retail DWH model ® accelerates development and mitigates risks associated with enterprise data management, data warehousing, and Business Intelligence application development.
PI Retail DWH model ® is a platform-independent solution that contains thousands of hours’ worth of development effort and expertise to help business users and IT staff to implement data marts & analytical applications on time and on budget. It offers the scalability and flexibility needed to address existing and future data consolidation requirements and can be customized to meet specific needs of a retailer.
Benefits for retailers:
- Delivers competitive advantage by enabling the consolidation of clean data across multiple systems.
- Supports rapid implementation of warehousing solutions with meaningful data.