Problem: Significant volumes of data requires cleaning prior to being processed. It is a labour intensive and error prone process to address repetition, inconsistencies, and errors in the data.
Solution: A model was developed to help automate and expedite the cleaning and processing of data, reducing human effort.