insurance - open source analytics dashboards for real time business overview

21
How Open Source Analytics can support better strategic decisions Complex customizable dashboards in a matter of hours for real time business overview Implemented Examples in Insurance

Upload: euro-it-group

Post on 15-Jan-2017

561 views

Category:

Technology


4 download

TRANSCRIPT

Page 1: Insurance - Open Source Analytics Dashboards for Real Time Business Overview

How Open Source Analytics can support better strategic decisions

Complex customizable dashboards in a matter of hours for real time business

overview

Implemented Examples in Insurance

Page 2: Insurance - Open Source Analytics Dashboards for Real Time Business Overview

• Real time analytics• Computing complex KPIs structure • Ability to drill down and micro segment (open-ended

dimensions, dashboards with tens of dimensions for drilling)• Migration from Excel to online dashboards• Business Intelligence for:

• Real-time view of business status and trends• Understanding departments, agencies, brokers and

agents performance• Upselling & Cross selling new products • Churn reduction

Requirements

Examples of requirements that can be easily solved by using open source analytics

Page 3: Insurance - Open Source Analytics Dashboards for Real Time Business Overview

BI Model = RAW Data Model Entities enriched with

• Client KPIs• Client - Insured Object KPIs• Client - Insured Object - Policy Type

KPIs

+ a lot of monthly statistics at various levels:• Department • Location • Agents • Insurance Product • Insurance Company

Input RAW Data Model

• Clients• Offers • Policies• Rates • Payments • Insurance Objects • Departments• Locations• Agencies• Agents

What BI means for an issuance broker?

Page 4: Insurance - Open Source Analytics Dashboards for Real Time Business Overview

• In the following slide we will present some Policy Dashboards that we implemented for some of our customers

• As long as you have the data within your system, your company information could be easily extracted into customizable dashboards

• You can choose from 140+ different dimensions to drill down on• Imagine building an OLAP Cube for it …

SAMPLE DASHBOARDSANALYTICS APPLIED &

Page 5: Insurance - Open Source Analytics Dashboards for Real Time Business Overview

Income Structure Dashboard

You can structure the polity type in various form by using hundreds of different dimensions, per policy type, per insurer, per department, per location, per agent, per broker, etc

Page 6: Insurance - Open Source Analytics Dashboards for Real Time Business Overview

Customer behavior

You can define various parameters, such as preferred agents, the months with the most customer visits, preferred location, average period between two customer interactions, etc

Page 7: Insurance - Open Source Analytics Dashboards for Real Time Business Overview

Income per location

You can structure the information per year, per monthly, per location, per availability period, per client type, per status, etc

Page 8: Insurance - Open Source Analytics Dashboards for Real Time Business Overview

Due payments history

You can structure the information per year, per monthly, per type of policy, per location, per income level, per type of person, per validity period, etc

Page 9: Insurance - Open Source Analytics Dashboards for Real Time Business Overview

Policy expiry date

You can structure the information per type of business, per location, per customer income level, per type of customer, per validity period, per agent, per agent type, etc

Page 10: Insurance - Open Source Analytics Dashboards for Real Time Business Overview

Possible architecture

Broker BI

Pig

HadoopKibana Elasticsearch

NGINX

Anal

yze

ES JDBC Rirver

Operational SistemOperational SistemOperational Systems

Orchestrate KPI calculation

Azkaban

Page 11: Insurance - Open Source Analytics Dashboards for Real Time Business Overview

• Based on BI index • Nightly completely BI index

constructions • A lot of computed KPIs and

correlated variables included • ~100 Pig scripts building up BI

index • End user does not observe

processing (using elasticsearchalias to point to newly build active BI index)

• Based on near real time index• Raw data• Multiple data

sources• Unified view for

the entities

Analytics availability

near real time index BI index

Page 12: Insurance - Open Source Analytics Dashboards for Real Time Business Overview

• Understand    technology  advantages:  replace  OLAP  cube  with  search  indexes  

• Use  HW  resources:  brute  force    with  map-­‐reduce  

• De-­‐normalization to  do  analytics  on  ES

• Small  work  processing  units:  pig  scripts  /  map  reduce  takes  time  to  execute  and  are  hard  to  debug.  

• Test,  monitor  and  orchestratewith  Azkaban

• Google  it  

What is the recommended development strategy

Page 13: Insurance - Open Source Analytics Dashboards for Real Time Business Overview

EURO IT GROUPABOUT

Page 14: Insurance - Open Source Analytics Dashboards for Real Time Business Overview

• Broad  experience  in  delivering  complex  services  and  solutions  that  integrate  sales,  marketing,  customer  service  and  other  processes  to  large  insurers  and  brokers

