Financial Modelling in Power BI: Forecasting Business Intelligently

Jonathan Liau · Liam Bastick

Jul 2022 · Tickling Keys, Inc.

About this ebook

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.

About the author

Jonathan Liau was born in Singapore and lived in China as an ex-pat for most of his formative years. He served in the military in Singapore for two years before enrolling in the University of Sydney, studying Economics, Finance, and IT. Currently an experienced Senior Analyst at SumProduct Australia, Jonathan specialises in Power BI projects. Aside from work he enjoys hiking and driving around Australia, the casual whiskey with friends, power lifting, and tinkering with computers.