Bernie
Assessing Report Design Objectively – Avoiding Fights
There are three situations where it can be a good idea to have a structured review of your reports and dashboards… If some of your team are in denial about the need to change existing reports You want some clear ideas on what needs to be included in improved dashboards or reports You have an…
Free Meetings Terms of Reference Template
Report bloat is a significant problem in many organisations. Much of this problem stems from the people producing reports and dashboards not being clear on how they are being used and which parts of their output are even looked at. In short, they don’t understand the purpose of their reports. To design reports and dashboards…
How we ‘really’ use management information…
When we are kids we have models of how we think things work. For example, stick people with arms coming from the middle of their bodies or the sky being a thick blue line across the top of a drawing. As adults we still carry lots of models in our minds, including how we use…
Dashboard design – lessons from Britains ‘lost bomber’
Part of being a geek includes dragging your family round aircraft museums. Wandering round the Imperial War Museum in Duxford last week I came across an impressive looking failure – the TSR2. Britain, like many wealthy countries, has a long and grizzly history of defence projects going wrong. The TSR2 was envisioned initially as a…
Too Many KPIs or Measures?
Why is it dangerous to have too many KPIs? Choosing the right number and type of KPIs is like walking a tightrope. Too many KPIs can lead to overload, confusion and frustration. Too few KPIs can mean you miss critical information necessary to keep your business, people or bottom-line safe. So, how do you manage…
How to measure “difficult to measure” things.
What lipstick, the Panama Canal and toilet breaks can tell you. There are some things that are difficult to measure, maybe even impossible to measure directly. The key with ‘difficult to measure’ things is to look at something that either affects or is affected by the thing you are interested in. Here are three examples of…
Painful report production? Why you should be worried…
The problem with a good Reporting/MI/Analytics team is that they make it all look too easy. They will often go through a very painful report production process (particularly for executive meetings) and deliver against all the odds. This usually involves heroic efforts of chasing, data manipulation and spreadsheet gymnastics. The reports get generated and the Reporting/MI/Analytics…
Defining KPIs: How the wrong KPI shut schools
Defining KPIs clearly is crucial. Badly defined KPIs have unfortunate side effects. The cobra effect is one of my favourites. Most people agree that going to school is good for children. This means that there is a government focus on truancy as a measure. Sometimes there are legitimate reasons why children cannot get to school. One such reason is snow. A singular focus on truancy…
Managing KPIs with Excel?
Are you managing KPIs with Excel? I often hear that Excel is not capable of managing KPIs but in reality that is rare. Consider this, your PC, laptop or tablet has more than a million times the computing power of the Apollo moon missions. Excel is an extraordinarily powerful, flexible and widely used application. So…
The wrong KPI. Dangers of the ‘obvious’ measure
A powerful example of wrong KPI is a measure used in call centres. Many of us have experienced a call centre agent who is clearly dying to get us off the line (even if they are scripted to hurriedly ask you ‘Is there anything else I can help you with today, Mr Smith?’). The…