When you run a data profiling task on a data source, the profile extracts and displays the column statistics from the data source, such as null values, distinct values, data types, and patterns. You can analyze the profile results to make business decisions.
For example, you are a data analyst and you want to analyze and report potential data issues in the Customer table such as the completeness and validity of addresses and email IDs. The accuracy of this critical data impacts the effectiveness of the company's marketing campaign. To accomplish this task, you create a data profiling task on the table, add Verifier and Cleanse assets as rules, and then run the profile. You can view the results or export them to a file to analyze the data.
When you open a profile after you run it, the following tabs appear:
•Results. You can view the profile results on this tab.
•Definition. You can view and edit the profile definition on this tab.
•Rules. You can view and edit the rules on this tab.
•Schedule. You can view and edit the schedule, email notification options, and advanced options on this tab.
You can edit the profile-related options, rules, schedules, and advanced options as necessary and run the profile again. You can run a profile multiple times and view the profile results for each run. You can also compare profile runs, compare columns in a profile run, and export the profile results to a Microsoft Excel file.