BI & Visualisation
Intelligence, not Information – Presenting Your Message
Organisations base most of their tactical and strategic decisions on ‘the numbers’: it seems like a trivial thing, but the way you present your final numbers can have a huge impact on whether people digest what they say, and hence make the right decisions.
Numbers are often produced by accountants but also sales & marketing and supply chain planners amongst many other operational users, often in big spreadsheets with hundreds of rows and multiple tabs. They create detail and order, and ensure that every little bean is accounted for. This helps the Board to sleep well at night, knowing that their Finance & Operational teams have all the numbers under control.
Unfortunately it doesn’t help senior management or the Board in actually understanding what’s going on in their business. Senior managers have short attention spans, and just don’t have the patience to sift through all of these spreadsheets, looking for problems hidden deep within the numbers.
There are a number of solutions on the market and ultimately the right solution will be based on your individual use case requirement and potentially existing architecture. We have designed and built solutions with IBM Cognos BI, Tableau and Motio amongst others but ultimately it is all about the design and telling the story.
Which Numbers? Choosing your KPIs
So we need to cut down on the numbers. But which ones do we keep? And, more importantly, how do we convince our more detail-hungry stakeholders to live without the rest?
It’s all about ownership, buy-in and creating consensus:
Sourcing your Data
Before you open your new reporting tool and start designing dashboards, take a step back and think about where your data is coming from. The more ‘structured’ your data is, the easier it will be for you. A dashboard built on unstructured and inconsistent data, no matter how slick it looks, is like building a castle in the air – sooner or later it will come crashing down, and all your work will have been wasted.
|Unstructured Data Examples||Data Source Issues|
Of course, unstructured data isn’t all bad – for ‘real-time’ operational reporting you’ll have to use it raw and unadulterated.
Ideally, what you really want is a dimensionally-modelled data mart, with nice clean reliable data from multiple sources. See what your IT department already has, or have a look here for some tips to tackle it yourself.
Charts, Tables or Text?
There are a few basic rules though:
At the end of the day, every organisation is different and you need to find your own approach that suits the personalities involved. It would also be a good idea to come and talk to the Business Intelligence team at PMsquare – we’ve done this hundreds of times across almost every industry sector.
If you’ve got big ideas for your reporting framework, and want someone to bounce them off, contact firstname.lastname@example.org today.
Case Study – Coates Hire Operations
“We wanted a simpler way to deliver information, one that wouldn’t tie our guys up in spreadsheets,” says James Welch, Chief Financial Officer at Coates Hire. “We realised that a summary-level dashboard could give our brand managers an instant overview of what the top priorities should be, and we also wanted a capability to drill down, right to the source.”