Financial Modelling in Power BI

Download or read book Financial Modelling in Power BI written by Jonathan Liau and published by Tickling Keys, Inc.. This book was released on 2022-07-28 with total page 363 pages. Available in PDF, EPUB and Kindle. Book excerpt: Just like a shovel, this book is genuinely ground-breaking. It hits you over the head with the proverbial gardening tool, implementing the way forward for financial modelling. Many working in banking and finance create their financial models in Excel and then import them into Power BI for graphical interpretation and further analysis. Not on our watch. We're going to jettison the universal spreadsheet and build the entire model in Power BI.We can't stress how far off the range we're taking the horses. If you are reading this, you are a true pioneer. Some have managed to build the odd financial statement in Power BI, but all three? This is where you can gain a major advantage in the workplace. If you build the calculations for financial statements in Power BI, you can produce statements by product, by customer, by geography... Get the picture? The limitation will be restricted to the granularity of the underlying data and your imagination.This book unearths some of the tricks, measures, logic and tools needed to build the model (there is no need to bury your mistakes). We just can't promise you a rose garden...With the usual jokes in spades, it's just a shame we couldn't get Doug (get it?) to assist.