Financial Service

May 5, 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
E commerce service provider
Overview: An e-commerce website provider was concerned about the customer behaviour in the websites. They had the review system in […]
Marketing (Small Businesses)
Overview A small business builds candles in the rural areas and ships it to the urban areas. The owner runs […]
Consulting
Overview A consulting firm start-up was requested by one of their clients to improve their sales performance, help increase efficiency […]
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