Prototype Data Warehouse to Analyze Foreign Currency Transactions for Business Growth in Banks

Abstract

Data Warehouse helps the decision makers of an organization in taking decisions that helps in improving the business and profitability by consolidating data from many heterogeneous sources. In this paper, we worked on foreign exchange transactions, which is one of the important business lines of the bank in terms of profitability. We developed a model for analysis of these transactions using a multi-dimensional model especially star schema. ETL transformations have been designed based on the business requirements in order to convert operational data pertaining to foreign currency transactions into the proposed model. In this work we also build a cube and analyzed against the business requirements for which the model has been designed .