
eBook - ePub
Financial Modelling in Power BI
Forecasting Business Intelligently
- 306 pages
- English
- ePUB (mobile friendly)
- Available on iOS & Android
eBook - ePub
About this book
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.
Frequently asked questions
Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription.
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Perlego offers two plans: Essential and Complete
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes! You can use the Perlego app on both iOS or Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Yes, you can access Financial Modelling in Power BI by Liam Bastick,Jonathan Liau in PDF and/or ePUB format, as well as other popular books in Commerce & Comptabilité de gestion. We have over one million books available in our catalogue for you to explore.
Information
Table of contents
- About the Author
- Preface
- Editor’s notes
- Downloadable Resources
- CHAPTER 1: Introduction
- CHAPTER 2: Introduction to Power BI
- CHAPTER 3: Best Practice Methodology
- Chapter 4: Financial Statements Theory
- CHAPTER 5: Control Accounts
- CHAPTER 6: Getting Started
- CHAPTER 7: Creating Parameters
- CHAPTER 8: Calculating Sales
- CHAPTER 9: Formatting Matrix Visualisations
- CHAPTER 10: Calculating COGS (Part 1)
- CHAPTER 11: VAR Variables
- CHAPTER 12: Calculating Inventory (FIFO)
- CHAPTER 13: Average Inventory Calculation
- CHAPTER 14: Calculating COGS (Part 2)
- CHAPTER 15: Calculating Operating Expenditure (Opex)
- CHAPTER 16: Calculating Capital Expenditure (Capex)
- CHAPTER 17: Calculating Debt
- CHAPTER 18: Calculating Interest
- CHAPTER 19: Income Statement (Part 1)
- CHAPTER 20: Calculating Tax (Part 1)
- CHAPTER 21: Recursion Aversion
- CHAPTER 22: Calculating Tax (Part 2)
- CHAPTER 23: Income Statement (Part 2)
- CHAPTER 24: Calculating Equity and Dividends
- CHAPTER 25: Cash Flow Statement
- CHAPTER 26: Balance Sheet
- CHAPTER 27: And Finally…
- Index