Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Power BI for Finance
  • Table Of Contents Toc
Power BI for Finance

Power BI for Finance

By : Martin Kratky
3 (1)
close
close
Power BI for Finance

Power BI for Finance

3 (1)
By: Martin Kratky

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)
close
close
1
Part 1: Power BI Stack for Finance
4
Part2: Financial Reports and Dashboards
8
Part 3: Advanced Financial Topics
14
Part 4: Planning and Forecasting
20
Other Books You May Enjoy
21
Index

Write-Back Options in Power BI

Data entry and write-back are key aspects in financial processes like planning, forecasting, and budgeting. Out of the box, Power BI doesn’t offer any write-back capabilities apart from a very basic option in Power BI Desktop with the Enter data feature. This, though, only allows report creators in Power BI Desktop to create simple tables with no options for end users to change them. Equally, core planning features such as data entry on aggregated levels and collaboration options like commenting are not possible without additional third-party solutions in Power BI.

Write-back allows any users to make changes to write-enabled data sources in any Power BI frontend (Desktop or the service) and have those changes reflected in the reports and dashboards they create in real time. This is the foundation for many typical financial processes, including the following:

  • Collecting planning assumptions: Enable global subsidiaries to enter/update...
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Power BI for Finance
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist download Download options font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon