University of Wisconsin Extended Campus is now Wisconsin Online Collaboratives! This name reflects the partnerships of the 13 universities within the Universities of Wisconsin–our state's premier system of public higher education. Through these partnerships we will continue to support online degrees, certificates and courses–along with support services to you.

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.