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!
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).
 |
It is a powerful but often ignored feature of Power Pivot. It allows you to describe the meaning of the data column – independent of its field name. Estimated reading time 8 min |
Continue reading Understanding Data Categories in Power Pivot
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
In the previous article, we saw how to create custom sorting order using a separate month table.Now we will see how a new type of table called Time Table can be an even better solution. Estimated reading time 7 min
Continue reading Power Pivot Month Sorting using Time Table – Part 3
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
|
Continue reading Repairing Month Sorting Order in Power Pivot – Part 1
Recently I conducted a session for BI team of a large customer.
This introduces the concept of end user BI to hard core developers.
Have a look. It will give you a different perspective.
2 hour video.
Reports generated from business applications often become inputs to new reports.
You end up spending too much time cleaning them up. Here is a new and unimaginably faster way of doing it – using Power Query.
Estimated reading time 15 min
Estimated time saving huge!
Continue reading Miracle: Instant Report Clean Up using Power Query