Category Archives: Analytics

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 blindly 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.

Excel Recommended Charts

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

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

Power Map Example: Plotting Flight Path

Hello from New Zealand. Here for 5 days conducting over 15 sessions for key customers.

We have seen how to use Power Map for Excel and create geographical visualizations. Read these articles for details. We will plot a flight path using Power Map in this article. Here is how it looks.

image

Photo credit: lebribri / Foter / CC BY-SA

Continue reading Power Map Example: Plotting Flight Path

CIO Perspective: SMAC – Session Video

I conducted a session on Social, Mobile, Analytics and Cloud (SMAC) in the CIO CROWN 2015 conference yesterday. Results of an informal CIO survey were presented along with key best practices in analytics space. Of course, lots of demos were shown as well.

You can download this 35 min video from here. (86 MB, Zip file)
Due to a problem with the mic, the audio quality is poor. Sorry about that.

SMAC Video:

Session on SMAC

View it in full screen mode. For detailed read Data Analytics: Knowledge Pack

HR, Sales, Marketers: Enhance your credentials with Power View

Yes. That is right. If you have worked with lots of customers, providing a list of customers consumes lot of space and nobody reads it anyway! Why not show the customers you have worked with in a region or globally by plotting them on a map? Here is how you do it in Power View.  It takes just 2 minutes  if you have the data ready.

Continue reading HR, Sales, Marketers: Enhance your credentials with Power View

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.

example for Visual Interpretation Error

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

Continue reading Caution: Visual Interpretation Error in Data Analytics

Macro to Explode Pivot table by Filter Field Items

Refer to the previous post. We saw how Filter fields can be exploded into individual sheets and files. In this article, I am releasing a macro – which does all the hard work for you. Of course, you must use it at your own risk. The source code is also included for you to view, learn from and modify. Created by Raj Chaudhuri and myself.

PivotFilterExplode macro

Photo credit: Johnson Cameraface / Foter / CC BY-NC-SA

Continue reading Macro to Explode Pivot table by Filter Field Items

Unknown Gems: Explode Pivot Table by each filter item

Suppose you have Products in Filter area and Pivot Table shows Regional Sales by Month. There are 5 products. You want five sheets for each product separately- this is called Explode Pivot Table. But not by doing this manually. Here is how you do it (Reading time 7 min)

image

Continue reading Unknown Gems: Explode Pivot Table by each filter item