Client Business Insights & Data Analytics for a Leading Bank
Case Studies
Challenges & Solutions
Technical Environment
Results
Executive Summary
Client
Government Banking Administration
Industry
Government, Banking, Financial Services, & Insurance
Business Problem
A government banking administration aimed to improve business with the help of customer retention techniques and targeted sales by utilizing existing data through analytical insights. The banking administration wanted to implement a tool to aid in data quality assessment and maintenance of completeness, consistency, timeliness, and data accuracy.
Outcome
- 30+ Analytical Dashboards
- Improved inputs for product marketing strategy
- Improved customer matching to product offers
- Markedly improved ATM cash levels to meet customer needs
Challenges
- Insufficient information in current reports.
- Customer retention KPI needed improvement.
- Targeted banking products were not reaching the appropriate customers.
- Unable to load optimum cash in bank ATM machines due to lack of sufficient KPIs.
- Cash blockage with excessive cash loading to ATMs.
Solutions
- After performing requirement assessment, OTSI implemented a SAS solution to aid in quality assessment and maintenance of completeness, consistency, timeliness and accuracy of data.
- Designed a solution to connect to leading databases including SAP environment.
- Identified, profiled and validated data by cross-relating identified sources for supporting model implementation.
- Built analytical models on training data and performed advanced analytics to create identity matches between banking clients and banking solutions at ATMs.
Technical Environment
- SAS data management with standard data surveyor for SAP
- SAS visual analytics (VA)
- SAS enterprise miner
- SAS enterprise guide
Results
- 30+ Analytical Dashboards
- Improved inputs for product marketing strategy
- Improved customer matching to product offers
- Markedly improved ATM cash levels to meet customer needs