Why do we visualize our data, and why should we try to move beyond crosstabs (or tables)?
So often end-users will ask for a table, not unlike Excel (which they may be more familiar with).
But finding you answer quickly in a table is not easy.
The human brain is able to store roughly 7 items, and sometimes less, in their short-term memory.
Scanning a table for information is stretching our capabilities as a human, and will require more effort.
A classic example is comparing number within a table or comparing them within a graph.
Which shipping mode has decreased the most in average profit?
Have a short look at the table below
And now have another look at the line chart below
If you could choose which representation you could use, which would be easiest to make the comparison?
Most people would chose the graph which is not strange considering here you would only need to compare 4 patterns.
Whilst the table would require you to remember 16 numbers, which is difficult considering we can usually remember around 7 items using our short-term memory.
Would you like to learn more about dashboard design and visual analytics? We regularly host a dedicated training about this, click here for more info!
Header image from: Andy Kriebel (@VizWizBI). Screenshots from author.