Search

# Tag: Big Data

###### How to compare percentage values accurately

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

###### Beyond Pivot Table – Power BI inside Excel – video

Unbelievable analytics using Excel: [youtube https://www.youtube.com/watch?v=vcwPk3eUxkg?rel=0] Here is a quick overview of how we can analyze data more effectively using new Excel tools. You can also refer to the collection

###### Repairing Month Sorting Order in Power Pivot – Part 2

Here is the Power Pivot way of customizing sort order for any column. We will continue with the month sorting order example. Read the previous article first. Estimated reading time

###### Repairing Month Sorting Order in Power Pivot – Part 1

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

###### Miracle: Instant Report Clean Up using Power Query

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

###### Knowledge Pack: Data Analytics

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. Enjoy!

###### Ageing Analysis (Numeric Grouping in Pivot) – Part 2

Let us explore numeric grouping in Pivot Table with the Ageing Analysis scenario. Estimated reading time 7 min Estimated time saving – hours!

###### Ageing analysis in seconds (Number Grouping in Pivot Table)

Bin or Bucket Analysis is a common requirement. We will see how easy this is using Grouping feature of Pivot Table. Estimated reading time 10 min

###### How to correct spelling mistakes while analyzing data?

Grouping in Pivot table is one method of spelling mistakes correction. Here is another option for correcting mistakes using VLOOKUP. Estimated reading time 10 min Estimated Time Saving many hours!

## Pivot Table Pro Course

Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.

## Excel to Power BI Course

Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.

##### Subscribe to Blog

Join 1,745 other subscribers