Deep Dive Analysis into Revenue using Power BI
Arno Wakfer MCT
Power BI Artison & Training Lead | Helping Business Making Better & Faster Decisions using Data | Driving Data Capability & Data Literacy | Microsoft Certified Power BI Data Analyst, Trainer & Fabric Analytics Engineer
Imagine a CFO is sitting at a board meeting with their execs who want to analyse their revenue trends from different angles, all from the same visual. They are preparing their budgets and strategy for next year and want to be able to drill into the data and indentify under performing areas.
This is now possible with the help of Power BI's decomposition tree visual.
We are introducing this capability as one of the new features in our Finance Analytics solution that will enable any Finance team to produce financial insights on a regular basis to key decision makers.
Sure wish I had access to this type of Financial intelligence when I was still in Finance.....I'm sure many do.
In this example we demonstrate the analysis our Revenue data by these 5 different dimensions;
I will now share examples of how you can deep dive into revenue.
To start off with we have bookmarks used to navigate between the different decompositon trees on the same report page. This enable to user to stay in one place and simply navigation. to what they want to drill into.
Revenue Analysis by Fiscal Year
Revenue Analysis by Income Stream
Revenue Analysis by Lines of Business
Revenue Analysis by Geography
Revenue Analysis by Location
I hope you can see the amazing insights that Finance professionals can display with the power of Power BI.
Arno Wakfer
Microsoft Certified Power BI Data Analyst
Chartered Accountant
Certified Business Intelligence and Data Analyst with CFI (BIDA)
CPA, PMO Finance, Power Bi Model Developer, Senior Project Accountant,Senior Project Controller-Infrastructure-Engineering-Construction. Implementing ERP Systems, Small Business Consulting.
2 年"Imagine a CFO is sitting at a board meeting with their execs who want to analyse their revenue trends from different angles, all from the same visual." I can picture this scene.Directors in a room all looking at their laptops, all examining pbi reports and firing away using hierarchial slicers, filtering, cross filters, decomp trees AI commentary and voila!!! they come up with the answers they want. ?? Likely or just a dream?
AVP Global Commercial Finance at Pharmanovia l CFO of The Year Innovation l FP&A | Finance Business Partner | Digital Transformation | Strategy | OKR I KPIs | Gartner Ambassador | FP&A Advisory Council AFP | Speaker I
2 年Callum Wordsworth Ilyas Ag Sidiyene Maddie Turner