The Financial Visuals Reference – Management Reporting in Power BI

klabir — Thu, 14 Mar 2019 15:08:04 GMT

In the Past there were no standards in Reporting at all which lead to sometimes horrible and unreadable Reports with a lot of 3D-, Pie-, Gauge Charts and no meaningful colors as well. Some time ago the IBCS was introduced and set some standards especially for the finance and controlling area. We can discuss about every single design point here, it does not really matter in the end. Important is to follow the general concepts and rules. Create a standard which fits for your organization’s needs, follows best practice and make sure it will be consequently used.

I created the first Draft of “The Financial Visuals Reference - Management Reporting in Power BI”. In this initial Version, I want to focus on KPI Cards which can show the status of a measure by comparing key indicators to a target and/or previous year. Then we go through some methods to show absolute values like Revenue or Costs, percent values like Margins and Variances, Human Resource KPIs like FTE's ( Full Time Equivalents) and Headcounts. Contributions like a Profit and Loss Statement. Comparisons for Gain and Loss of Customers or Revenue versus Costs. Last but not least the concept of small multiples in Management Reporting. We can discuss about every single design point here, it does not really matter in the end. Important is to follow the general concepts and rules. Colours are up to somebody’s preference, they should have just a meaning. Create a standard which fits for your organization’s needs, follows best practice and make sure it will be consequently used.

Klaus Birringer

https://dataviz.boutique

Please note that I used RAND() Function to generate dummy values heavily. So Charts look always different on reload / refresh. If you see a ugly chart, just reload the page.

eyJrIjoiMGJkY2M0NDEtZjY0NC00NWM5LTk3YjYtOTU2ZDk0YTI3ZmJhIiwidCI6IjJlYmI3YTRhLTk2YTYtNDVhYy1hNWFmLTdjOWQ5NjUyMGFjYiIsImMiOjh9

Re: The Financial Visuals Reference – Management Reporting in Power BI

Anonymous — Wed, 16 Oct 2019 23:32:04 GMT

can you share the Pbix file for this?

Re: The Financial Visuals Reference – Management Reporting in Power BI

olziich36 — Fri, 01 Nov 2019 10:06:10 GMT

can you share the Pbix file for this?
olziich36@gmail.com

Re: The Financial Visuals Reference – Management Reporting in Power BI

klabir — Fri, 01 Nov 2019 10:18:43 GMT

Hello

https://appsource.microsoft.com/en/marketplace/apps?search=ultimate&product=power-bi-visuals

you can download the sample pbix files from above Link / visuals. it is basically the same.

HTH

Klaus

https://datadriven.pro

https://dataviz.boutique

topic The Financial Visuals Reference – Management Reporting in Power BI in Data Stories Gallery

The Financial Visuals Reference – Management Reporting in Power BI

Re: The Financial Visuals Reference – Management Reporting in Power BI

Re: The Financial Visuals Reference – Management Reporting in Power BI

Re: The Financial Visuals Reference – Management Reporting in Power BI