New version of DWH Insurance model is available!

We are constantly working on delivering the best possible version of our Data Warehouse model and are proud to present the 1.7 version of PI Insurance DWH model.

What is new in the PI Insurance DWH Model?

The new 1.7 version of Insurance Data Warehouse model brings more than 400 Entities grouped in 26 Subject areas, divided into 5 functional groups and additional Data Marts which are derived from the functional groups’ entities.

Version 1.7

  • Added Data Marts
  • Sales Datamart
  • Human Resources Data Mart
  • Claims
  • Profitability
  • Insurance SA changes
  • Insurance Transactions entity added to the model
  • General SA
  • Standardized version of this SA added to the model
  • Legend

Sales Data Mart

Detailed insight into sales and activity review,

enables monitoring of sales trends and relevant results,

more precise monitoring of sales KPIs

Human Resources Data Mart

Overview of activities per employee,

monitoring team tasks

review of historical salaries data and review of other key indicators,

review of education, review of employee competencies


The so-called snapshot covers this area in a defined time (e.g. the monthly view where the key attributes related to the request are displayed, such as the date and number of the request, client,  the value as liquidation amount, reservation amount, requests from the past that are related to the  same customer.)


The business area is the most often used by the finance department to monitor revenue and expenses per client, insurance policy, or net values, ​​that are the basis for calculating profitability and the basis for analysis and revision of new or existing offers.

Insurance SA changes

The insurance Transactions entity was added to the model to monitor all transactions at a more detailed level for each insurance policy. Unlike the general ledger, where transactions are recorded on a larger scale per account, in the insurance transaction table, the transactions are recorded according to the purpose and type of the transaction.

General SA

The standardized version of this Subject Area was logically separated in order to make it easier during implementation, by following common elements that are present there and are connected to other subject areas (such as tables for dates, scenarios, periods, etc.).


The Legend provides an overview by color to make it easier for users in the implementation phase (architects and ETL developers) to quickly identify which business area that entity belongs to, which in turn greatly impacts the speed of implementation.

Latest news

Successfully solving the challenges faced by our clients is our greatest source of pride.
 As CSRD directive enters into force, it is reshaping the landscape of ESG reporting, introducing a standardized approach to sustainability. Navigating this regulatory shift is crucial for organizations aiming to showcase their commitment to environmental, social, and governance principles.
Join us at the Business Breakfast event called "Planning beyond Spreadsheets", December 7, 2023 at 9:15 a.m., at Restaurant 27 in Belgrade.
Algebra University College is a proud lead partner of the project, named AI-powered Next Generation of VET, and Poslovna inteligencija is one of the project team members. AI4VET4AI project addresses the need for trained workers in the field of AI, by supporting the growth of an AI-skilled workforce in Europe, with a special emphasis on VET teachers and learners.
Vertica is a powerful, flexible, and cost-effective analytical platform that is designed to handle large-scale data processing and analytics workloads.
In addition to opening its international offices, Poslovna inteligencija, with its successful spin-off company Legit, is also opening an office in the center of Osijek.
In this webinar, we want to talk about some of the key aspects and critical factors of data migration in The Economist, which we're sure will be relevant to many other enterprise companies.
Lidija Karaga, co-owner, co-founder and former member of the Management Board of Poslovna inteligencija, took over the company's leadership position in October of this year.
Scroll to Top

Stay up to date with news

Stay up to date with news

Sign up for our newsletter and always be up to date with news and technologies from the world of Poslovna inteligencija.

Business & Data Analysis
Planning, OLAP & Reporting & Financial consolidation
Data Integration, Data Migration & Data Engineering
Data Governance, Data Quality & Master Data Management
Data Science
DWH models
XBRL point
ConQ Content Analytics

I acknowledge that the personal data I submit through this contact form will be used by Poslovna inteligencija d.o.o. to contact me and provide information related to my inquiry/application. I consent to Poslovna inteligencija using my submitted personal data to send newsletters containing information about news, products, and services of Poslovna inteligencija. I also acknowledge that I can unsubscribe from receiving newsletters at any time by clicking the 'Unsubscribe' link in each newsletter. Comprehensive information related to my rights and the use of my personal data can be found in Poslovna inteligencija's Privacy Policy.:
Yes No *

Please don't insert text in the box below!

The fields marked with * are required