Capstone Projects

Data Warehouse Development for Travel Reporting and Analytics

Program: Data Science Master's
Host Company: Berkshire Hathaway Specialty Insurance – Travel Program
Location: Stevens Point, Wisconsin (onsite)
Student: Calvin Friedenfels

This project was focused to improve the analytical situation for the Travel Leisure Program by incorporating the claims view into product analysis.  Devising unified KPIs, automating and standardizing data collection and transformation was required for the project.  Using the transformed data to conduct exploratory analysis on their product lines and build improved reports and dashboards was also completed.  Finally, the first steps in analyzing the trip cancelation coverage using Logistic Regression was done to analyze pricing parameters.