BUSINESS INTELLIGENCE IN BANKING INDUSTRY INTRODUCTION
OBJECTIVES OF STUDY
CONCEPT OF BUSINESS INTELLIGENCE The use of Business Intelligence in every business function is growing. As the volume of transactional data goes up, insights hidden into this data can be mined using business intelligence. Banks have huge volumes of transactional data gathered over a period of time. The trends and patterns of the transactions can throw up many new perspectives and foster a data driven decision making. Business Intelligence in banking can be unveiled by asking these four questions: What business requirements? •All business decisions have a context and the data needs to be organized and mined for this context
1.To focus on the methodology of BI, independent of the tool used 2.To demonstrate the potential of BI 3.To focus on answering business, not delivering the reports, From gather business requirements to applying the technology, there is a unwavering focus on decision making
RESEARCH METHODOLOGY EXPLORATORY AND EXPERIENTIAL
Which challenges to solve? • Every solution has a cost. Prioritizing challenges for the highest business return is the key
Who champions the cause? • Analysis is not as simple as it looks. Gathering data, keeping the analysis updated and assisting users to take data driven decisions demands a meticulous and a great amount of effort.
• Deposits with a focus on Term Deposits • Loans with a focus on Cash Credit Accounts • Cash Management
• The starting point could be vague, there could be a lot of grey areas in the way.
BUSINESS INTELLIGENCE LIFE CYCLE
Analytics to drive actions • Action Oriented • Focused for decision
Business Intelligence Solution • Multi dimensiona l decision oriented
FINANCIAL, SOCIAL and ORGANIZATIONAL benefits are seen. Specifically in banking some of the areas covered are as follows: •Movement in CASA, Deposits •Analysis of usage of ATMs •Non-Performing Assets •Analysis of Demand & Term Loans •Priority / Weaker Section Exposure •Branch-wise Product Sales •Customer segmentation and risks •Top Depositors report •Earnings in Insurance Commission, PAN Card Commission, Franking •Employee productivity
CASE STUDY
How to do BI – the approach?
• Daily Transaction
CONTRIBUTION
•Installation and Configuration of BI platform •Requirement Gathering •Data Modelling •ETL •Information Delivery •Training to IT and Business Users
A detail report prepared from the fresh and in-depth insights helped the Bank to identify several opportunities to improve its performance by multifold. The system of dashboards and alerts gave a complete control to users and helped them act on opportunities to increase the profitability.
REFERENCES • Kimball’s – Datawarehouse tool kit • Business Research Methods Cooper, Schindler, Sharma • Carlo D'Amico - Web site and Portfolio
introduction objectives of study contribution ... -
CONCEPT OF BUSINESS INTELLIGENCE. The use of Business Intelligence in every business function is growing. As the volume of transactional data goes up, ...