process management blog posts

Leveraging Power BI for Not-for-Profit Variance Analysis

Blog: Professional advantage - BPM blog

In many parts of Europe, the concept of Management Accounting does not exist in organisations. Instead a role exists for a “Business Controller”. One of the main accountabilities of a Business Controller is to act as a Business Navigator.

The metaphor of a maritime navigator complements the task of variance analysis for decision making and forecasting. That is, a purpose of variance analysis is to understand the effectiveness of a measured not-for-ptofit activity in relation to planned actions.

Ideally the measures of business activities (Key Performance Indicators) have a direct link to achieving the mission objectives. The progress that an organisation makes towards the planned strategic objectives is measured as variances. The variances highlight the success or otherwise of the programmes, grants, and use of funds, and identify decision points that are required. The decision may involve changes in process, allocation of funds, grant management, and the assignment of staff and volunteers.

The quality of navigational decisions is dependent upon the navigational tools employed. Today the Power BI business intelligence visualisation software is the organisations navigation tool.

Just like a maritime navigator, the effectiveness of the information a navigator provides to the captain will influence the quality of decisions made. The quality of decision making will then influence how efficiently the ship (organisation) fulfils its mission. The critical organisational decisions can have a major influence on workforce and volunteer utilisation, and ultimately the results of the grant funded mission.

A Management Reporting professional plays much the same role in not-for-profit organisations. The use of business intelligence tools; the presentations of data in respect to predetermined KPIs; the understanding of industry and business circumstances; and ultimately the recommended actions are all aspects of the management reporting role including enhancing transparency and compliance.

Let us consider frameworks, analytical tools, and practices in respect of conducting variance analysis and forecasting. 

Variance Analysis Framework

The fundamental purpose of variance analysis is to detect and assess organisational performance. Variance analysis provides clarity on the success or otherwise of grant and funding objectives and initiatives that directly cascade from predetermined measures of success. From the detection of variance, actions and remedies are assigned to assist with workforce and volunteer utilisation that enhances the value creation process for not-for-profit organisations. The value creation process is considered by Robert Kaplan and David Norton (the authors of The Balanced Scorecard and The Strategy-Focused Organization [sic]) to be at the centre of delivering business strategies. Whether an organisation is a commercial business, listed company, government department, or not-for-profit, the analysis of measures and the actions that flow from the analysis is central to the value creation process and the experience of the customers, clients, or general public to achieve their full potential. 

Variance Analysis Framework arrow

Variance analysis has traditionally been used as a management control tool. From the aspect of management control, Robert N. Anthony, Emeritus Professor of Harvard University, outlines in his works on management control systems a framework for organising and the variance analysis process. 

Variance Analysis Framework table

The framework for variance analysis begins with the effective use of the Control Device. The control device in the case of management reporting will be the business intelligence software that interrogates and presents reporting data. The architecture of the control device and how it complements business process will determine the accuracy, reliability, and timeliness of data. The control device acts as the underlying infrastructure from which the variances are detected.

Once the KPIs have detected raw information regarding what is happening in the organisation, the information is then assessed.    

The assessment of KPI information is matched against expected standards, planned outcomes for a level of activity, or input. The environmental context is also considered. The environmental considerations may include changes in competitive environment (new entrants, or product/service substitutes), changes in input prices, supply chain patterns, resource capacity, government legislation, or loss of major clients or customers. 

The final stage in Robert N. Anthony’s framework is the effect. The effect is the “behaviour alteration, if needed”, as mentioned within his book Management Control Systems: Ninth Edition. The effect focuses on what actions are required to take place to make the necessary adjustments to resource allocation, process, or workflow to facilitate the desired organisational outcomes. Using the sailing metaphor, what are the changes in direction required to reach the stated strategic destination of the business?

In the practical application of Anthony’s framework, the communication links between detection, assessment, and desired effect upon organisational outcomes is critical. The communication of information to the right people at the right level, with the appropriate decision-making authority, needs to be delivered in the right context to enable the appropriate organisational actions to take place in a timely manner.     

Anthony’s framework focuses on navigating the controlled entity to its desired strategic destination. Underpinning Anthony’s framework is the foundation of having the appropriate control devices that will provide information of strategically aligned KPIs.

You can leverage variance analysis to ensure your funds achieve the full potential in the delivery of grant operations and make a difference to the community, whilst at the same time increasing transparency and compliance.

Are you using your business intelligence tools to position your decision makers to make the best decisions?


Are you ready to improve your not-for-profit reporting process?

Join Business Intelligence consultants Chris Catto and Greg Long to find out how Microsoft Power BI can help not-for-profit organisations improve their reporting outcomes in the areas of:

Grants and funding management, procurement and spend analysis, and real-time reporting and data insights.
How to simplify complex reporting for not-for-profit organisations

Wednesday 27th November at 12:30 PM (AEDT).

Reserve your spot!

We hope you can join us, but if not, we invite you to register anyway and we will send you the webinar recording.

The post Leveraging Power BI for Not-for-Profit Variance Analysis appeared first on Enterprise Software Blog - Professional Advantage.