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.
Continue reading Don’t just make charts the way boss wants. Use Recommended Charts
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.
Continue reading Power Map Example: Plotting Flight Path
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.
View it in full screen mode. For detailed read Data Analytics: Knowledge Pack
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
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.
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
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.
Continue reading Macro to Explode Pivot table by Filter Field Items
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)
Continue reading Unknown Gems: Explode Pivot Table by each filter item
Common requirement. With raw data and Pivot Tables. View or Filter. Here is how…
Continue reading Top 10 and 10% items: View and Filter
Most probably, you have been missing this Auto-copy feature for the last 8 years. Take 3 minutes to find out how it can simplify your life and increase accuracy.
Continue reading Excel Tables 6 – Miraculous Formula Auto-Copy