Many data warehousing projects fail due to poor quality of
data. Using tools such as Data Junction, Access and Microsoft SQL Server, we
worked with several companies at establishing metrics and methodology to
perform data cleansing. Once data is mapped to a clean and common code set, all
reporting activity can be done in a timely manner.
Case Study 1
In implementing a Data Warehouse, we utilized data cleansing methodology to
ensure consistent, error-free data. This included remapping of data that was
incorrectly coded in the carrier’s core system.