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.


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.

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.