Scribd Logo
Upload

Welcome to Scribd!

  • 2K views

    Business Intelligence PPT FINAL

    Uploaded by

    Soumabrata Dasgupta
    This document discusses the need for business intelligence (BI) at YES Bank. It outlines challenges like inconsistent data and lack of integration between systems. YES Bank developed an in-house BI tool called Kaleidoscope to address these issues. Kaleidoscope extracts data from multiple sources, links business and IT functions, and provides basic and advanced analytics. It improved information security, created a single customer view, and automated reporting. YES Bank realized cost savings of 6 crores annually through increased productivity and reduced manual work with the new BI system.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPTX, PDF, TXT or read online from Scribd

    Business Intelligence PPT FINAL

    Uploaded by

    Soumabrata Dasgupta
    2K views22 pages
    This document discusses the need for business intelligence (BI) at YES Bank. It outlines challenges like inconsistent data and lack of integration between systems. YES Bank developed an in-house BI tool called Kaleidoscope to address these issues. Kaleidoscope extracts data from multiple sources, links business and IT functions, and provides basic and advanced analytics. It improved information security, created a single customer view, and automated reporting. YES Bank realized cost savings of 6 crores annually through increased productivity and reduced manual work with the new BI system.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document discusses the need for business intelligence (BI) at YES Bank. It outlines challenges like inconsistent data and lack of integration between systems. YES Bank developed an in-house BI tool called Kaleidoscope to address these issues. Kaleidoscope extracts data from multiple sources, links business and IT functions, and provides basic and advanced analytics. It improved information security, created a single customer view, and automated reporting. YES Bank realized cost savings of 6 crores annually through increased productivity and reduced manual work with the new BI system.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    2K views22 pages

    Business Intelligence PPT FINAL

    Uploaded by

    Soumabrata Dasgupta
    This document discusses the need for business intelligence (BI) at YES Bank. It outlines challenges like inconsistent data and lack of integration between systems. YES Bank developed an in-house BI tool called Kaleidoscope to address these issues. Kaleidoscope extracts data from multiple sources, links business and IT functions, and provides basic and advanced analytics. It improved information security, created a single customer view, and automated reporting. YES Bank realized cost savings of 6 crores annually through increased productivity and reduced manual work with the new BI system.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    of 22

    Business Intelligence

    @
    YES BANK
    Presented by:
    Khyati Shah
    Loveleen Gill
    Shachee Swadia
    Soumabrata Dasgupta
    Zafar Siddiqui
    Agenda
    • About the company

    • BI in Banking

    • Business Challenges

    • Need for BI in Yes Bank

    • BI Tool

    • Advantages/Disadvantages

    • Recommendations

    2
    Yes Bank
    • Founded in 2003-04 by Kapur duo
    • Headquarters in Mumbai, India
    • Follows a Knowledge driven approach
    – Development and Knowledge Banking Division

    • Awarded
    – ‘The most innovative bank in India’ – year 2008

    – ‘The most sustainable bank of India’ – year 2009

    3
    Verticals@ Yes Bank

    Yes Bank

    Corporate and Corporate Branch Investment Financial Transactio


    Wealth
    Institutional
    Banking Finance Banking Management Banking Markets n Banking

    4
    Business Intelligence
    BI refers to application and technology, which is used to gather to provide
    access to, and analyze data and information about the company operations

    It is an architecture and a collection of integrated operational as well as


    decision-support applications and databases that provide the business
    community easy access to business data

    BI in a bank bridges a legacy database with departmental databases, giving


    branch managers and other users access to BI applications to determine
    who the most profitable customers are or which customers they should try
    to cross-sell new products to.

    The use of these tools frees information technology staff from the task of
    generating analytical reports for the departments and it gives department
    personnel autonomous access to a richer data source.
    5
    Evolution of BI

    6
    BI in Banking
    Historical analysis for future strategies
    ●

    Chronological Analysis Derivative indicators assessed over time


    ●

    CRM Create a client database


    ●

    Assists a firm administer client relationship in a planned manner


    ●

    Performance intermittent evaluations to take remedial actions in case of


    ●

    Accounting discrepancies

    Banks relocate, allocate, buy and sell financial risks


    ●

    Risk Management Assessment of diverse risks for accuracy and analytical competence
    ●

    information centric regulatory needs like SEBI clause 49, Basel norms
    ●

    Regulatory Conformity Precise and organized compilation of data for action


    ●

    7
    Business Challenges
    • Inconsistencies and non uniformity of data
    – Different departments pulled out reports from their systems and forward it to
    their stakeholders

    • Lack of a dedicated staff


    – Hierarchical report generation process
    – Delayed report generation for users
    – Incomplete data

    • Information Security
    – Anyone could access the data anytime as information was available on a FTP
    – Distribution of information reports through E-Mails 8
    Business Challenges
    • Manual & inefficient processes
    – Eg. Nearly 200 reports were prepared manually by users in various departments
    which made the bank operations unproductive and costly

    • Lack of integration between systems


    – Difficult to generate certain MIS reports resulting in loss of business opportunities

    • Extracting intelligent information in real time was a challenge

    • High competition
    – Need for specific customer requirements & behavioral patterns for cross selling, up
    selling , etc.

    9
    Answer to the Challenges

    10
    Make or Buy Analysis
    • Constraints of ‘Buy’
    – Recession and Budgetary constraints
    – Uneconomical and difficult ROI
    – High implementation costs

    • Motivation for ‘Make’


    – Low Cost
    – Customizable (Enhancements)

    11
    Kaleidoscope
    • A home grown BI Solution

    • Partnership of Business and IT functions by development of BICoE

    • In-house expertise without any implementation partner


    – Freeware LogiXML used as a reporting frontend
    – Integrated with custom built application

    • Fast Deployment within 2 months

    12
    Why Kaleidoscope?

    13
    4 Phases : Kaleidoscope
    1. Extracting information from multiple MIS’s
    – Role based access feature

    – Actionable in nature and help teams take productive decisions

    2. Interlink the BI and BPM Solution

    3. Basic and flexible analytics

    4. Include advanced analytics


    – What if scenarios

    14
    Kaleidoscope Team

    BICoE Team

    Outsourced Executives Each Business Unit Programme Manager

    DB Structures VB Scripting Technical Analyst Business Analyst


    Project Manager

    15
    Technical Aspects
    • IBM Power5 based database servers and xSeries application servers
    • Windows Server 2003 Enterprise Edition
    • Front end reporting: LogiXML
    – Web based reporting server

    – Interactive analysis (dashboard, charts, grids)


    – Enables developers to rapidly build sophisticated custom applications
    through hundreds of pre-built elements
    – No user fees licensing

    16
    17
    Advantages - Kaleidoscope
    • Information Security
    – Relevant, meaningful and accessible data

    – Everyone received common data


    – No inconsistencies in data

    • Single view to the customer


    – Products bought by the customers appear in a single screen

    • Smooth report generation process


    – Relevant data for MIS processing

    – Earlier with MIS the delay was of 24 hours


    18
    Advantages of BI to Yes Bank
    • Extended to the Lowest User not just Power Users
    • Automation eradicated the manual errors in reports
    • High Cost Savings – about 6 Crores
    – Automation
    – Productivity Gains (2300 users of the system)
    – In-house Product
    – Release of FTE dedicated to MIS analysis

    • Customer One View


    – Enabled superior service
    – Better Cross Selling
    – Deepening Relationship
    19
    Recommendations
    • The bank was awarded the Financial Insights Innovation
    Award for innovation in Business Intelligence at the Asian
    Financial Services Congress
    • YES Bank is a Silver EDGE (2010) winner.

    20
    21
    References
    1. Mr. Shankho Gupta – Branch Manager, YES Bank
    Bangalore

    2. http://www.yesbank.in/

    3. http://www.yesbank.in/it.htm

    4. http://business.mapsofindia.com/business-intelligence/
    for-banking.html

    22

    You might also like