Have a personal or library account? Click to login
Financial Modelling in Power BI Cover

Financial Modelling in Power BI

Master Subtotals, Functions, and Advanced Excel Tricks in Minutes!

Publisher:Packt Publishing Limited
By: MrExcel's Holy Macro! Books,  Jonathan Liau and  Liam Bastick  
Paid access
|Dec 2024
Product purchase options

Explore Power BI for financial modeling. This book enables you to learn data preparation, DAX optimization, and creating advanced visualizations and reports. You will also be equipped to automate workflows and create dynamic models.

Key Features

  • A clear explanation of financial modeling concepts and methodologies
  • Coverage of financial modeling concepts and Power BI tools
  • A clear breakdown of DAX functions for precise financial analysis

Book Description

This book introduces readers to the fundamentals of financial modeling using Power BI, starting with an overview of the tool and best practices for creating robust, transparent, and flexible models. Early chapters lay the groundwork by explaining financial statement theory and control accounts, essential concepts for any financial analyst. Readers are guided step-by-step through creating parameters and calculating sales, ensuring a solid foundation in Power BI's core functionalities.
As the book progresses, readers delve into more advanced topics such as inventory calculations, operating and capital expenditures, and tax computations. Practical examples and hands-on exercises make complex concepts like DAX functions, FIFO inventory modeling, and control account measures accessible to users of all experience levels. Detailed sections on cash flow statements, income statements, and balance sheets tie the lessons together, showing how these elements integrate into a comprehensive financial model.
The final chapters explore advanced features like interest and debt modeling, recursion aversion, and equity calculations, culminating in the creation of fully dynamic and optimized models. Readers also learn to design compelling visualizations to present financial insights effectively. By the end of the journey, users will have the tools and confidence to apply their knowledge to real-world scenarios, mastering financial modeling with Power BI.

What you will learn

  • Understand how to format data for subtotals
  • Learn to sort and organize complex data sets
  • Apply advanced subtotal tricks and techniques
  • Use VBA to automate subtotal calculations
  • Create custom subtotal reports with formatting
  • Leverage Power Query to replace subtotals

Who this book is for

This book is ideal for finance professionals, analysts, and business intelligence enthusiasts who want to leverage Power BI for financial modeling. Readers should have basic familiarity with Power BI and Excel. The content is suited for intermediate to advanced users who aim to build dynamic, scalable financial models.

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
https://packt.link/FC1YO
PDF ISBN: 978-1-83702-060-7
Publisher: Packt Publishing Limited
Copyright owner: © 2024 Packt Publishing Limited
Publication date: 2024
Language: English
Pages: 355
Related subjects:
Computer sciences,
Databases and data mining

People also read

Hands-On Financial Modeling with Excel for Microsoft 365
Book

Hands-On Financial Modeling with Excel for Microsoft 365

Oluwa, Shmuel
Introduction To Financial Modelling
Book

Introduction To Financial Modelling

Books, MrExcel's Holy Macro!, Bastick, Liam
Hands-On Financial Modeling with Microsoft Excel 2019
Book

Hands-On Financial Modeling with Microsoft Excel 2019

Oluwa, Shmuel
Power BI for the Excel Analyst
Book

Power BI for the Excel Analyst

Books, MrExcel's Holy Macro!, Hopkins, Wyn
Excel for Finance and Accounting
Book

Excel for Finance and Accounting

Kumar Lohani, Suraj
Continuing Financial Modelling
Book

Continuing Financial Modelling

Books, MrExcel's Holy Macro!, Bastick, Liam
Supercharge Power BI
Book

Supercharge Power BI

Books, MrExcel's Holy Macro!, Allington, Matt
Power Pivot and Power BI
Book

Power Pivot and Power BI

Books, MrExcel's Holy Macro!, Collie, Rob, Singh, Avichal
Power BI Data Modeling
Book

Power BI Data Modeling

Mihiranga, Nisal
Learn Power BI
Book

Learn Power BI

Deckler, Gregory