Financial Modelling in Power BI: Master Subtotals, Functions, and Advanced Excel Tricks in Minutes!
1146725291
Financial Modelling in Power BI: Master Subtotals, Functions, and Advanced Excel Tricks in Minutes!
14.99 In Stock
Financial Modelling in Power BI: Master Subtotals, Functions, and Advanced Excel Tricks in Minutes!

Financial Modelling in Power BI: Master Subtotals, Functions, and Advanced Excel Tricks in Minutes!

Financial Modelling in Power BI: Master Subtotals, Functions, and Advanced Excel Tricks in Minutes!

Financial Modelling in Power BI: Master Subtotals, Functions, and Advanced Excel Tricks in Minutes!

eBook

$14.99 

Available on Compatible NOOK devices, the free NOOK App and in My Digital Library.
WANT A NOOK?  Explore Now

Related collections and offers

Product Details

ISBN-13: 9781837020607
Publisher: Packt Publishing
Publication date: 12/18/2024
Sold by: Barnes & Noble
Format: eBook
Pages: 355
File size: 35 MB
Note: This product may take a few minutes to download.

About the Author

Holy Macro! Books has been providing top-quality books on Excel, Power Query, and Power BI since 2002. They have published over 100 titles by 30 authors, including numerous Microsoft MVPs.
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.
Liam Bastick has over 30 years' experience in financial model development / auditing. With over 2,000 articles written for the accounting profession, he is a regular contributor to the AICPA, Microsoft's Excel Blog and various LinkedIn specialist discussion groups. A frequent public speaker, Liam attends Excel and Power BI conferences around the globe and has been a central organiser for the Excel Summit South and Excel Virtually Global. He still follows Derby County and the England cricket team. Poor soul.

Table of Contents

Table of Contents
  1. Introduction
  2. Introduction to Power BI
  3. Best Practice Methodology
  4. Financial Statements Theory
  5. Control Accounts
  6. Getting Started
  7. Creating Parameters
  8. Calculating Sales
  9. Formatting Matrix Visualizations
  10. Calculating COGS (Part 1)
  11. VAR Variables
  12. Calculating Inventory (FIFO)
  13. Average Inventory Calculation
  14. Calculating COGS (Part 2)
  15. Calculating Operating Expenditure (Opex)
  16. Calculating Capital Expenditure (Capex)
  17. Calculating Debt
  18. Calculating Interest
  19. Income Statement (Part 1)
  20. Calculating Tax (Part 1)
  21. Recursion Aversion
  22. Calculating Tax (Part 2)
  23. Income Statement (Part 2)
  24. Calculating Equity and Dividends
  25. Cash Flow Statement
  26. Balance Sheet
  27. And Finally
From the B&N Reads Blog

Customer Reviews