Management reporting can be figures, graphics and gauges. But to bring these figures into perspective, commentary helps. Why? Where? How? to go with the When? and What? of the figures.
It helps to keep the commentary short and succinct for busy readers. One great technique is [...read more...]
Wednesday, 27 October 2010
Wednesday, 20 October 2010
Choice in Multi-Dimensional Planning and Reporting
There are a great number of multi-dimensional OLAP (OnLine Analytical Programming) software tools. These are changing all the time. At Softworld on Tuesday I was talking to various vendors to keep up to date with the leaders.[...read more...]
Wednesday, 13 October 2010
Forecasting and Reporting with SaaS
Recently I attended a seminar about a cloud SaaS-based planning, budgeting and forecasting system.This has been built by people from a background with leading systems such as Hyperion and Cognos Planning.
Potentially very valuable, for businesses that either can't afford such tools, or want something more flexible.[...read more...]
Potentially very valuable, for businesses that either can't afford such tools, or want something more flexible.[...read more...]
Wednesday, 6 October 2010
KPIs – Why? What? Who? When? Where?
Key Performance Indicators (KPIs) is a term that means different things to different people. Here’s a quick roundup:
Why?
When properly used, KPIs can dramatically improve business performance. [...read more...]
Do also see the series of articles on KPIs written last year.
Why?
When properly used, KPIs can dramatically improve business performance. [...read more...]
Do also see the series of articles on KPIs written last year.
Wednesday, 29 September 2010
Business Performance Management - Dashboards - Good, Bad or Excel?

The idea of management dashboards, taking the automobile concept into performance management, has been around since the 1970s. Best practice has advanced considerably, not least as technology has provided ever more powerful and cheaper solutions.
But as with anything powerful, the opportunity to do more harm than good is ever present. Cheap tools make it tempting to do a DIY job. That could prove very expensive. [...read more...]
Labels:
bpm bi excel
Wednesday, 22 September 2010
Business Performance Management - How Important Are Multiple Dimensions?
A few years ago a young AIM-listed client asked whether we could build a cash flow forecast model for their business. Their business plan had been to take two years to develop a major product, and in the meantime use two interim products to provide initial cashflow. These products hadn’t sold as well as expected, and further funding was needed.
The audit was imminent, and there needed to be a clear 12 month forecast to allow the auditors to provide a clean audit report. A major issue that was focusing my client directors’ minds somewhat!
We did indeed build a forecasting model. But in the absence of an affordable multi-user system, it was built in Excel. All sorts of issues, but the one to highlight here is trying to cope with multiple dimensions. [...read more...]
The audit was imminent, and there needed to be a clear 12 month forecast to allow the auditors to provide a clean audit report. A major issue that was focusing my client directors’ minds somewhat!
We did indeed build a forecasting model. But in the absence of an affordable multi-user system, it was built in Excel. All sorts of issues, but the one to highlight here is trying to cope with multiple dimensions. [...read more...]
Wednesday, 15 September 2010
Business Performance Management - Forecasting and Reporting
To manage overall business performance you need to establish the metrics that are key to the business, plan them, and then monitor progress of them.
So the value of quotes raised may be critical. Or the activity on your website. Or whatever else is key to your business.
By setting targets, plans can be out in place for the resources and organisation to achieve them. Monitoring performance against targets is a key step towards control. [...read more...]
So the value of quotes raised may be critical. Or the activity on your website. Or whatever else is key to your business.
By setting targets, plans can be out in place for the resources and organisation to achieve them. Monitoring performance against targets is a key step towards control. [...read more...]
Thursday, 9 September 2010
Performance Management - How Can You Gain From KPIs?
You're in business to make money. You need to make profits. You also need to generate cash. No doubt you monitor and report upon some key results - revenue, gross margin %, bank balance - that sort of thing. You probably call them KPIs (Key Performance Indicators)
But can you control these numbers? Well yes indirectly. But not directly. What you can control directly are [...read more...]
But can you control these numbers? Well yes indirectly. But not directly. What you can control directly are [...read more...]
Labels:
kpis driving
Wednesday, 1 September 2010
Performance Management - Gauges in Excel Dashboards
Just a reminder that if you've been hunting for gauges to add to your Excel dashboard, then here they are!
There are a wide set of different styles configurable, one of which is as in the diagram.
We've arranged a free trial if you'd like to try the gauges out
.
There are a wide set of different styles configurable, one of which is as in the diagram.
We've arranged a free trial if you'd like to try the gauges out
.
Wednesday, 25 August 2010
Performance Management – Multi-dimensional BI tools

For those of you familiar with “cubes”, the idea of being able to report on data in any combination of a multitude of dimensions (time, geography, team, etc) is very familiar.
Such analysis is usually carried out by some form of multi-dimensional business intelligence (BI) software tool, usually termed OLAP (OnLine Analytical Processing). [...read more...]
Wednesday, 18 August 2010
Performance Management - Avoiding Project Failures

Who at a senior level in business doesn't know of an IT project that has failed to provide anticipated benefits, or indeed failed completely? Whether it is a large ERP, a mid-sized CRM or a small accounting system, IT projects have a habit of going wrong.
In the worst cases, the company can go bust (as happened with a botched SAP implementation I know about). In others it's money down the drain, and opportunities lost. But when IT projects go well, the benefits can be enormous.
The line between success and failure is no more [...read more...]
Labels:
BPM BI
Thursday, 29 July 2010
Performance Management – A Cautionary Tale

It’s interesting to see news that BP’s Tony Hayward has stepped down as Chief Executive, effective 1 October. This is not just for failing to adequately handle the PR aspects of the spillage in the Gulf of Mexico. But as is becoming increasingly clear, the disaster looks like it was a result of cutting costs to the point of taking unacceptable risks, and management ignoring warnings from staff.[...read more...]
Labels:
bp risk
Wednesday, 14 July 2010
Performance Management - Types of KPIs

Talking to businesses of all sizes, the term “KPIs” means different things to different people.
Yes the letters stand for “Key Performance Indicators”.
But some people just think of them as revenue, profit and other measures of performance. Is that all?
The real power comes when you consider what factors drive business performance, and how [...read more...]
Thursday, 1 July 2010
Performance Management - Just fight crime, Theresa May tells police

That’s great, but how can this be reconciled with “If you don’t measure it you can’t manage it”? That’s an important question. Should every business and organization in the land follow suit and drop their KPIs (Key Performance Indicators)? [...read more...]
Wednesday, 16 June 2010
Performance Management - KPIs and the Brewery Analogy

Yes, that got your attention! But why the association between KPIs and breweries?
KPIs are of two types:
(1) KPDs – Key Performance Drivers
(2) KRMs – Key Results Metrics.
Let’s think for the moment of a business as a money-making machine. There are typically a number of [...read more...]
Labels:
KPIs
Subscribe to:
Posts (Atom)