In this tip I will provide an overview of a completely free data profiling tool (at least as of the time of this post) that is easy to use if you are in the Microsoft database stack. You can download the IDERA SQL Profiling tool and immediately put it to work to perform basic column profiling and analyses. The tool will display a summary of the data contained in a selected table and each of its columns.
Use this tool on the following systems:
- Microsoft SQL Server: 2008 R2, 2012, 2014, 2016; 2017 Windows & Linux (provisional); Express, Standard, Enterprise editions
- Microsoft Azure SQL Database
- Amazon Relational Database Service (RDS)
IDERA SQL Data Profiler has some minor quirks but you can’t beat the price. Check out my review in the video above.
Just remember that data profiling should always be done initially before you start analyzing a new dataset or designing a new visualization. Always start with the basics.
If you find this type of instruction valuable make sure to subscribe to my Youtube channel.