DWBI

1
(No Transcript)
2
DWBI What drives it

• According to Gartner, Inc., the average
  enterprise has 14 different databases and spends
  60 to 70 percent of its application development
  creating ways to access that data. Financial
  services companies have more, and their demands
  are greater. They also require the ability to
  combine real-time data with information they
  should already know to make real-time decisions.

According to Gartner, the big four now own
two-thirds of the BI market. Gartner Research
Director Kurt Schlegel writes that, The
consolidation in the market has not simplified
vendor selection decisions if anything, it has
made them more complicated because the
acquisitions have thrown many existing product
road maps into confusion. These acquisitions have
also caused the mega-vendors to focus on product
integration versus BI innovation - as they watch
the TCO and time-to-value of their BI solutions
go down the drain.
3
How Enterprises think of DW BI
4
The Information predicament in a Bank
INTELLIGENCE for a profitable future
FUTURE
What NEXT?
Actionable KNOWLEDGE
What strategies can I apply?
PRESENT
Why did it happen?
INFORMATION processing
BUSINESS VALUE

• Identify the correct sales channels for different
  customer segments.
• Identify the right target marketing strategy
• Identify the correct collection strategy.

• Integrated channels targeting unified messages to
  customers powered by a single view of the
  customer
• Effective cross-sell and up-sell leading to
  increased profitability
• Predict and proactively manage churn,
  delinquency, fraud.

What data do I have? How can it help me see what
happened?

• Am I efficiently utilizing the right sales
  channels?
• Is my marketing spend aligned to bring on
  profitable customers?
• Is the collections dollars appropriately
  channelized to minimize delinquency?

The Banking DATA deluge
PAST

• What is the effectiveness of different sales
  channels in my bank?
• Who are the most profitable customers in my bank?
• Are my delinquencies under control?

DATA INFORMATION
KNOWLEDGE
INTELLIGENCE
5
The Traditional Approach
6
The Traditional Approach
Delivery
Focus
Validation
Value
7
The Solution Approach
8
Benefits
Delivery
Focus
Validation
Value
9
Case Study BI Implementation in a Mid sized Bank
10
The iCreate Solution Approach
11
Handling the Downsides

• Core System Knowledge
• Functional Solutions

• Reusable dimensions
• Master data management techniques

The Solution Centric Approach

• Tailor made solutions
• Organization Policies

12
Summary

• Gartner Inc. says
• As BIS firms get a grip on the more mundane
  problems of aggregating and reporting, they need
  to both extract more value from the BI tools they
  own (and there are often many of them) and
  prepare for a BIS world that is more volatile,
  more uncertain and more competitive.

13
Presenting Bizcore
14
A TYPICAL BI PROJECT TAKES UPTO 20 MONTHS
20 MONTHS
15
A DEPLOYMENT TAKES
ONLY 20 WEEKS !
16
(No Transcript)
17
Bizcore Suite
Customer / Channel Intelligence
Central Bank Reports
Charts Dashboards
OLAP Engine
L3 Data Marts
Reporting Engine
Roles
L2 Operational Data Store
L1 Staging Area
Operational / Analytical Reports
Risk / Fraud
Parameters Metadata
Role / User Management
Data Governance
Performance Management
18
THANK You. Questions?Email Naren.ns_at_icreate.in
19
About Us
Focus Expertise
Customers we work with

• Business Intelligence, Reporting, Analytics and
  Enterprise performance management for the BFSI
  segment
• Wide-ranging transactional systems knowledge for
  BFSI (Core banking etc.)

iCreates commitment to delivering to set
project schedules irrespective of the obstacles
is amazing and a contrast to other vendors -
Michael Kokkinos, NBG (Cyprus)
NBK looks at iCreate as a service provider
partner in its journey for Change - Hani Khalil,
NBK
Products and Tools
The Right Partner

• Healthy financials strengthened by funding from a
  leading US based VC firm
• Presence in Africa, APAC, Middle East Europe
• World Headquarters in Bangalore, India
• 100 Banking technology professionals

• Integrated Reporting, BI, Analytics EPM product.

• BFSI Industry Data Models, CBS adapters

20
Mitigation

• Core Systems Knowledge
• Domain Expertise
• Functional solutions and BI implementation
  expertise
• Master data Management techniques

21
Benefits

• Focus on particular business area/problem
• Short build and implementation time
• Value addition evident within a short span of
  time
• Business users able to articulate requirements
  effeciently
• Ability to choose the appropriate technology
  platform for each solution

22
Case Study BI Implementation of

• Had
• Comprehensive DW encompassing all products of the
  bank
• Aggregated information stored in a Standard
  data model
• Needed
• MIS Scorecard and Performance reporting pack
• Shortfalls of DW
• Most financial dimensions available , however
  structure not friendly to reg. reporting
• Long load times (leading to delayed reporting
  cycles)

23
The iCreate Solution Approach

• Requirement Analysis - 2 weeks
• Build 2 Weeks
• Data Model and ETL layer
• Reporting Pack (15 reports)
• Testing and Validation 3 weeks
• Total End-to-End Implementation 7 weeks