Don’t just make charts the way boss wants. Use Recommended Charts

There are two types of charts. First type is a chart which you create to interpret data more effectively. The second type is more common. These charts are created billions of times everyday – why? Because boss wants it that way!

In this article, I am going to attempt to change the mindset of all users of Charts. Please spend 5 minutes of your time reading this article and trying out a new thought process. I am confident that it will add value to your life.

image

Photo credit: Elsie esq. / Foter / CC BY and salendron / Foter / CC BY-NC-SA

Continue reading

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

Quick Analysis should NOT be done quickly!

Read the previous article to understand the context of this article. Quick Analysis gives you many types of data visualizations instantly. But that is NOT the real benefit. The real benefit – as usual – is elusive and difficult to grasp in this “instant” mode of living life.

image

Read on to find out what you are missing – even if you know how to use Quick Analysis!

Continue reading

Instant, Interactive 3D mapping of your data – Power Map

image It is now possible to create interactive 3D maps from your data right within Excel.

Power Map is a part of Power BI series of tools. It is free, powerful and wonderful.

Let us dive into it and see how it can transform the way we understand information.

Continue reading