• We  have  developed  and  successfully  deployed  a  complete  insurance  solution,  with  modular  architecture,  available  on  premise  &  on  Cloud,  bi-­‐directional  integrated  with  SAP,  Microsoft  &  Oracle

EITG Insurance expertise

INSURANCE EXPERTISE• Website/intranet   development  • Self  service  portals  • Online   policy  selling  • Online   claims  management  • Enterprise  e-­‐learning  and  intranets• Employee  management &  training    • operations  support   systems  development  and  deployment

• Mobility:• Mobile  apps  development,   SFA,   document  management

• Big  data  and  BI  solutions• CRM/  Sales  Force  Automation  • Business   Process  Management  

EITG SOLUTION• Product management• Policy Management• Accounts & intermediaries• Underwriting• Actuarial reports• Billing and collection• Financial Accounting • Reinsurance

Page 15: Insurance - Open Source Analytics Dashboards for Real Time Business Overview

Value proposition

Page 16: Insurance - Open Source Analytics Dashboards for Real Time Business Overview

Euro IT Group Triple Expertise

Page 17: Insurance - Open Source Analytics Dashboards for Real Time Business Overview

• We have broad experience in developing end to end, user friendly mobile applications for the insurance industry.

• Below a use case of sales productivity applications we have developed for several insurance customers

E2E SALES MOBILITY IN INSURANCE

From paper in your hand, to smartphones --to the data on the server

BIOMETRIC SIGNATURE – Capture handwritten signatures o signature pads, smartphones and tablets

Real-Time Customer and Employee Identification & BIOMETRIC VERIFICATION based on a signature

OPTICAL CHARACTER RECOGNITION–

Reduce administrative work and improve data

quality and sales efficiency. Combat

human error.

Page 18: Insurance - Open Source Analytics Dashboards for Real Time Business Overview

Our delivery locationsAll   locations  in  Central  and  Eastern  Europe

Refreshing,  open,  approach  to  client  engagement  and  project  delivery

Daily  direct,  3  hour,   flights

2  hours  time  difference  to  UK

Access  to  world  class  talent

High  quality  English  speakers

Page 19: Insurance - Open Source Analytics Dashboards for Real Time Business Overview

Euro  IT  Group  will  combine  the  relevant  elements  of  our  expertise  and  experience  to  deliver  business  solutions   for  your  needs.

This  engagement  model,  with  its  flexibility   and  adaptability,  means  we  are  ideally  placed  to  solve   any  application  related  problem  as  your  IT  specialist.

Our  core  services  and  core  technologies   are  the  building   blocks   on  which  our  solutions   are  built.

ENGAGEMENT MODELEXPERTISE &

Page 20: Insurance - Open Source Analytics Dashboards for Real Time Business Overview

We  offer  discrete  solutions  to  known  business  challenges  and  build  bespoke  solutions  for  your  specific  requirements.

Our  delivery  models  encompass  the  full  range  of  development  options  and  our  ability  to  engage  from  nearshore  with  UK  presence,  as  required,  gives  you   full  control  over  costs.

We  offer  a  refreshing  approach  to  commercials,  enabled  by  our  unique  structure.

Our  final  building  block  to  deliver  the  right  business  solutions  for  you  is  in  depth  knowledge  of  your  industry   sector.  This  means  we  talk  your   language  and  understand  the  business  impact  of  our   solution.        

Banking Insurance

HourlyT&M

ApplicationDevelopment

.NET, Java,  PHP/LAMP,  C/C++Amazon,Windows  Azure, SalesforceIos, Android,Windows  Phone,  Blackberry,  HTML5

Ruby  onRails, Python,  EmbeddedSoftware,Databases, Sharepoint,  SAP,Microsoft, Oracle,Other Technologies

ApplicationTesting

ApplicationSupport

ITConsultancy

ProjectManagement

BusinessAnalysis

Fixed Price

Nearshore

Agile

System Integration

Information Security

EnterpriseMobility

WebApplications

CRM  &Loyalty

MobileApplications

BusinessIntelligence

Cloud Strategy

eCommerce  Development

CloudMigration

Big  DataConsultancy

Big  Data  Dashboards

Iterative Waterfall Prototyping

Onshore Combined

SLA  driven TeamAugmentation

DedicatedTeam

Leasing ITC Retail eCommerce Travel Healthcare Media

B U S I N E S S S O L U T I O N SIndustry

ExpertiseCommercial

Models

EngagementModels

DeliveryModels

DiscreteSolutions

CoreTechnologies

CoreServices

Page 21: Insurance - Open Source Analytics Dashboards for Real Time Business Overview

CONSOLIDATED NEARSHORING

[email protected] our Insurance Industry Trends Slide Decks

here