Info > Data Mining > 3-1. DM and DW > Consistent, Clean Data
¢¹¢º Consistent, Clean Data
¢º often 80% or more of the time is spent bringing the data together
when a DW is not available.
¢º problems
¡Ø matching account numbers, interpreting codes, applying households, further delay the a analysis.
¡æ solution : DW
¡æ by DW, cleaned
¡æ the meaning of fields is well-defined and available through the metadata.
¡æ Incorporating new data into analyses is as easy as finding out what data is available
through the metadata and retrieving it from the warehouse.
¡Ù In short, DW moves the cleansing and upkeep of the data to a special group charged
with this responsibility.
Info > Data Mining > 3-1. DM and DW > Consistent, Clean Data