Rishi works as a Group Manager at Avanade - a Joint Venture between Accenture and Microsoft which has been MS Partner of the Year for the last 15 Years - specialising in Power BI. Prior to this he has spent 12 years in Consulting /Financial Services (Deloitte, HSBC, Barclays, KPMG) and is a qualified accountant with a background in Business modelling and process improvement. He is actively involved in the Power BI Community in London and has presented at Meetup groups and several global conferences. He also runs two core communities - LDI (www.learndatainsights.com) for people to take data analytics quizzes and courses and PPF (www.powerplatformfinance.com) for helping finance professionals apply the Power Platform technology stack in their roles.
Rishi Sapra's Training Days
Financial Reporting with Power BISQLBits 2023
Learn how to build financial reports in Power BI (focused on Income Statement) with a complete end-to-end run through of designing a data model based on financial transactions, ingesting monthly system extracts (CSV), data modelling/DAX (including time intelligence) and data visualisation.
Rishi Sapra's Sessions
Power BI and Fabric Governance – Going from the skies to the ground!SQLBits 2024
In this session you will obtain a view of how to Govern and manage a large-scale Power BI / Fabric estate, including both technical considerations (e.g. Architecture, Artefact management, security and performance) as well as non-technical (e.g. roles & responsibilities, processes and workflows). By the end, you will have an idea how to achieve the holy grail of self-service BI: “Discipline at the core, flexibility at the edge”
What does Microsoft Fabric mean for a Finance/Business Analyst?SQLBits 2024
For a business team such as Finance, Microsoft Fabric allows you to go from being “IT reliant” to “IT enabled” and this session shows you how! Whether you’re a data explorer, data analyst, data engineer – or perhaps a newly coined analytics engineer – we will explore what Microsoft Fabric means for you. We will look at the need for the data platform components in Fabric, applied for a finance data use case, and consider the benefits of this being in a SaaS lakehouse architecture. We will also consider how you need to organise your Finance and IT teams to work best with Fabric so that you have the right capabilities to deliver meaningful financial insights at scale.
How to learn fast-changing tech in a post pandemic, Attention-starved worldSQLBits 2023
Struggling to figure out how to learn about new features and pick up new skills in a technology environment that is moving so fast? In this session, Rishi will highlight some key principles of instructional design and how you can use them to become a better learner or teacher!
Power BI Governance: 6 steps to successSQLBits 2022
Learn how to deploy Power BI at scale within a large Enterprise. The mantra behind this is “discipline at the core, flexibility at the edge” - we will cover deploying appropriate guardrails/controls whilst still retaining the notion of “self-service” within the organization.
Storytelling With DataSQLBits 2022
Learn how to present arguments with data to effectively communicate the insights you need to get across
Tips and Tricks for working with Finance Data in Power BISQLBits 2020
<p>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.
The Incidental Business Analyst (BA) – Designing a Finance Power BI Data Model to Tell a StorySQLBits 2020
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.