This year teams will be taking the position of data analysts working for Traveler’s insurance. You will be assigned to work with a “business partner” that is not familiar with data analysis. They would like you to perform retention analysis based on historical policy data and they are mainly concerned about the company’s retention rates as well as key drivers. You will be able to access 4 years’ worth of policies (.csv files) to analyze and come up with a proposal on how to tackle their retention policy issue. Although this is the general prompt you will be provided with more information during the kickoff.

The final output should include some form of analytics using any combination of (Excel, SQL, Python) and it is up to the team to choose what they want to use based on comfort level. During the final presentation is will be expected to talk through how you did some data aggregation and display some examples via tables and/or charts/graphs. Additional workshops on Python and Tableau will be provided throughout the weeks of the competition.

Participant Information

Teams

Teams must be composed of three students (recommended to have at least one member familiar with some analytics tools). Teams can pre-register together on the website or choose to form during the kick-off meeting. If you don't have a full three member team or you are a single student that is interested please make sure to attend the kickoff meeting so we can find a way to form full teams. Although this case is based in the analytics field, it is recommended that teams are diverse in major, interest, and overall ability. If a team is interested, at least one team member must attend the kickoff meeting.

By Wednesday of that week, a confirmation email will be sent out to all teams confirming their participation in the competition. All teams will also be required to create a team name to be associated with.  Questions regarding the case can be emailed to the competition coordinator up until the day of presentations. 

Competition Guidelines

Presentations are limited to 10 minutes in length. Time warnings at 5 and 1 min(s) before the end of the presentation will be provided. Presentations will be stopped at 10 minutes sharply. The Question & Answer section is limited to 5 minutes in length. Q&A will be stopped at 5 minutes sharply.

Presentations are required to be done using Microsoft PowerPoint 2016 or higher

Presentations are going to be judged on 4 separate categories (Each category out of 10 - max 40 points, the final score is the average of all judges total):

  • Data Analysis Finding
  • Visualizations and Reasoning
  • Documentation
  • Final Group Presentation  

Competition Guidelines

Once all teams have presented the judging panel will deliberate and set a first, second, and third place team. These teams will be announced at the awards meeting later that day. 

All resources found online or with other sources can be utilized, but must be referenced. Teams should not be discussing the case solutions among each other because there is no one right solution. Those presentations that are too alike will not be scored as highly because they lack innovative and out of the box thinking. Teams are encouraged to get feedback from faculty, staff, advisers, etc however all slides must only be created by members on that team.

For any questions about the competition or any guidelines please contact jonathan.a.moore@uconn.edu 

Schedule

Event Date & Time Location
Team Registration Monday, March 21st Email
Kick-Off Meeting Monday, March 28th 

5:30pm - 6:30pm

 Meeting Link
Deadline for Team Registration Thursday, March 31st Email
Mentor Sessions See Schedule Meeting Link
Case Sent Out Friday, April 1st Email
Case Presentations Friday, April 8th TBA
Award Meeting Friday, April 8th Meeting Link

 

Scholarship Awards

Place Scholarship Total
First Place $500/ person $1500
Second Place
 $250/ person $750
Third Place  $125/ person $375