Year: 2011
4 Dos and Don’ts For Leveraging KPIs to Improve Business Results
Leveraging KPIs does not always go as planned Rewind 20 years ago, our systems and processes did not always provide the data and reporting that we needed to effectively run our business. Today, with the incredible advances in most CRM, BPM, ERM (insert acronym here) systems, we often have too many numbers available to us.…
Using data to become a millionaire
It’s hard to believe, but many companies still see the data they collect as “a drain on IT systems” I really recommend reading this item on the couple behind the Tesco Clubcard scheme. It’s a brilliant tale of using high quality data to give a huge competitive advantage (“it is estimated that since its introduction…
“Compressor on”, how to label your reports more clearly
I just poured myself a cup of water from the water chiller. I noticed that it helpfully offers two temperatures of water and has a little light with “Compressor on” next to it. Why would you put this on a customer facing display? What they really mean is “this water cooler is working and cooling…
Design Principles for an Effective Management Control System
Here’s a 30 second guide to what makes up a management control system. A clear set of strategic objectives A method for translating strategic objectives into practical measures and KPIs that every person in the organisation can affect in some tangible way Trusted, clear and accurate management information. Produced in timely way, to the right…
How to keep your reports short and effective
Which is the easier question to answer?: “Tell me about France” or, “Tell me about the restaurants in the village of Venosc that serve Italian food” ? It’s very obviously the latter (assuming you have the information available in the first place). It’s the difference between these two questions that explains how some reports can be…
Buying rugs and broken broadband connections
There’s something curious happens when you write a number down. It somehow becomes “official”. I realised this a few years ago when haggling for rugs in India. The traders would write down the figure on a piece of paper and show it to you when you were haggling. I naively assumed this was to avoid…
First look – Qlikview Review – Version 10 Personal Edition
As promised in my last “first look” review, I’m taking Qlikview 10 for a spin. For those of you not familiar with Qlickview it’s a data visualization tool that’s designed to make the creation of ad-hoc reports and dashboards, from existing data, quick and simple. Installation Getting hold of Qlikview is a matter of registering…
Guest Blog: The 12 Characteristics of Good Performance Measures
KPIs are critical for the success of any organisation. They are a measure of progress against goals. However, not every measure is a KPI. Put it in the words of Albeit Einstein,“Not everything that can be counted counts, and not everything that counts can be counted”. Good performance measures allow for comparisons to be made…
Spooks, Star Trek and KPIs
Like 4.6 million other people, I enjoy Spooks. I do find myself wincing a bit when Harry, or whoever, makes completely random requests of his spy geeks and they always come up with the goods – you know the kind of thing – “can you cross reference that train ticket with his gardening bill and…
First look – Tableau 6.1, Data Visualisation Software
I spend most of my time with clients trying to get more out of their existing tools, more often than not some combination of an ERP tool (JDEdwards, SAP etc.) a selection of more “pure” databases such as Oracle, Access, SQL and a lot of spreadsheets. All of these tools have well understood strengths and…