Skip to content
~/hth
Back to projects
Done

Bank Region Performance Report

Analysed 100K+ records of branch revenue, regional performance and service usage, and wrote a report with an action plan aimed at 20% revenue growth.

Problem

Find out which regions and products were falseunderperforming, and why, from branch-level revenue and service-usage data.

What I did

  • Analysed 100K+ records of branch revenue, regional performance and service adoption with SQL (joins, subqueries, window functions).
  • Built DAX measures and pivot summaries in Power BI to break revenue down by region and customer usage by service line.

Result

The analysis pointed to the weakest regions and products. I wrote it up as a diagnostic report with the main growth levers and an action plan aimed at a 20% revenue increase.