Rishi Sapra
Rishi Sapra

Financial Modelling in the Banking Industry

Rishi Sapra
Technical Community leader, speaker, trainer and evangelist specialising in Power BI and Azure. Formally recognised by Microsoft as a Most Valuable Professional (MVP), Fast Track Recognised Solution Architect (FTRSA) and Microsoft Certified Trainer (MCT).
  • December 12, 2022

In this session you’ll learn how to:

  • Take industry Income Statement/Balance Sheet data for 4 Banks (Barclays, Citi, HSBC, Lloyds) and turn it into a financial reporting solution in Power BI
  • Create an interactive benchmarking report comparing the financial performance of the Banks on key metrics such as Income Growth, Cost:Income Ratio and Current Ratio -Create a simple Income Statement and Balance Sheet for each bank
  • Link the Income Statement and Balance sheet together through Retained Earnings -Introduce what-if scenario modelling for key variables such as headcount growth and annual change in loans/deposits


Click the button below to download the resources (Presentation Slides, PBIX Files, Tabular Editor scripts etc)

Financial Modelling in the Banking Industry ResourcesDownload

Latest Solutions

FP&A Unlocked – Podcast Episode with Paul Barnhurst

FP&A Unlocked – Podcast Episode with Paul Barnhurst

Power BI and a Creator Mindset Are Essential for FP&A Teams to Replace Excel with Rishi Sapra n this episode…
Continue Reading →
ICAEW Data Analytics Community Webinar: Analytics Powered by Agentic AI

ICAEW Data Analytics Community Webinar: Analytics Powered by Agentic AI

2025 has been the year of ‘agentic AI’, but what does this mean for those working with data? Is it…
Continue Reading →
Migrating Financial Models from Excel to Fabric – Full Guide! – Credit Risk Modelling In Power BI/Fabric

Migrating Financial Models from Excel to Fabric – Full Guide! – Credit Risk Modelling In Power BI/Fabric

For decades, the entire business world has been built on the flexibility and power of spreadsheets. From rocket science to…
Continue Reading →
Top tips for financial reporting with Power BI and MS Fabric (Plum Solutions)

Top tips for financial reporting with Power BI and MS Fabric (Plum Solutions)

If you’ve come across Power BI/Fabric, you might be wondering whether the Copilot-driven storytelling and automation capabilities are what you…
Continue Reading →
Power BI MCP Server – Context Engineering Blog Post

Power BI MCP Server – Context Engineering Blog Post

After attending (and presenting!) at Fabcon Europe 2025, I was inspired by a session on the Power BI MCP Server…
Continue Reading →
PPF Blog Article – Financial Reporting with Power BI: Tips and Tricks

PPF Blog Article – Financial Reporting with Power BI: Tips and Tricks

I published a blog article on the PPF site with an interactive e-learning video and a series of 3 tips…
Continue Reading →
Fabcon Europe 2025: 45 Microsoft Executives/Product Leads and Community Experts Introduce Themselves

Fabcon Europe 2025: 45 Microsoft Executives/Product Leads and Community Experts Introduce Themselves

At FabCon Europe 2025 in Vienna, I asked 40+ attendees to do quick 10-15 second introductions of themselves! This unique…
Continue Reading →
ICAEW Power BI Tips & Tricks Live: your questions answered

ICAEW Power BI Tips & Tricks Live: your questions answered

In this webinar, Rishi and Gary Watson ( Digital Skills Lead at Forvis Mazars UK) were on hand for over…
Continue Reading →
Storytelling with Data (Power BI and Fabric Manchester)

Storytelling with Data (Power BI and Fabric Manchester)

Communicating through telling stories is an innate part of what it means to be human. It’s what allows us to…
Continue Reading →
Rishi Sapra