Prototype Data Mart for the Data Warehouse of a Central Bank in India
Data Warehousing is a key technology for advanced Decision Support Systems and Executive Information Systems. Today, it is imperative to establish a link between business strategies and information technology. Data Warehousing can create this link.

The need for a Data warehouse is driven by factors like.

• Proactive strategies and rapid decision-making.
• Lots of PC-based or small server systems obtaining extracts of data incapable of presenting a holistic view of the entire gamut of information.
• Same data present on different systems, in different departments and users may be unaware of this fact.
• Difficulty in getting timely, meaningful information.
• Multiple systems giving different answers to the same business questions.
• Limited analysis by decision makers and policy planners due to non-availability of sophisticated tools and easily decipherable, timely and comprehensive information.

A Data Mart may be viewed as a subset of a Data Warehouse dealing with data restricted to a specific department, business process or section of the enterprise. C-DAC has developed a prototype Data Mart for the Reserve Bank of India (RBI), which is the central bank of India. It is used for the purposes of trend analysis and forecasting of various banking variables & macro-economic indicators, which facilitate planning and policy formulation more effectively and efficiently.

Salient Features:

• Houses certain banking statistics data of all the Nationalized, Commercial and Co-operative Banks in India
• Used for Trend analysis and Forecasting of various banking variables & macro-economic indicators
• Enables the top management to analyze the data to aid in framing credit and monetary policies and strategic planning.
• Used by the Internal Departments of the RBI such as DBOD, DEAP, CPC for performing various analysis which help in regulating the Indian Economy and for Parliamentary queries.
• Used by various External Agencies such as the Bureau of Economics and Statistics, State Governments, Central Statistical Organization.