The forex business unit of a leading foreign bank in India deployed QlikView as a BI tool of choice to gain insights from their business. The bank’s forex and international trade division offers integrated cash management, trade and securities and fund services to multinational corporations, financial institutions and public sector organizations around the world. The management wanted a single platform to integrate data and provide analysis to its business users.
The GainInsights team developed and deployed 20+ QlikView apps and scorecards across multiple areas, including FX trading platforms, FX e-commerce, segment / region analysis, and performance management.
The business users in the forex business unit benefited significantly from the single, holistic BI environment. It provided them a 360o view of trade data from various tools across regions. Scorecards were created as an effective performance management tool to monitor sales persons’ trade details. The BI deployment included a complete integration of disparate data sources – SSAS, SQL Server, Oracle, Excel, XML, etc.
Dashboards were loaded with transactional and historical data with reports exceeding data of 120 million records and tables of 200 columns. Due to huge volumes of data, QlikView server clustering was implemented to offer a highly scalable solution. The QlikView applications were also integrated with their existing systems using single sign-on functionality.