Problem Statement
Welcome to the world of Assurance!
Today, you need to help Mr. Assurenaut, CEO of AssureNext. AssureNext is a radical insurance company which sits at the intersection of technology and human interaction.
AssureNext has brought some radical changes in the way they distribute Insurance. The first such call was to do away with all traditional distribution channels. So they have no bank tie ups, no agents or any online sales.So, how do they distribute Insurance to end consumers? This is where their innovation comes in. They have created a new channel called "Robossurance", where they are installing smart machines in various locations.
These machines study the consumers in these locations and suggest the best Insurance plans for these customers. Currently, AssureNext is installing these machines in book stores and fine dining restaurants.
AssureNext started in 2009 and has grown multi folds in last 6 years. The company has been facing some challenges lately with manufacturing and scaling up. The customer acquisition rate has not increased as was expected in initial years. Also, the customers have grown blind to the presence of these machines over time.
Mr. Assurenaut is in a tough situation. There is a board meeting starting in 3 hours, where the board will review the future plan for AssureNext.
You need to help him create his plan and presentation.
Description of sheets in excel file is provided in "Instruction" sheet.
Calc & Cons.Pivot are the sheets where I tried to Solve.
Thanks in Advance for your support & Consideration
Mod Edit: Original contest is over, link to site
http://datahack.analyticsvidhya.com/contest/mini-hack-excel
Welcome to the world of Assurance!
Today, you need to help Mr. Assurenaut, CEO of AssureNext. AssureNext is a radical insurance company which sits at the intersection of technology and human interaction.
AssureNext has brought some radical changes in the way they distribute Insurance. The first such call was to do away with all traditional distribution channels. So they have no bank tie ups, no agents or any online sales.So, how do they distribute Insurance to end consumers? This is where their innovation comes in. They have created a new channel called "Robossurance", where they are installing smart machines in various locations.
These machines study the consumers in these locations and suggest the best Insurance plans for these customers. Currently, AssureNext is installing these machines in book stores and fine dining restaurants.
AssureNext started in 2009 and has grown multi folds in last 6 years. The company has been facing some challenges lately with manufacturing and scaling up. The customer acquisition rate has not increased as was expected in initial years. Also, the customers have grown blind to the presence of these machines over time.
Mr. Assurenaut is in a tough situation. There is a board meeting starting in 3 hours, where the board will review the future plan for AssureNext.
You need to help him create his plan and presentation.
Description of sheets in excel file is provided in "Instruction" sheet.
Calc & Cons.Pivot are the sheets where I tried to Solve.
Thanks in Advance for your support & Consideration
Mod Edit: Original contest is over, link to site
http://datahack.analyticsvidhya.com/contest/mini-hack-excel
Last edited by a moderator: