Caution: Visual Interpretation Error in Data Analytics

We have seen how to put data bars in Excel (Bar charts with a difference). These help us compare any value with any other value visually. This helps us understand patterns in the data.

image

If not used properly, this great feature can lead to confusion and misinterpretation as well. Here are common scenarios and the solutions.

Continue reading

High, Medium, Low – visual categories – In-Depth

Please read the previous article so that you understand the context of this article.

In the previous article we saw how to divide available data into three categories: High, Medium, Small. In this article we will explore how to refine this process and have up to 5 categories of classification. We will also see how business context helps you decide the type of visualization.

image

Continue reading

Show High, Medium, Low values in few clicks

We get lot of┬ádata and reports every day. Usually, to understand the information easily, we draw charts. Nothing wrong with that. Except that there are other methods available which may be more effective. Here is one such method which divides the data into three categories – high, medium and low.

image

Continue reading