Creating Custom Profiles Overview
A profile is the analysis of data quality based on the content and structure of data. A custom profile is a profile that you create when you want to configure the columns, sampling options, and drilldown options for faster profiling. Configure sampling options to select the sample rows in the flat file. Configure drilldown options to drill down to records in the profile results and drilldown to data rows in the source data or staged data.
You create and run a profile to analyze the quality of the data when you start a data quality project. When you create a profile object, you select the data object and the data object columns that you want to profile, configure the sampling options, and configure the drilldown options.
Story
HypoStores needs to incorporate data from the newly-acquired Los Angeles office into its data warehouse. HypoStores wants to access the quality of the customer tier data in the LA customer data file. You are the analyst who is responsible for assessing the quality of the data and passing the information on to the developer who is responsible for cleansing the data.
Objectives
In this lesson, you complete the following tasks:
- 1. Create a custom profile for the flat file data object and exclude the columns with null values.
- 2. Run the profile to analyze the content and structure of the CustomerTier column.
- 3. Drill down into the rows for the profile results.
Prerequisites
Before you start this lesson, verify the following prerequisite:
- •You have completed lessons 1, 2, and 3 in this tutorial.
Timing
Set aside 5 to 10 minutes to complete this lesson.