A method prepares data for subsequent analysis. The method obtains a data model that encodes a data sources as a tree of logical tables. Each logical table has its own physical representation and includes logical fields. Each logical field corresponds to either a data field or a calculation that spans logical tables. The method associates each logical table in the data model with a corresponding concept in a concept graph. The concept graph embodies hierarchical inheritance of semantics. For each logical field, the method assigns a semantic role to the logical field based on a concept corresponding to a logical table. The method also validates the logical field based on its semantic role. The method also displays transformations to clean the logical field based on validating the logical field. The method transforms the logical field according to a user selection, and updates the logical table.
展开▼