Table column analysis/profiling tool?

Hello,

Is there a tool (preferably freeware) that can analyse tables and present results like below?

Table name	Column name	data type and length	Minimum value	Maximum Value	Minimum Length*	Maximum Length*	Distinct Count	Null count	Null percentage	Top 3 values	Bottom 3 values
dbo.Customer	JRBTGRP	varchar(50)	'Home'	'Joint Partnership'	4	17	27	340	2.3%	'Home', 'Public', 'Government'	'Private', 'Charity', 'No rebate'
dbo.Customer	JRBTLDN	numeric(10,2)	0.0	24.67	-	-	675	2	0.04%	2.45, 2.23, 1.75	0.45,0.0, 4.10

I am in the process of doing a data analysis and profiling prior to developing a data mart. It helps me immensely if I can generate results like this for source database tables.

Could some experienced data analysts shed some light?

Thanks

I think this is what you are looking for. It is easy to get up and running and is open source.

Search google for "Talend Data Quality". I am new to the forum so I can't send you the direct link.

- dave

Until Dave's noob time passes...

http://www.talend.com/products-data-quality/matrix-data-quality.php

Thanks Dave and Elmorejr.

I've used Talend open profiler. I could not get it to do last two columns ("Top 3 values", "Bottom 3 values").

Also, is there a way to re-organise the Talend's output as I listed above?
I've noticed that the above format shows just enough information without taking too much space, which is handy when working with 50-100 tables.
The above info can be presented in MS Excel spreadsheets and further adhoc filtering can be done with Excel's drop down filters.

Hi Sman,

There's a set of SSRS reports that came with the Kimball Microsoft Data Warehouse Toolkit book - you can download them from here:
http://www.kimballgroup.com/html/booksMDWTtools.html

I'm referring to the Data profiling reports. Being SSRS, you could extend or modify the reports to suit your requirements.

There's also a Data Profiler tool that comes with SSIS.
http://technet.microsoft.com/en-us/library/bb895310.aspx
http://consultingblogs.emc.com/jamiethomson/archive/2008/03/02/ssis-data-profiling-task-part-1-introduction.aspx

Both are limited to SQL Server tables as the data source.

Good luck!
Mike