The Impacts of Implementing a Data Warehouse in the Banking Industry

Powerful Essays
The impacts of implementing a data warehouse in the banking industry

Data warehousing in the financial sector
Introduction

In the modern banking and financial sector, there is keener and stronger competition and many enterprises are much more eager to get immediate and accurate information to make better and faster decisions. Furthermore, with many banks fighting to capture new customers and the rapidly growing need for larger amounts and more specific information, traditional databases are incapable of effectively handling the demands of increasing online information retrieval, access, update, and maintenance (Hsin-Ginn Hwang et al). This inability greatly impacts businesses in a way that the management level cannot utilise internal data efficiently and effectively to assist reliable decision-making in a timely manner. As a result, it is such a critical issue for every business to seek for ways and/or means to access, store, maintain, and utilise the massive data efficiently. The method that best fulfils the needs of the business is a data warehouse.

A data warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data in support of management's decision making process (Inmon). It also acts as a specially prepared repository of data created to support decision making. Data is extracted from source systems, cleaned, scrubbed, transformed, and placed in data stores (Gray and Watson 1998). Data warehousing is near the top, if not at the top, of most companies’ strategic IT initiatives. These repositories of data have great potential for providing insight into client behaviour in client-to-business e-commerce, implementing customer relationship management strategies, and supporting comprehensive performance measurement systems.

Within the financial and banking industry, it is becoming evident that corporations are realising the importance of a customer-orientated strategy that places the customers at the centre of all aspects of



