Site logo white shadow

Auditing Data using Pivot tables

I wrote an article about Data Audit using Pivot long back. Now, I have converted it to a comprehensive video. Have a look:

How to perform Data Audit using Pivot

Raw data can contain many columns and thousands of rows. Checking the consistency and accuracy of data cannot be done by simply scrolling and eyeballing the data. Too time-consuming.

Often we do not check the quality of input data at all. We just go ahead and create pivot table based reports to analyze the data. If you have errors in the raw data, the output will also be erroneous. That is why it is mandatory to check the input data quality.

The concept is to use each column in Row area of Pivot one by one and look at the top and bottom areas – which usually show the inconsistencies.

Incidentally, I am working on a detailed course on Pivot Tables. Yes, I know there are thousands of such courses and books available. But still there is a need to understand Pivot Table from a business point of view. In addition, most Pivot Table books do not cover Power Pivot and vise versa. I will cover both in a single integrated course on Udemy. It is titled “Pivot Table – Second Honeymoon” Smile

Watch this space for information about availability of this course. Coming soon…

Queries | Comments | Suggestions | Wish list

Subscribe to Blog

Join 1,758 other subscribers

Popular articles

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.