ICICI BANK DATA WAREHOUSE CASE STUDY
Introduction
ICICI Bank is India’s largest private sector bank. Thebank has a network of 4,050 branches and 12,919ATMs and offers customers a robust Internet bankingsolution. The bank has a presence in 19 countries,including its home market in India(ICICI). ICICI Bankoffers a wide range of banking products and financialservices to corporate and retail customers through avariety of delivery channels and through its specializedsubsidiaries and affiliates in the areas of investmentbanking, life and non-life insurance, venturecapital, and asset management.
Before discussing the current data warehouse architecture in place at ICICI Bank, issues associated with it, especially due to immense data growth and different modalities of data sources, it would be appropriate to have a quick look at the data warehouse history and architectural framework and how ICICI Bank’s data warehouse has evolved over the years. Back in 2008 ICICI Bank used Teradata and was dependent on Teradata for its data warehouse. Back in those days the size of the data warehouse was 3TB. Because of the dramatic growth in the amount of data, user population and the source stations coupled with cost of scaling and maintenance as well as system availability,posed a problem for the bank in using their legacy data warehouse solution. The bank felt that its legacy data warehouse solution posed scalability issues and one of the major issues that bank faced was with their current
What information is accessible? The data warehouse offers possibilities to define what’s offered through metadata, published information, and parameterized analytic applications. Is the data of high value? Data warehouse patrons assume reliability and value. The presentation area’s data must be correctly organized and harmless to consume. In terms of design, the presentation area would be planned for the luxury of its consumers. It must be planned based on the preferences articulated by the data warehouse diners, not the staging supervisors. Service is also serious in the data warehouse. Data must be transported, as ordered, promptly in a technique that is pleasing to the business handler or reporting/delivery application designer. Lastly, cost is a feature for the data
ICICI Bank is the second largest bank in India based on market share and total assets
The state of affairs in the field of data warehousing and offers a variety of approaches to
Google is able to use data warehousing to improve its business. A data warehouse is a logical collection of data that supports business analysis activities and decision making tasks. Google can use a data warehouse to store information just like a database is able to, but in an aggregated form more suited to supporting decision-making tasks.
There is currently a very strong need for a defined and standardized process to request work related to the data warehouse. Not only does the work requests need to be standardized the development methodology needs to be defined with an agile approach fitting best with the direction and culture of the company. By clearly defining steps to both of these things the efficiency of the team will be greatly improved. They should be able to complete more projects as well as improve the quality of the products they are producing. With less mistakes and errors and more work being completed the return on investment for the data warehouse technology will be greatly increased.
Many corporations are experiencing significant business benefits of using data warehouse technology. Users report gains in market competitiveness through increased revenue and reduced costs through information management. Data warehousing is thus a major issue within most organizations, and thus the development of a data warehouse with a strong base is essential. This paper aims to present the important concepts of Data Warehousing such as Data Warehousing tools and the benefits of Data Warehousing, that a manager must understand in order to execute a successful Data Warehousing project in his/her company.
Data warehouse are multiple databases that work together. In other words, data warehouse integrates data from other databases. This will provide a better understanding to the data. Its primary goal is not to just store data, but to enhance the business, in this case, higher education institute, a means to make decisions that can influence their success. This is accomplished, by the data warehouse providing architecture and tools which organizes and understands the
Data warehouse helps in solving and managing the data from various sources and transactional systems with more speedy and efficiently, and converts those data into practical information. Along with, data warehouse serves in processing of large and complex queries in a highly-efficient manner.
The purpose of a data warehouse is to make the company’s information accessible and consistent. They need to have the information immediately available and in the same format. Warehousing is of no benefit to a company if they have to wait any length of time to receive the data. A warehouse has to be an adaptive and durable source of information for the business. The warehouse has to be flexible to meet the needed changes of a business, as the business grows; it is possible that additional information will need to be collected. The warehouse needs to have the ability to expand to meet the needs of the business. Warehousing would not be beneficial to a business if they have to seek a new warehouse source each time a change was needed; it would be costly for a business. A data warehouse must be a secure stronghold that protects the information, which is regarded as an asset to the business. In today’s society it this the utmost concerned of a business to make sure that their systems are not easily hacked by outsiders and their customer’s data is secured. Lastly, a warehouse is considered the foundation for decision making. It is the data that is retrieved from the system that is compiled for presentation to the decision makers of the company.
Data warehousing is a system that holds the data of an organization collected through various channels and the data is processed through various analytical tools to generate reports for the business users. This paper discusses the data warehouse concept along with the origin of the data warehouse and the current trends of data warehousing. Various steps involved in the development of the data warehousing project are discussed in this paper. This paper also lists out the challenges encountered while planning, designing and implementing data warehouse projects and the applications of the data warehousing. This paper concludes by discussing the future developments in the data warehousing.
The data warehouse is a comprehensive source of data generated by the business, covering long periods of time.
21 7.1)The Role of Reserve Bank of India (RBI) – Banker’s Bank: ......................................................... 23 7.1.1)Main Objective: ................................................................................................................. 23 8)Co‐operative Banks: ........................................................................................................................ 26 8.1)There are two main categories of the co‐operative banks. ....................................................... 27 8.1.1)Features of Cooperative Banks .......................................................................................... 27
HDFC Bank is headquartered in Mumbai. The Bank at present has an enviable network of over 455 branches spread over 207 cities across the country. All branches are linked on an online real-time basis. Customers in 90 locations are also serviced through Phone Banking. The Bank’s expansion plans take into account the need to have a presence in all major industrial and commercial centers where its corporate customers are located as well as the need to build a strong retail customer base for both deposits and loan products. Being a clearing / settlement bank to various leading stock exchanges, the Bank has branches in the centers where
2005 ICICI acquired Investitsionno-Kreditny Bank (IKB), a Russia bank with about US$4mn in assets, head office in Balabanovo in the Kaluga region, and with a branch in Moscow. ICICI renamed the bank ICICI Bank Eurasia.
It is the foremost monitoring body in the Indian financial sector. The nationalized banks (i.e. government-owned banks) continue to dominate the Indian banking arena. Industry estimates indicate that out of 274 commercial banks operating in India, 223 banks are in the public sector and 51 are in the private sector. The private sector bank grid also includes 24 foreign banks that have started their operations here. Under the ambit of the nationalized banks come the specialized banking institutions. These co-operatives, rural banks focus on areas of agriculture, rural development etc.,