Design business plan for distributing insurance to customers

Design business plan for distributing insurance to customers

Forecast the business for the upcoming years by Exploring Hidden Trends, Calculating Machine Productivity , Extrapolation and Assumptions and Summarizing Answers through Visualizations.


Each project comes with 2-5 hours of micro-videos explaining the solution.

Code & Dataset

Get access to 50+ solved projects with iPython notebooks and datasets.

Project Experience

Add project experience to your Linkedin/Github profiles.

Customer Love

Read All Reviews

Nathan Elbert

Senior Data Scientist at Tiger Analytics

This was great. The use of Jupyter was great. Prior to learning Python I was a self taught SQL user with advanced skills. I hold a Bachelors in Finance and have 5 years of business experience.. I... Read More

Swati Patra

Systems Advisor , IBM

I have 11 years of experience and work with IBM. My domain is Travel, Hospitality and Banking - both sectors process lots of data. The way the projects were set up and the mentors' explanation was... Read More

What will you learn

Plotting in Excel.
Use of Pivot table in Excel.
Extrapolation in Excel.
Getting Trend in Excel.
Dynamic Charting.

Project Description

In this data analysis project , you will explore your Excel and Business Intelligence skills on working elements like scorecards, dashboards, data connections, status lists, status indicators.

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 in the morning, where the board will review the future plan for AssureNext.

You need to help him create his plan and presentation.

Following Questions should be addressed in the plan:

  1. Making reasonable assumptions (and calling them out), you need to create a forecast for business (Premium received from new policies) in 2016 and 2017.
  2. How many new machines would be required to be installed in order to reach 1,700 Million INR of premium from new policies in 2017
  3. Assuming that you can not manufacture more than 6500 machines in a year and average premium from a policy to be INR 55,000, what should be the expected business in 2016 and 2017 (Quarter on Quarter)

Similar Projects

Text data requires special preparation before you can start using it for any machine learning project.In this ML project, you will learn about applying Machine Learning models to create classifiers and learn how to make sense of textual data.

The goal of this data science project is to build a predictive model and find out the sales of each product at a given Big Mart store.

Data Science Project-Predict the car insurance policy a customer buys after receiving a number of quotes.

Curriculum For This Mini Project

05h 00m