Chapter 2. Business Intelligence architecture overview 11
It involves changing the resolution of hidden business rules in data fields, such as
account numbers. Also the structure and the relationships of the data are
adjusted to the analysis domain. Transformations occur throughout the
population process, usually in more than one step. In the early stages of the
process, the transformations are used more to consolidate the data from different
sources; whereas, in the later stages, data is transformed to satisfy a specific
analysis problem and/or a tool requirement.
Data warehousing turns data into information, on the other hand, data cleansing
ensures that the data warehouse will have valid, useful, and meaningful
information. Data cleansing ...