Fadata BI&DWH

What are Business Intelligence (BI) and Data Warehouse (DWH)?

Now more than ever before, companies need to get the right information to the right people faster. An effective, integrated business intelligence solution can improve business performance by driving better decision making across your organization. For a BI solution to live up to its promise though, it has to be designed with the needs of every user in mind and it has to have the flexibility to accommodate all the structured information your organization uses on a day to day basis.

Typically business analysis are based on a large set of historical data for example: customer information for the last 10 years; transactions from support track systems for the last 5 years or invoices and payments for the last year for the whole company enterprise. Data Warehouse is a specially tailored data base for the purpose of analysis. Before the transactional data is loaded into the Data Warehouse it has to be cleaned, based on set of data validation rules. Data is organized around measures and dimensions. Measures are calculations, that we want to monitor and dimensions are set of characteristics, that we are interested in. The Data Warehouse structure gives us the opportunity to search for answers based on a set of dimensions and to track changes in measures. Key factor for every business intelligence solution is performance. Because analytics questions are spanning through a large set of data usually data warehouse uses OLAP structure with already calculated measures for the most important set of dimensions.

Based on their functionality, BI tools can facilitate different ways of information representation - from set of dashboards, charts and drill-through reports, alerts and KPIs to ad-hoc queries on analytical metadata. Thus you can easily monitor performance, discover most profitable business lines, empower fraud identification and prevention, manage risk and customer service and relationship.

Fadata Solution for Insurance Company

The first step on the way to effective BI for an Insurance company is the Data Transformation. The complex transactional data has to turn into clear, relevant information. This information should then allow the business to maximize profitability by monitoring trends over time, allow price optimization by identifying profitable areas and minimizing the risk. Many Insurance companies have found out, that an insurance-specific DWH and BI solution can speed up the Return On Investment (ROI) by far.

BI can play a crucial role in almost every aspect of the insurance value chain. It can help to identify risks that are profitable and those that are not. It analyzes in depth the relationship with the customers. It allows insurance companies to provide valuable information to corporate clients, which helps developing the insurer's successful relations with those clients. It enables the business to manage its agents and sales force better. This way it can improve the effectiveness of actuarial and underwriting functions. BI is may be the most critical component of claims management. It helps in fraud prevention and It allows drilling from high level alerts to the last detail to better analyze and understand specific trends and patterns.

The insurance industry is critically dependent on the availability of reliable and insightful information. Insurers are demanding that new and expanded information access provide them with the capability to improve their products, claims costs, pricing accuracy, customer service and distribution efficiency and effectiveness. INSIS Business Intelligence (BI) solution makes these goals achievable.

This solution is an end-to-end solution which allows the insurance companies to understand their business better and to make the right decisions on time as well as to improve profitability. Although it is a standard solution for INSIS it is designed to be easily customized and extremely flexible to suite the needs of the individual customer. The solution is scalable, which decreases implementation time, speeds up the ROI process and increases functionality by allowing the analysis of the business to start where mostly needed. It is also an open system, which allows other systems vital to the insurance business like Financial systems to be connected to it.

Fadata DWH Solution for Insurance Company

Fadata BI and DWH solution is completed rebuild analytic solution that covers whole process of preparation, cleaning, transformation of transactional data into valuable and meaningful information for business users. The transformation processes (ETL) is sourced from business applications as core insurance application (INSIS application), Finance systems (as SAP and OEBS) and CRM application (Siebel CRM, SAP CRM or OEBs CRM).

Data marts:

The Data Warehouse consists of Data Marts for each specific business area of the Insurance Industry and maps according to business rules to the data structures of INSIS: Underwriting, Marketing, Reinsurance, Claims, Accounting and Finance. The data warehouse schema contains organized analytical structures for: CUSTOMERS, PRODUCTS, AGENTS, POLICY, CLAIMS, PREMIUM, OBJECTS and other.The Data warehouse is a set of metadata: dimensions, metrics and attributes specially tailored for the analysis in insurance companies using INSIS such as: policy analysis, claim management and pricing information, adjustments, premiums, customer profile, level of customer services, meeting of sales objectives, marketing performance and etc.

Fadata BI Solution for Insurance Company

Fadata BI solution contains a number of build-in insurance related analysis, reports, KPIs and dashboards. The granularity of the whole set of data varies and the user can view any transactional details behind any number through flexible drill-down or drill-through, down to lowest level of detail. The Dashboards give the opportunity to find different interactive analysis in one view.Some of the analysis and reports in the Fadata BI solution are listed in the following section. In addition to these a broad set of ad hoc queries can also be performed. These allow the users to be able to answer specific questions and attend to the challenges of the Industry. In addition to this you can do large number of ad-hoc reports based on hole set dimensions.
General area
Profit/Loss
Client portfolio
Sales Monitoring area
Distribution channel
Sales portfolio
Sales activity
New sales
Sales trends
Underwriting Support area
Risk analysis
Lapses and attrition
Aged Outstanding premium
Claims Monitoring area
Claim activity monitoring
Claim payments
Event based claim analysis
Claim reserve analysis
Triangulation report
Claim trends
Reinsurance
Risks value
Shared Premium

Reinsured policies trends
Trend of claim paid

Business Object with Oracle DWH

Overview:The solution comprises of two main components – Data Warehouse build on Oracle Data Base 11g and Business Objects Edge as the BI component. The BI end user interface is Web based, which allows users to obtain the information anywhere at any time. System architecture of solution:


Sreenshots:

Oracle Business Intelligence Enterprise Edition (OBIEE)

Overview: OBIEE represents the widest and most robust range of BI functionality on a single unified infrastructure. The capabilities include interactive dashboards, full ad hoc queries and analysis, proactive intelligence delivery and alerts, enterprise and financial reporting, online analytical processing (OLAP) analysis and presentation, high-volume production reporting, real-time predictive intelligence, disconnected analytics, and integration with Microsoft Office. As well as integration with Siebel CRM. OBIEE components used in INSIS BI Solution are Interactive Dashboards, Answers, Delivers, Siebel CRM Application Integration.


Screenshots: