| Business Intelligence and Performance Management |
 |
|
|
| Client |
A leading bank in Singapore.
|
| Objective
|
As the company had disparate data sources, they were facing issues of data segregation and duplication across host applications. MphasiS had to develop a single integrated environment representing "one version of the truth".
|
| MphasiS Consulting Solution
|
| The solution involved defining, designing and developing Business Intelligence architecture to meet the above objectives. Activities included :
|
| Extraction of data from the host applications & source systems |
| Cleansing data and applying transformations to arrive at Business Metrics |
| Definition and Identification of Dimensions and Facts |
| Designing of the Dimensional Model |
| Creation of the Consumer Banking Data mart |
| Loading and Validation of the data repository |
| Development of consumer banking reports and supporting SQL queries |
| Technical Architecture for the Consumer Banking Data mart and BI Solution |
|
|
Results
The end state solution resulted in the development of a single data mart that consolidated data from the different sources and was the single environment for historic and current reporting and analytics.
|
| Features included :
|
| Capability to perform focused analysis using drill-down and slice-dice methods |
| Improved targeting of consumers |
| Enhanced campaign management capabilities |
| Integration of all customer Information in a single window |
User access privileges for a secure environment
|
| Back to Top |
![[+] Enlarge this image](javascript:openWin('../images/Tech_Arc_Consumer_Banking_b.gif','win1',640,471)){kind=link}