Data Warehousing & Business Intelligence solution for a Market Research & Analysis industry leader.

Challenge

Leading Market Research & Analysis organization needed a Business Intelligence solution to analyse Automotive sales data and present it to a broad base of subscribed users (Auto makers across the globe), 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 a 2-terabyte IBM DB2 Universal Database containing customer account and transaction data.
• iGlades utilized its AST Delivery Methodology to design the data models, cloud-based Enterprise Data Warehouse.
• Systematic processes were configured to manage metadata information.
• Data from multiple source systems i.e. web, legacy systems, ERP was loaded into the cloud-based Data Warehousing 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 - Amazon Redshift
• Data Integration (ETL): Talend 3.x
• Business Intelligence - Apache Spark 3.x, Hadoop 3.x