Task 4. View Column Profiling Results

1. Click Window > Show View > Progress to view the progress of the All_Customers profile.
The Progress view opens.
2. When the Progress view reports that the All_Customers profile finishes running, click the Results view in the editor.
3. In the Column Profiling section, click the CustomerTier column.
The Details section displays all values contained in the CustomerTier column and displays information about how frequently the values occur in the data set.
4. In the Details section, double-click Ruby.
The Data Viewer runs and displays the records where the CustomerTier column contains the value Ruby.
5. In the Column Profiling section, click the OrderAmount column.
6. In the Details section, click the Show list and select Patterns.
The Details section shows the patterns found in the OrderAmount column. The string 9(5) in the Pattern column refers to records that contain five-figure order amounts. The string 9(4) refers to records containing four-figure order amounts.
7. In the Pattern column, double-click the string 9(4).
The Data Viewer runs and displays the records where the OrderAmount column contains a four-figure order amount.
8. In the Details section, click the Show list and select Statistics.
The Details section shows statistics for the OrderAmount column including the average value, standard deviation, maximum and minimum lengths, the five most common values, and the five least common values.