BI Solution
For a Retail NBFC
CLIENT & PROBLEM STATEMENT
- The NBFC is one of the Private sector Retail NBFCs in India.
- They have large amount of retail loans of various kinds.
- A Retail NBFC wanted an end-to-end BI solution for data integration with LOS/LMS.
- They wanted customised reports and Dashboards for Collection, Sales and Accounting to track the business on live basis.
APPROACH
- Automated transfer of data from LoS and LMS to the BI solution.
- Created and automated Reports in Narrator under the below categories: Financial Reports, Sales Reports, Collections Reports.
SOLUTION & OUTPUT
- Automation of Reports/Alerts for emailing: Automated reports are triggered from Narrator on a specified frequency as emailers to respective users, Apart from the automated reports, alert emailers also gets triggered based on predetermined logics.
- The BI helps to track the movement within the business such as branch wise transfer of DPD buckets, movement of NPA, non-performing branches and take actionabl
- Narrator processes close to a million rows daily ensuring up-to-date information was readily available.
