DSB Analytics

Doorstep banking (DSB) has transformed the banking experience by providing services directly to customers' locations. To ensure the effectiveness and efficiency of these services, banks must utilize a comprehensive analytics dashboard. This dashboard should track key metrics such as coverage, performance, financials, grievances, and customer segmentation. Doorstep Banking Dashboard: 1. Coverage Active and Inactive Status: * Branches: * Current Month: Number of active and inactive branches. * Current Quarter: Quarterly trend of active and inactive branches. * Current Financial Year: Yearly trend of active and inactive branches. * Centres: * Current Month: Number of active and inactive centres. * Current Quarter: Quarterly trend of active and inactive centres. * Current Financial Year: Yearly trend of active and inactive centres. * Zones: * Current Month: Number of active and inactive zones. * Current Quarter: Quarterly trend of active and inactive zones. * Current Financial Year: Yearly trend of active and inactive zones. * Customers: * Current Month: Number of active and inactive customers. * Current Quarter: Quarterly trend of active and inactive customers. * Current Financial Year: Yearly trend of active and inactive customers. 2. Performance Target versus Actual Services Completed: * Current Month: * Number of services targeted versus actual services completed. * Current Quarter: * Quarterly comparison of targeted services versus actual services completed. * Current Financial Year: * Yearly comparison of targeted services versus actual services completed. 3. Financials Total Revenue and Total Income Earned: * Current Month: * Total revenue generated. * Total income earned from completed services. * Current Quarter: * Quarterly revenue and income trends. * Current Financial Year: * Yearly revenue and income trends. 4. Grievances Raised and Resolved Complaints within TAT (Turn Around Time): * Current Month: * Number of complaints raised. * Number of complaints resolved within TAT. * Current Quarter: * Quarterly trend of raised and resolved complaints within TAT. * Current Financial Year: * Yearly trend of raised and resolved complaints within TAT. 5. Analytics Average Transaction per Branch per Month: * Current Month: * Average number of transactions per branch. * Current Quarter: * Quarterly average number of transactions per branch. * Current Financial Year: * Yearly average number of transactions per branch. Service Contribution: * Current Month: * Contribution of different services to the overall transactions. * Current Quarter: * Quarterly service contribution trends. * Current Financial Year: * Yearly service contribution trends. 6. Customer Segment Service Booked by Customer: * Current Month: * Number of services booked by individual customers. * Current Quarter: * Quarterly trend of services booked by customers. * Current Financial Year: * Yearly trend of services booked by customers. Service Booked by Branch: * Current Month: * Number of services booked per branch. * Current Quarter: * Quarterly trend of services booked by branches. * Current Financial Year: * Yearly trend of services booked by branches. Top 5 Services: * Current Month: * Top 5 most booked services. * Current Quarter: * Quarterly ranking of top 5 services. * Current Financial Year: * Yearly ranking of top 5 services.