References: 2. Cooper, B. (2000) Data Warehousing Supports Corporate Strategy at First American Corporation MIS Quarterly, Vol 24 No. 4, pp 547-567. 3. Curtis, M.B., Joshi, K 4. Goodhue D. L., Wybo M.D., Kirsch, L. J. (1992) The Impact of data integration on the costs and benefits of information systems, MIS Quarterly, Vol. 16, No. 3. pp. 293-311. 5. Gray, P. and Watson, H.J. (1998) Decision Support in the Data Warehouse. Upper Saddle River, NJ; Prentice-Hall PTR. 6. Grover, V 7. Hsin-Ginn Hwang et al. (2004) Critical factors influencing the adoption of data warehouse technology: a study of the banking industry in Taiwan, Decision Support Systems 37, 1 – 21. 9. Kettunen, Juha; Kantola, Ismo (20050 Campus-Wide information systems, Volume 22, Number 5, pp. 263-274. 10. Markus, M. L. (1983) Power, politics, and MIS implementation, Communications of the ACM(26:6), pp. 430-444. 11. Wells, N., Wolfers, J. Finance With A Personalised Touch, Communications of the ACM , Vol. 43, No. 8, 2000, pp 31-34. 12. Wixom, B. H., Watson, H. J. (2001) An Empirical Investigation of the Factors Affecting Data Warehousing Success, MIS Quarterly, Vol. 25, No. 1., pp. 17-41.

You May Also Find These Documents Helpful

  • Powerful Essays

    Data Warehouse

    • 4241 Words
    • 38 Pages

    Data Warehouse Concepts and Design Contents Data Warehouse Concepts and Design 1 Abstract 2 Abbreviations 2 Keywords 3 Introduction 3 Jarir Bookstore – Applying the Kimball Method 3 Summary from the available literature and Follow a Proven Methodology: Lifecycle Steps and Tracks 4 Issues and Process involved in Implementation of DW/BI system 5 Data Model Design 6 Star Schema Model 7 Fact Table 10 Dimension Table: 11 Design Feature: 12 Identifying the fields from facts/dimensions: MS: 12 Advanced…

    • 4241 Words
    • 38 Pages
    Powerful Essays
  • Powerful Essays

    DATA WAREHOUSES & DATA MINING Term-Paper In Management Support System [pic] Submitted By: Submitted To: Chitransh Naman Anita Ma’am A22-JK903 Lecturer 10900100 MSS ABSTRACT :- Collection of integrated, subject-oriented, time-variant and non-volatile data in support of managements decision making process. Described as the "single point of truth", the "corporate memory", the sole historical register of virtually all transactions…

    • 2771 Words
    • 12 Pages
    Powerful Essays
  • Better Essays

    1.0 Introduction As part of their lives, individuals are engaged in generating wealth and using this for their own prosperity.The management of this created wealth is an important issue, as individuals are expected to also manage their lives with this wealth. It is the concern of this study to investigate how wealth is perceived by wassiyah method and how it is distributed by individuals in the form of inheritance. Islamic theory of wealth provides useful guidelines in relation to wealth ownership…

    • 2515 Words
    • 11 Pages
    Better Essays
  • Powerful Essays

    Information Systems Management Research Project ON Data Warehousing and Data Mining Submitted in Partial fulfilment of requirement of award of MBA degree of GGSIPU, New Delhi Submitted By: Swati Singhal (12015603911) Saba Afghan (11415603911) 2011-2013…

    • 2521 Words
    • 11 Pages
    Powerful Essays
  • Best Essays

    Data Warehouse and Crm

    • 3661 Words
    • 15 Pages

    More than Data Warehouse- An insight to Customer Information Ritu Aggrawal – agg_ritu@rediffmail.com Deepshikha Kalra -deepshikha_ishan@yahoo.co.in working with MERI affiliated to GGSIPU, Delhi ABSTRACT The business requirements of an enterprise are constantly changing and the changes are coming at an exponential rate. Like advances in Information Technology have helped companies to quickly match competition. As a result, product quality and cost are no longer significant competitive…

    • 3661 Words
    • 15 Pages
    Best Essays
  • Powerful Essays

    What Is a Data Warehouse ?

    • 2434 Words
    • 10 Pages

    Question 1 What is a data warehouse? What problems does it solve for a business? A data warehouse is a place where data is stored for archival purpose, analysis purpose. Usually a data warehouse is either a single computer or many computers servers tied together to create one giant computer systems. Data warehouse solve a lot of problems to companies as it helps to structure files and avoid unnecessary duplication of data. Data warehouse also allows to easily updating data and encourages management…

    • 2434 Words
    • 10 Pages
    Powerful Essays
  • Powerful Essays

    Creating a Data Warehouse

    • 3953 Words
    • 16 Pages

    Creating a Data Warehouse Introduction Data warehouses are the latest buzz in the business world. Not only are they used to store data for reporting and forecasting, but they are part of a decision support system. There are many reasons for creating and using a data warehouse. The data warehouse will support the decisions a business needs to make, usually on a daily basis. The data warehouse collects data, consolidates the data for reporting purposes. Data warehouses are accompanied…

    • 3953 Words
    • 16 Pages
    Powerful Essays
  • Powerful Essays

    CHAPTER 3 DATABASES AND DATA WAREHOUSES Building Business Intelligence CONTACT INFORMATION: Stephen Haag is the primary author of this chapter. If you have any questions or comments, please direct them to him at shaag@du.edu. THIS CHAPTER/MODULE IN SHORT FORM… This chapter introduces your students to the vitally important role of information in an organization and the various technology tools (databases, DBMSs, data warehouses, and data-mining tools) that facilitate the management…

    • 8422 Words
    • 34 Pages
    Powerful Essays
  • Satisfactory Essays

    information collection, storage, processing and transmission and distribution technology have influenced all aspects of banking activity. And was regard as the main driving forces for the changes in banking industry. In my opinion, the technology influences the banking industry, mainly in the following six aspects: 1. Technology is influencing competition and the degree of contestability in banking. Due to the development of technology, bank’s superiority in information is deteriorated. Entry barrier have…

    • 650 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Erp Data Warehouse

    • 447 Words
    • 2 Pages

    IST/ERP 444 Data Warehouse Homework 1: Definition of Data Warehousing Name: Rallapalli Venkata Pavani Search any resource (Books, Web Sites, Papers, etc.) to find three definitions for Data Warehousing. Include the detailed information (Title, authors and the source of the definitions. For example: “Data warehousing is a collection of decision support technologies, aimed at enabling the knowledge worker (executive, manager, analyst) to make better and faster decisions.”…

    • 447 Words
    • 2 Pages
    Satisfactory Essays