You learned that you can perform a join analysis on two data objects and view the degree of overlap between the data objects. You also learned that you can run a column profile on a data object and view values, patterns, and statistics that relate to each column in the data object.

You created the

JoinAnalysis

profile to determine whether data from the

Boston_Customers

data object can merge with the data in the

LA_Customers

data object. You viewed the results of this profile and determined that all values in the

CustomerID

column are unique and that you can merge the data objects successfully.

You created the

All_Customers

profile and ran a column profile on the

All_Customers

data object. You viewed the results of this profile to discover values, patterns, and statistics for columns in the

All_Customers

data object. Finally, you ran the Data Viewer to view rows containing values and patterns that you selected, enabling you to verify the quality of the data.