Data Cleansing
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.