The country(Nigeria) Commercial Banking Experience Analysis : Over the past few weeks, I challenged myself to build something different.
Instead of downloading another popular dataset or recreating a dashboard that's already been done hundreds of times, I wanted to solve a real business problem using real-world data.
So I built a Nigeria Commercial Banking Experience Analysis project using Microsoft Excel 2007.
Rather than evaluating banks only by financial strength, I developed a custom Banking Experience Index (BEI) to measure customer experience across 20 major Nigerian commercial banks.
To make the analysis meaningful, I manually collected and combined data from multiple public sources, including official bank websites, the
Central Bank of Nigeria (CBN), the Nigerian Exchange Group (NGX),
Google Play Store,
Apple app store, NCC, and FIRS.
The project involved:
• Data collection from multiple sources
• Data cleaning and transformation
• Feature engineering
• Business analysis
• Pivot Tables & Pivot Charts
• Dashboard development in Microsoft Excel
Some of the insights uncovered include:
✅
Access Bank Plc achieved the highest overall Banking Experience Index (BEI).
✅ Strong digital banking performance is closely associated with better customer experience.
✅ Financial size alone does not guarantee a better banking experience.
✅ Customer engagement is concentrated among a relatively small number of banks.
**One of the biggest lessons from this project is that meaningful business insights don't always require advanced tools. With a clear analytical approach, structured thinking, and well-prepared data, Excel remains a powerful tool for solving real business problems.**
I'd genuinely appreciate your feedback:
If you were a banking executive, what additional metric would you include to measure customer banking experience?
Your thoughts are welcome.