Context
Why we created this?
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 (R) 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 Version of 'The Financial Visuals Reference – Management Reporting in Power BI'. In this initial Draft, 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.
Scroll Down for LIVE ACCESS or download the Guide here: The Financial Visuals Reference – Management Reporting in Power BI
Inspired by the 'THE VISUALS REFERENCE — FOR MICROSOFT POWER BI' from SQL BI and by the 'Financial Times Visual Vocabulary: Power BI Edition' from Jason Thomas and of course by IBCS ® (International Business Communication Standards), Stephen Few and Edward Tufte:
Live Access & Demo: Klick on a Box with Description to jump to the Report Example…
Contact us for all questions:
Views: 7551
Available as Consultant / Interim Manager in Switzerland, Germany and Austria
Expert Knowledge in Business Analysis, Requirement Engineering, Business Intelligence and DWH
Solution Architecture BI/DWH, BI-Strategy- and Architecture Consulting
Power BI Advisor
Azure Advisor
Snowflake Database (Snowflake University Certified)