Building domain/distinct values profiling
Domain values or distinct values profiling are really used to determine which values are populated and allowable for an attribute. Domain data profiling gives you an understanding of the information which will be available for the attributes and presented to the users.
Getting ready
Review your report mock ups and requirements from Decomposing the reports and requirements recipe of Chapter 6, Analyzing the Requirements, and identify all attributes which will be used in filters, drill paths, and page items to start with. Determine the source of record for this information using the Creating a source matrix recipe of Chapter 7, Analyzing the Source.
How to do it...
Domain values are normally good candidates for standardizing the information which will be presented to the users:
1. Identify the necessary attributes from the semantic data model which relate to the requirements from the report mock ups.
2. Use the data lineage to determine the source systems...
