Loading...
The Challenge
The corporate collections and retail asset departments relied heavily on legacy Excel sheets. Over 15 disjointed trackers required 40+ hours of manual consolidation weekly. Executive leadership lacked real-time visibility into NPA (Non-Performing Asset) changes, collections efficiency ratios, and daily recovery runs.
The Solution
Engineered a centralized data hub with automated ETL pipelines utilizing SQL Server staging and Azure Data Factory. Built a suite of high-performance Power BI dashboards equipped with RBI-compliant Row-Level Security (RLS) to restrict regional manager access, establishing a single source of truth.
Power BISQL ServerAzure Data FactoryDAXRow-Level Security (RLS)Power Automate
Interactive Dashboard Preview
Interactive Dashboard Preview
Measurable Impact
Quantifiable results achieved within 30 days of deployment.
40 Hrs
Hours Saved Monthly
0%
Reporting Errors
None
Manual Consolidation