#MSFABRICBRISTOL - Feb 25 - P&L Models & Financial Reporting in PBI

When: Thursday 20th February 2025
Time: arrive for 5:45pm with talks starting from 6pm start prompt.

Location:
BJSS,
90 Victoria St,
Redcliffe,
BS1 6DP

Complimentary drinks & pizza provided by our hosts BJSS

Social drinks afterwards will be at Ye Shakespeare (50m away) for those interested.

This #MSFABRICBRISTOL will feature Chris Barber and Rishi Sapra

Session 1 - P&L Models - Chris Barber
Profitability is a key metric; any profits can be distributed back to shareholders (owners) either directly or indirectly. A profit and loss (P&L) statement answers high level questions - such as “what was net profit last year?” - and summarises key revenue (i.e., product revenue) and expense (i.e., Research & Development) items. Unlike static reports, a P&L semantic model contains the detail; this allows end-users to ask questions such as “what was R&D spending broken down by a particular research project, fiscal period, or legal entity?” A semantic model also allows end-users to consume information using Copilot prompts, Power BI reports, or Pivot Tables and formulas in Excel.
In this session, we will go through:

• Why you should build an income statement semantic model
• How to use an accelerator to speed up development.
• The key questions you need to ask stakeholders.
• The challenges in building a P&L income statement

About Chris
Chris Barber is a chartered accountant (ACMA, CGMA), 4 times Microsoft MVP, author of Income Statement Semantic Models, runs StarSchema.co.uk, and has popular YouTube videos (over 100k views) and courses (over 1k participants) on the topic of Profit and Loss (P&L) using Power BI.

Session 2 - Financial Reporting in PBI - Rishi Sapra
This session will explore how to transform a traditional Excel-based credit rating model for countries into a modern, interactive, and scalable solution using Power BI and Microsoft Fabric. Participants will discover innovative techniques to enhance financial modelling and storytelling by leveraging advanced analytics and integration capabilities.

Hear from Power Platform in Finance specialist and Microsoft MVP, Rishi Sapra, as we delve into the following areas:

• Replicating Complex Rating Logic: Translating intricate credit rating formulas and methodologies from Excel into DAX to ensure consistency and accuracy.
• Interactive Insights: Using slicers, bookmarks, and contextual visualizations in Power BI to enable dynamic comparisons and highlight key drivers of credit ratings.
• Streamlined Reporting: Designing intuitive and user-friendly reports that empower stakeholders to explore insights interactively.
• Scalability with Microsoft Fabric: Harnessing the Medallion Lakehouse architecture to enable seamless data integration, metadata management, and collaboration at an enterprise level.

This session is particularly beneficial for finance professionals and analysts who are seeking to modernize their financial or operational models. Attendees will leave with practical strategies to maintain model accuracy, enhance interactivity, and scale their solutions to meet the evolving demands of modern analytics.

About Rishi
Rishi has a unique blend of technical and commercial skills - he is a 5x Microsoft Most Valuable Professional (MVP), a Chartered Accountant, a Microsoft Certified Trainer (MCT) and an Executive MBA (Hons) holder with a first class degree from the London School of Economics.

He currently works as a Data & AI Strategic Project lead at Avanade - a Joint Venture between Accenture and Microsoft which been awarded Microsoft Partner of the Year 18 times! In this role he focuses on Microsoft Fabric Go To Market (GTM) offerings including those around Security & Governance, Industry/Functional accelerators and Azure/BI migration.

Prior to joining Altius in 2017 (Which was acquired by Avanade in 2020), he spent 12 years in the Big 4 /Financial Services (Deloitte, HSBC, Barclays, KPMG) and has a strong background in Business modelling and process improvement.

He is actively involved in the Fabric Community in London/globally and has presented at Meetup groups and several large-scale conferences. His passion is in helping organisations achieve the holy grail of Self-Service BI and helping individuals learn the necessary skills to succeed.
Under his community Learn Data Insights (www.learndatainsights.com), he runs Microsoft Fabric Training (www.msfabrictraining.com) and Power Platform Finance (www.powerplatformfinance.com) with e-learning courses and quizzes for Analytics and Finance professionals.

We all look forward to seeing you there!!