We get data and make reports repeatedly. Often we forget to look at the same data in different ways. Due to this unbelievable amount of useful information is lost.
Act Now is a new idea I am trying. It asks you to do some activity and post the results.
Continue reading Act Now: Discover one new and useful thing from familiar data
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.
Read on to find out what you are missing – even if you know how to use Quick Analysis!
Continue reading Quick Analysis should NOT be done quickly!
We are used to bar charts. But do you know that we can add bar charts within cells? Have a look and see what you were missing all this while! (These have been there for 8 years).
Continue reading Bar charts with a difference
Unbelievable analytics using Excel:
Here is a quick overview of how we can analyze data more effectively using new Excel tools. You can also refer to the collection of 51 articles about data analytics for a more detailed coverage. Data Analytics: Knowledge Pack.
This is a very common and dangerous inaccuracy.
Big operational risk!
Check all your dates imports after reading this article.
Share it with your colleagues as well.
Estimated reading time 15 min
Continue reading Global Alert: CSV import Date Misinterpretation Problem – Part 2
Yes. You read it correctly. Everyone does it. But still.It is very dangerous.
DO NOT do it.
Read on to find out why.
Estimated reading time 7 min
Continue reading NEVER import CSV files into Excel – Part 1
Here is the Power Pivot way of customizing sort order for any table.
Read the previous article first.
Estimated reading time 8 min
Continue reading Repairing Month Sorting Order in Power Pivot – Part 2
||If you use text month in a Power Pivot Table, it is sorted in alphabetical order.
Here is the solution to the problem.
Quick Solution time 2 min
Detailed reading time 15 min
Continue reading Repairing Month Sorting Order in Power Pivot – Part 1
Data Analysis and Reports has been a major theme for my articles so far.
Here is a collection of 50+ articles, categorized and sorted in the recommended reading order.
Continue reading Knowledge Pack: Data Analytics
Please read the previous article first. Filters are not just for filtering. They also convey additional information. Very useful feature. Check this out.
Estimated reading time 10 min
Continue reading New way of filtering reports: Slicers – Part 2 (Filtering Filters)