Data Cleansing for Research Study – for a top Canadian University, Academic Research Paper
A research project required analysis of over one million data observations that originated from several different sources. These needed to be joined and cleaned up i.e. the data was not always consistent in spelling, format, layout, etc. After the data was joined and cleaned, it would need to be analyzed using sophisticated statistical software packages.
All it really took was to drag and drop the data files onto the FreeSight desktop. FreeSight matched and linked the data up properly. From there it was simple enough to use FreeSight’s analysis tables with easy sort and filtering capabilities to query the data for consistency and accuracy. Whereas FreeSight contains formulas and mechanisms for some statistical analysis, in this case FreeSight delivered a clean dataset to be used by Stata Statistical Software.