With over 20 years of experience working with data from a variety of industries, Automated Auditors is ready to handle your complex data management and predictive analytics needs. We are experts at merging disparate files, combining structured data with unstructured data, quantifying data, and preparing data for sophisticated predictive analytics. Our analysts are also adept at using SAS to develop predictive models for identifying fraud, waste, and abuse.
Our core strengths include data reconciliation and merging disparate files even if there is no common identifier. In a recent project, we combined over 17 files using a name as the common link. As with all names, misspellings abounded, and we utilized our proprietary fuzzy matching logic to merge the files together. Using this unique set of skills, we were able to completely re-generate the client’s Accounts Receivable year-end reports, while calculating and carrying balances for each customer from year to year.
Another area in which Automated Auditors excels is predictive analytics. Our statistical analysts have utilized both SAS and SPSS to conduct: ANOVA, linear and non-linear regression analysis, logistic regression, Cox proportional hazards model (using SAS Proc PhReg), t-tests, cluster analysis, and more. With predictive analytics, approximately 80-90% of the effort involves preparing the data for loading into sophisticated software. For example, preparing data for a Cox proportional hazards model often involves calculating each indicator at snapshots in time. This can be a tedious and time-consuming exercise. Many statisticians do not have the programming experience necessary to create a reliable, accurate data base that can be imported into sophisticated statistical procedures. But we do!