Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

Did you know? SQL Server 2008 includes Data Profiling Task screencast

Posted by denglishbi on April 6, 2008

SQL Server 2008 includes Data Profiling Task:

The Data Profiling task is a new task in the Integration Services toolbox. You can use this task inside an Integration Services package to profile data that is stored in SQL Server. The information provided by the profile helps you identify potential problems with data quality. The Data Profiling task provides profiles that help identify data quality problems within individual columns and with column relationships:

Profiles that help identify problems within individual columns

· The distribution of lengths in the column values.

· The percentage of null values.

· The distribution of values in the column.

· Column statistics for numeric columns.

· Regular expressions that match string columns.

Profiles that help identify problems with column relationships

· Candidate key columns.

· Functional dependencies between columns.

· The inclusion of the set of values in one column in the set of values in another column.

Read more about this in the SQL Server 2008 BOL ‘Data Profiling Task’.

Check out a screencast about the new data profiling task feature in SQL Server 2008  here.

Did you know? SQL Server 2008 includes Data Profiling Task from Dan English on Vimeo.

If you are interested in additional information in regards to this topic check out these other blog postings:

http://www.sqlskills.com/blogs/stacia/2007/11/27/SQLServer2008DataProfilingTaskTheQuickVersion.aspx

OR

SSIS: Data Profiling Task: Part 1 – Introduction
Data Profiling Task: Part 2 – Column Length Distribution
Data Profiling Task: Part 3 – Column Null Ratio
Data Profiling Task: Part 4 – Column Pattern
Data Profiling Task: Part 5 – Column Statistics

Data Profiling Task: Part 6 – Column Value Distribution
Data Profiling Task: Part 7 – Functional Dependency
Data Profiling Task: Part 8 – Candidate Key
Data Profiling Task: Part 9 – Value Inclusion

SSIS: Data Profiling Task: Part 10 – Parsing the output

and if you want to know how to dynamically profile tables check out this blog posting which includes the code here.

Did you know? SQL Server 2008 includes Data Profiling Task from Dan English on Vimeo.

If you are interested in additional information in regards to this topic check out these other blog postings:

http://www.sqlskills.com/blogs/stacia/2007/11/27/SQLServer2008DataProfilingTaskTheQuickVersion.aspx

OR

SSIS: Data Profiling Task: Part 1 – Introduction
Data Profiling Task: Part 2 – Column Length Distribution
Data Profiling Task: Part 3 – Column Null Ratio
Data Profiling Task: Part 4 – Column Pattern
Data Profiling Task: Part 5 – Column Statistics

Data Profiling Task: Part 6 – Column Value Distribution
Data Profiling Task: Part 7 – Functional Dependency
Data Profiling Task: Part 8 – Candidate Key
Data Profiling Task: Part 9 – Value Inclusion

SSIS: Data Profiling Task: Part 10 – Parsing the output

and if you want to know how to dynamically profile tables check out this blog posting which includes the code here.

Advertisements

One Response to “Did you know? SQL Server 2008 includes Data Profiling Task screencast”

  1. Jamie said

    Great video Dan! I’ll be pointing people here!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: