what is data profiler?

A data profiler is a tool that has the capability
to analyze data, such as finding out how many rows are in each table, how many rows
contain NULL values, and so on.