Dashboards were an early entry into executive information systems
[EIS]. Compared to web-based EIS today, they may appear rather static,
but the reality is that whilst the user interface may remain unchanged,
the back end technology is highly dynamic.
With so many dashboard development tools available, designing a
dashboard is a relatively simple matter. However, there are a few
key design elements that not only enhance the appearance of the
dashboard, but also its effectiveness.
The aim is to increase both the visibility of the information being
presented and the memorability of the measure.
- Make all data relevant to the role and business
- Use different graphic formats for each major KPI group
- Provide levels of granularity using drilldowns
- Locate interdependant functions side by side
- this allows for instant recognition if the increased performance
in one metric is at the expense of another.
- Use a plain background, patterns and bold colors are distracting
and reduce visibility and memorability of portlet graphics.
- Keep portlet icons and charts simple and clean
- Pie Charts can be difficult to visually compare the sizes of
pie slices - bar charts are much clearer.
- Order values by size, from large to small or vice versa. Ranking
adds significant visual value.
- Provide text labels to graphical representations
- Use colors known to associate with day to
day functions - red [danger], green [good], orange [alert], yellow
- Limit colors and consider what the dashboard would look if it
was photocopied or printed in black and white
- Ensure all dashboards use the same colors and icons
in the same way - this provides for cohesion of information presentation
across the company.
- Avoid getting too cutsey in design - the aim is to quickly disseminate
information with clarity and memorability - and please, avoid
using a car dash design.
- Avoid over-crowding - leave plenty of space
around each portlet. It is better to create a second dashboard
than to provide one crowded, confusing one.
- Deliniate rows of data using blue:white - this
avoids mistakes in horizontal eye movement. If the table is able
to be manipulated, add shading using Conditional Formatting -
this keeps the desired shading without any effort. This is achieved
by using a =ROW()=EVEN(ROW()) formula as a conditional format
across the entire table.
- Put the most critical information upper left
- its where the eyes naturally fall first.
- Provide contextual help - using question marks
to open popup windows to explain KPI's
Back To Top