-
Book Overview & Buying
-
Table Of Contents
Power BI for Finance
By :
Power BI for Finance
By:
Overview of this book
Martin Kratky brings his global experience of over 20 years as co-founder of Managility and creator of Acterys to empower CFOs and accountants with Power BI for Finance through this hands-on guide to streamlining and enhancing financial processes.
Starting with the foundation of every effective BI solution, a well-designed data model, the book shows you how to structure star schemas and integrate common financial data sources like ERP and accounting systems. You’ll then learn to implement key financial logic using DAX and M, covering calendars, KPIs, and variance calculations. The book offers practical advice on creating clear and compliant financial reports, such as income statements, balance sheets, and cash flows with visual design and formatting best practices.
With dedicated chapters on advanced workflows, you’ll learn how to handle multi-currency setups, perform group consolidations, and implement planning models like rolling forecasts, annual budgets, and sales and operations planning (S&OP). As you advance, you’ll gain insights from real-world case studies covering company valuations, Excel integration, and the use of write-back methods with Dynamics Business Performance Planning and Acterys. The concluding chapters highlight how AI and Copilot enhance financial analytics.
*Email sign-up and proof of purchase required
Table of Contents (22 chapters)
Preface
Part 1: Power BI Stack for Finance
Introducing Power BI for Finance
Financial Logic with Power BI
Part2: Financial Reports and Dashboards
Business Information Design
How to Realize Financial Reporting in Power BI
Integrating Excel and Power BI for Financial Requirements
Part 3: Advanced Financial Topics
Handling Multi-Currency Requirements in Power BI
Management, Group, and Board Reporting
Rolling Reporting Forecasts
Discounted Cash Flow Public Company Valuation
Price Volume Mix Analysis
Part 4: Planning and Forecasting
Write-Back Options in Power BI
Case Study – Planning Model
Advanced Analytics and Machine Learning
Using LLMs and Copilot in Power BI to Improve Financial Analysis
Unlock Your Exclusive Benefits
Other Books You May Enjoy
Index