Free Excel Dashboard Templates

Building dashboards is something many of us have to do on a regular basis. Designing dashboards is often a gut-feel exercise. Are you are fed up with debates about which colours to use, how much data to put on a graph and when to use colour? The good new is that there are research-based principles that give […]

BlinkReporting

Who is this workbook for?  BlinkReporting is for you if you: – Need to produce or revise dashboards and reports – Find your current reports and dashboards confusing – Are frustrated by the length, complexity and structure of your existing reports – Have many different styles of dashboards and reports in use and want to […]

How good are your reports? A design checklist.

The Brilliant Dashboards Checklist: A systematic approach to assessing your dashboard You may be trying to work out why your current reports aren’t working properly or wondering if you missed anything on your newly created masterpiece. This design checklist encourages you to consider each element of your design and to score it if you are […]

The Problem with Management Information

My local taxi company has been taken over.  It has been bought out by Taxi-Rank Services PLC. They have started to apply big business thinking to a small business. It is a revelation. As you know, “what gets measured gets managed” so the first job, post take-over, was to apply a little science to their […]

Old news? When not to put data in a dashboard or report.

Some information can be essential to know on a second-by-second basis (heartrate, stock prices or altitude) other information is naturally slower to change; staff survey results, seasonal totals or audit results, for example. A quick way to devalue a dashboard or report and to turn off readers is to put data in the report that […]

Dashboard? That’s just a posh name for a report, isn’t it?

I had an interesting conversation with a company lawyer a little while ago. We were discussing dashboards and she said “It makes me laugh when people talk about dashboards, it is just a posh way of describing a report!”. It made me think as it seems to be a common misconception. What is the difference between […]

A quick way to make horrific-looking, unreadable reports.

What’s the quickest way of making your report look rubbish and/or be unreadable? It’s simple, design it for one delivery format (A4 printed page, plasma, PowerPoint, Blackberry etc.) and then put in on another delivery medium. You know the symptoms, an Excel table pasted into a PowerPoint slide, a PDF that you can’t read on […]

Smooth bottoms and dashboard design

Most people don’t look at the bottom of their laptop. If they do then they will see one of two things: If it’s a Apple Mac the bottom with be smooth and (with the latest ones) completely featureless apart from four rounded rubber feet. If it’s a PC it will have little hatches, a Microsoft […]

How to build a brilliant dashboard – 10 essential tips

Here’s a quick summary of 10 key points you need to take into account when you build a dashboard.   1) Know your target audience You cannot make everyone happy with one dashboard. If you have more than one target group it may make sense to create a separate dashboard for each group. Be sensible […]

Why my phone bill is brilliant.

I’ve just had a bill through from Virgin. It’s not often I find myself smiling when I look at a bill, but this one was a bit different. Virgin have redesigned the bill and put a nice explanation in there as well, see this image (click on it for a bigger version).. I like this […]