Dorcas_Akinnibosun.xlsxOpen to work · Lagos · Remote, home page
← All case studiesCase study 01 · Banking & finance

MetroBank Customer Insights

A 5-page Excel intelligence report on who MetroBank serves, where its money moves, which branches lose money and why customers complain.

BriefToolsDataDashboard
MetroBankExcel500 customers · 800 accounts · 5,000 transactions · 800 complaints5 pages · 15+ KPIs
This dashboard is an interactive Excel workbook.

Slicers, pivot-driven charts and KPI cards all update together. Open the file and click the slicers to explore it yourself.

Get the interactive workbook ↗
Object · MetroBank dashboard · light theme1 / 2
MetroBank Customer Insights: Customers dashboard pageFull size ↗

Customers. Who are MetroBank's customers? Loyalty, income tiers, generations, gender and segment value, sliced by region.

The brief

Customer insights & banking performance

Note · the problem

MetroBank was facing tougher competition and a rising pile of customer complaints. Management wanted to understand what drives performance across customer segments and branches, and which areas needed attention first.

I cleaned five raw datasets (customers, accounts, transactions, branches, and complaints & fraud reports), modelled them in Power Query and built an interactive Excel dashboard. It tells the full story of the bank's operations and customer experience, from customer profiling to fraud exposure.

TechniquesUsed
Power QueryTRUE
Pivot tablesTRUE
Slicers by region, gender & dateTRUE
Conditional formattingTRUE
KPI cardsTRUE
Interactive dashboard designTRUE
Key insights

What the data said.

#Key numberFinding
151 / 49A balanced, loyal customer base51% female and 49% male, an average age of 46 and five years' average tenure. Most customers are Retail. Most clients are "Established" or "Loyal", a sign of strong retention.
270%Checking and savings carry the portfolioChecking and savings make up nearly 70% of all accounts. The average credit score is about 580, and loan approvals track higher scores.
3$5,010Digital channels lead5,000 transactions worth $25.07M, averaging $5,010 each. Activity spreads across POS, Online, Branch and ATM, but POS and Online lead on both volume and value.
42 of 20Two branches lose moneyThe network earns $59.4M at a 64% margin. Branch 12 is the top performer by profit, while Branches 1 and 17 operate at a loss.
538%Fraud cases are stuck open800 complaints, 59% resolved, taking 30 days on average. Charges disputes (23%), service delays (20%) and fraud (18%) lead. About 38% of fraud cases are still open, and high-value customers complain the most, which is a retention risk.
Recommendations

What to do next, with targets.

Each recommendation has a KPI, so the team can measure whether it worked.

#RecommendationTarget KPI
1Shrink the open fraud backlogSet triage SLAs (P1 fraud within 48h, P2 within 7 days) with auto-escalation, plus anomaly rules for unusual merchant, location, time or amount.Unresolved fraud under 15%; resolution in 14 days or less
2Give high-value customers a care pathA priority complaint queue, a direct relationship-manager contact and quarterly service-health reviews for the top-value cohorts.30% fewer complaints per high-value customer
3Fix the loss-making branchesMatch staffing to revenue-per-staff benchmarks at Branches 1 and 17, shift low-value transactions to digital, and pilot shared staffing between nearby branches.Both branches at break-even within 2 quarters
4Reduce charges disputesStandardise merchant naming, auto-flag duplicate charges and let customers start disputes themselves with evidence templates.20% fewer disputes; 25% faster dispute cycle
5Speed up complaint handlingOne intake form with auto-tagging, weekly backlog reviews by the owning department and a red/amber/green SLA dashboard.Resolution rate of 80% or more within 14–21 days
Outcome

An end-to-end interactive Excel report, from raw data to recommendations, that gives MetroBank's leadership one place to see customers, products, channels, branches and service quality.

Data source

Datasets provided by Freedom Oboh as a practical assignment in the Let's Talk Excel programme. All cleaning, analysis and visuals were done independently by Dorcas.

Next case study ▸Maven Electronics Sales PerformanceA 4-page Power BI report for a global electronics retailer: what sells, who buys, which stores carry the business and where revenue is slipping.
Contact

=IF(you_have_data, "let's look at it together", "say hello anyway")

Whether it's a role, a messy spreadsheet or a question about one of the case studies, messages come straight to my inbox.

Open to data analyst and BI work: full-time, contract or freelance, remote or on-site