|
Data Warehousing solution for a multinational Swiss Bank.
Challenge
Leading Swiss Bank needed a cloud-based Data Warehouse solution to access business performance management information and
present it to a broad base of users, with different requirements, via an easy-to-use interface.
Solution
- iGlades designed the data warehouse for harnessing the BI, anchoring on iGlades`s AST delivery Model (AST).
- The powerful business intelligence application runs against big data containing customer account and transaction data.
- iGlades utilized its AST Delivery Methodology to design the data models, data mart architecture and the enterprise data
warehouse.
- Systematic processes were configured for managing metadata information
- Data from multiple source systems i.e. web, legacy systems, ERP was loaded into the cloud-based Data Warehouse
using Talend ETL.
Benefits
- Business Intelligence application provides easy accessibility and reporting information to manage channels of
distribution,
- Provides user-friendly interface to track product profitability and market effectively to its customers
- Aligns the goals of the bank to provide managements on risk and profitability analysis, minimize attrition,
perform one-to-one marketing and strengthen customer relationships.
Technologies used:
- Data Warehouse and Data Repository - Amazon Redshift
- Data Integration (ETL): Talend 3.x
- Business Intelligence - Apache Spark 3.x, Hadoop 3.x
|
