FINANCIAL REPORTING
As a chartered accountant by background, Rishi is passionate about learning and educating how the Microsoft Power Platform can be used for automating financial reports/processes. He has built an entire community around this - www.powerplatformfinance.com
Working with financial data isn’t straightforward - financial statements need to be presented in specific formats (often with complex logic) and consideration needs to be given how to present it in order to drive actionable insights.
In his numerous sessions on Power BI financial reporting, Rishi has outlined clear steps to build financial reports using both native and custom visuals as well as how to design and build a data model for financial reporting using scoping templates, Bus Matrix and startnets (conceptual modelling).
Financial Modelling in the Banking Industry
​
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
Resources (Presentation Slides, PBIX Files, Tabular Editor scripts etc)
Building an Income Statement End to End
​
​
In this session Rishi will show how to build an Income Statement in Power BI end-to-end, looking at: • Capturing requirements for the report and scoping/designing a data model with scattered/inconsistent transaction data • Use of an "FS Lines" table to have metadata-driven financial statements including custom calculations • Creating Dataflows to ingest data from an on-premise database/files/Web API (for exchange Rates) • Shaping the data in Power BI Desktop into a General Ledger/Trial Balance with corresponding dimensions and currency conversion • Creating base measures for Revenue/Profit and corresponding ratios including time-based variations (MTD/QTD/YTD) and Current vs Prior Year calculations • Defining DAX measures for Running Totals, Category Totals, and Custom Calculations • Applying different number formats for viewing the income statement in reporting currency (USD) vs local currencies (GBP/AUD/EUR) • Applying conditional formatting for the Income Statement matrix to highlight sub-totals/custom calculation lines differently.
Downloadable Presentation Slides
Financial Reporting with Power BI and Excel
​
​
In this session Rishi will show how to build an Income Statement in Power BI end-to-end, looking at:
​
• Capturing requirements for the report and scoping/designing a data model with scattered/inconsistent transaction data
​
• Use of a “FS Lines” table to have metadata driven financial statements including custom calculations
​
• Creating Dataflows to ingest data from an on-premise database/files/Web API (for exchange Rates)
​
• Shaping the data in Power BI Desktop into a General Ledger/Trial Balance with corresponding dimensions and currency conversion
​
• Creating base measures for Revenue/Profit and corresponding ratios including time-based variations (MTD/QTD/YTD) and Current vs Prior Year calculations
​
• Defining DAX measures for Running Totals, Category Totals and Custom Calculations •
Applying different number formats for viewing the income statement in reporting currency (USD) vs local currencies (GBP/AUD/EUR)
​
• Applying conditional formatting for the Income Statement matrix to highlight sub-totals/custom calculation lines differently.
Tips and Tricks for working with Finance Data in Power BI
​
​
Excel has always been the tool of choice for the finance team with the flexibility it provides for logic, formatting and presentation of numbers. But this flexibility has also caused Governance nightmares, performance issues and huge risks with manual processes. Is it possible to also achieve the desired outcomes and flexibility with Power BI whilst also having all the benefits of working in a more controlled, automated and feature-rich environment? Yes! In this session Rishi will show how you can have your finance cake and eat it, showing how to build dynamically formatted financial statements , waterfall charts and KPIs in Power BI to tell an engaging story with finance data.
Designing a Finance Power BI Data Model to Tell a Story
​
​
Join this session to learn the key steps in designing a data model: Know Your Audience (KYA), Complete a Scoping Template, Define the data granularity/scope and design a conceptual model. We will use time-tested methodologies based on Kimball Data modelling techniques, including a Bus Matrix and Starnet, complete with templates available for you to freely download.
Downloadable
Presentation Slides
Power Platform for Finance Professionals | Get ResponsLIVE #51
In this edition of Get Response LIVE we have Rishi Sapra, a Microsoft MVP, as our guest! He goes through some interesting aspects of Power Platform for financial professionals. He also goes through some interesting practical cases.
PUG Italy Webinar - Why Accountants Should Love Power BI
​
​
The Italian Power BI User Group is proud to present Rishi Sapra (MVP), who joined us to talk about some of the Power BI features that accountants could find particularly useful in the fifth webinar of our 2020/2021 season!
Downloadable
Presentation Slides
Modernising the Finance Function with Power BI - Rishi Sapra (Altius) and Amy Boyd (Microsoft UK)
​
In this comprehensive overview of Power BI (Desktop and service) applied to a finance scenario, learn how to take advantage of all the functionality that Power BI has to offer including:
- Automatically consuming files in a folder
- Storytelling with data
- Dynamics graphs and measures
- Waterfall charts and tables
- Row Level security
- Analysing data with Excel
- Reporting commenting and subscriptions - Q&A
And much more! This fun and engaging session is delivered as a role play based on real-life examples of how Power BI can deliver all the functionality that finance (and non finance!) teams need to be efficient!