Description |
1 online resource |
|
data file |
Summary |
"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."-- Provided by publisher |
Contents |
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... |
Local Note |
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America |
Subject |
Microsoft Power BI (Computer file)
|
|
Financial statements -- Data processing.
|
|
Business forecasting.
|
|
Business intelligence -- Computer programs.
|
|
Information visualization -- Computer programs.
|
|
Business -- Data processing.
|
|
Visual analytics.
|
|
Business -- Data processing |
|
Business forecasting |
|
Financial statements -- Data processing |
|
Information visualization -- Computer programs |
|
Visual analytics |
Added Author |
Liau, Jonathan, contributor.
|
ISBN |
9781615471614 (electronic book) |
|
1615471618 (electronic book) |
|
9781615470723 |
|