Banks that face higher operational/credit risk loading, such as credit card companies in our case HFC Bank, often make KPI-related data available weekly. In HFC Bank, requirement was to provide a daily analysis of data.

This fast pace requires analysts to use IT systems to process this large volume of data.

To understand and maintain the profitability of its credit card business, the company maintained a vast amounts of transaction and customer information.

However, its existing Excel-based data tools were lacking key functionalities and did not support the depth and complexity of business insight necessary to grow the business.

To keep its credit card business from stagnating, the company needed more detailed transaction data to find ways to both increase its customer base and derive greater profits from existing customers.
 

Key objectives were:

• Improve effectiveness of marketing programs with accurate information about customer behaviour, card usage and risk potential.

• Support of improved decision-making across the organisation.

• Provide a consistent single view of credit card data.

• Near real-time view of marketing campaign performance

The new data warehouse was designed using our Dimensional Modelling techniques. The data from POS network, was extracted on a 4 hourly basis and transformed to a consistent format. End users needed a fast response to their queries. To satisfy this requirement, the data warehouse design accommodated consolidation of pre-aggregated and pre-summarised data for ease of retrieval. By identifying key business performance points, the data mart was designed to simplify reporting.

 

This page last updated on 21 June 2008 - ©1996-2008 Kariminia LTD All Rights Reserved

To discuss how we can help your organization to achieve rewarding business solution with maximum efficiency

Call us at (+44) 01202 862 640 or send us an eMail.
 

4Client Successes DW