Financial Service

5 May 2022
Financial Service

Overview:

A private goal loan financial services had collected data for about 5 years and wanted to analyse their sales and what they could have done to increase the customer sales with them. Since Covid hit, there were a number of customers who have availed the loan and the reporting has been in excel. The manager received at least 30-40 reports every month overwhelming him to a large extent.

Challenge:

The manager wanted to create a process which gave birth to automated reporting. The 30-40 reports had many duplicate metrics and sometimes the numbers did not tie up at all. The consumer behaviour dashboard was the most important one and the numbers did not match as everything was manual. No correct number, no insights and no analysis. Also, another major issue was there was no analytics department or anyone knowing what to do with the data.

Implementation:

A data visualisation expert from Pangaea X was hired by the manager to help with the Automation. All the 40 reports had almost the same raw data that were being used. The expert prepared the data using Tableau as the data had to be blended and joined to ensure the database is centralised entirely. Once the data was prepared, the expert created the versioning system where the data was placed every month and in case there were issues the manager could call for a backup data.

The expert created 5 dashboards – Customer Analytics, Sales dashboard, market segmentation, classification and employee sales dashboard with good look and feel. The manage could access the at her fingertips every day.

Benefits Achieved:

  • Automation of entire process
  • Saving of at 480 hours a year
  • One single source of truth database
More Case Studies
NGO
Overview An NGO working for the welfare of orphans received donation through out the year across the globe. The account […]
Consulting
Overview A consulting firm start-up was requested by one of their clients to improve their sales performance, help increase efficiency […]
Marketing firm
Overview A marketing agency defines the marketing strategies within budget of the organisations. One such agency wanted to increase its […]
It’s free and easy to post your project

Get your data results fast and accelerate your business performance with the insights you need today.

close icon