Tag Archives: data cleanup

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 doing it – using Power Query.

Report clean up using Power Query

Estimated reading time 15 min
Estimated time saving huge!

 

Continue reading Miracle: Instant Report Clean Up using Power Query

Knowledge Pack: Data Accuracy in Excel

We take accuracy of Excel data for granted.

Often the raw data as well as results of formulas can be wrong, outdated or misleading.

Here is a collection of 13 data accuracy articles which will help you ensure the integrity  of  your Excel data with minimal effort.

Excel data accuracy knowledge pack

Continue reading Knowledge Pack: Data Accuracy in Excel

DO NOT copy paste data from browser. Use Power Query.

This is a common activity. Go to a browser page, find some tabular data or report and copy-paste it into Excel. Now you waste a lot of time cleaning up the unwanted things which also got pasted.
If you have Excel 2010 or above (Professional Plus or Office 365 edition),
you have a miraculously simple method available now : Power Query

stop copy pasting from browser - by Dr. Nitin Paranjape

Continue reading DO NOT copy paste data from browser. Use Power Query.

Worst Practice: Using formatting as a substitute to information

Experts tell us the best practices. But we do lot of mistakes before we can find the best way. Documenting the mistakes – which is what I call “Worst Practices” is also important.

This worst practice is very common. I have found it across the world and across industries. Read on and confirm that you are not making this mistake.

image

Continue reading Worst Practice: Using formatting as a substitute to information

Bad Data to Good Data: Fill gaps using Power Query

This is a continuation of a series on how to convert badly formatted data into an easy to analyze – tabular format. In this article, we are talking about data which has gaps and how to fill gaps efficiently. This is a new approach available using Power Query – it is fast and effective. Have a look and save hours of your precious time.

fill gaps in data using Power Query

Continue reading Bad Data to Good Data: Fill gaps using Power Query