This dangerous mistake while comparing percentages: I really don’t know how the world is still working. This is probably the most useful service I have done to humanity till date! It is dangerous mistake and is extremely common.
Read it NOW or view the 5 min video. Share it with everyone you love.
Continue reading Are you making this dangerous mistake while comparing percentages?
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.
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
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
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
Let us explore numeric grouping in Pivot Table with the Ageing Analysis scenario. Estimated reading time 7 min
Estimated time saving – hours!
Continue reading Ageing Analysis (Numeric Grouping in Pivot) – Part 2