Western Reserve Group

Western Reserve Group 2016 AMRE Team

Data Mining Automation for Auto Insurance Data 

Team members: Scarlett Chen, Khoa Nguyen, Ralph Xu

Faculty advisors: Dr. Jennifer Bowen & Dr. Robert Wooster (Math)

Project Description: The goal of this AMRE project for Western Reserve Group is to automate the process of data extraction from Microsoft Access into Excel and to structure the data appropriately for future analysis in tracking losses and setting premium rates. We are given several Access tables and two Excel files that contain the necessary data and calculations for auto insurance. By creating new queries to establish the data connections between Access and Excel, and configuring the calculations to adapt to the dynamic data, users can now interact with the data in the Excel files directly, hence increasing the ease and efficiency of their work.