Target Customers in Car Insurance Market

-


 

Based on the customers data, I have analyzed what will the top target customer base to enter into car insurance market.


Tool Used: Power BI

Comments

Post a Comment

Popular posts from this blog

How to create a Word Cloud in R

-
Image
I have seen Word-cloud in so many places such as magazines, websites, blogs, etc. however never thought of making it by myself. I would like to thank R that taught me such a wonderful technique which everybody would like to learn. I don’t know if there are any other free options are available to create word-cloud. Let me give a quick explanation about R first, R is a free source packages and very useful for statistical analysis. We can use R for various purposes, from data mining to data visualization. Word-cloud is a tool where you can highlight the words which have been used the most in quick visualization. If you know the correct procedure and usage, then Word Cloud is simple in R Studio. Further, a package called “Word-cloud” is released in R, which will help us to create word-cloud. You can follow my simple four steps mentioned below to create word-cloud. Those are new to R or Word Cloud, I would suggest first install R studio from the link rstudio.com Also, the following...
Read more

A Key Challenge for Apple's Quest for Carbon Neutrality

-
Image
  The Goal of the project: To visualize Apple progress towards becoming carbon neutral in 2030. In 2020, after announcing their corporate operations were officially carbon neutral, Apple pledged to make their products carbon neutral by 2030. To achieve this goal, they set their emissions for 2015 (38.4 million metric tons CO2e) as the baseline and will aim to reduce them by 75% by 2030. The remaining 25% of gross emissions (9.6 million metric tons CO2e) will be removed using carbon offsets, bringing the net emissions to 0. To find out the how much carbon emission is already reduced by Apple in 2022 and how it going to reduce the remaining by 2030. Key Insights: Based on the data and analysis, i have found these below points: Apple has reduced its carbon emission in corporates operations by 2020 The top three highest emission segments are manufacturing, transportations and product use How Apple will reduce the remaining emission by 2030? Apple already implementation many transformat...
Read more

Free Cash Flow to the Firm (FCFF) v/s Free Cash Flow to Equity(FCFE)

-
Shows both the Free Cash Flow to Firm (FCFF) and Equity components of the valuation of an enterprise. Free Cash Flow to the Firm v/s Free Cash Flow to Equity Inputs Earnings before interest and taxes (EBIT) = 100 E xpected growth for next 5 years = 20% Expected growth after year 5 = 5% Tax rate = 40% Debt ratio for the firm = 20% Cost of equity = 15% Pre-tax cost of debt = 9% Return on capital in high growth= 15% Return on capital in stable growth = 10% 0 1 2 3 4 5 Terminal Year Expected Growth rate 10% 10% 10% 10% 10% 5% Reinvestment rate 66.67% 66.67% 66.67% 66.67% 66.67% 50.00% EBIT(Earnings before interest & tax) ...
Read more

Why Patients Rating (HCAHPS) Declined During COVID-19?

-
Image
  Project Description: The HCAHPS survey is the first national, standardized, publicly reported survey of patients' perspectives of hospital care. HCAHPS (pronounced "H-caps"), also known as the CAHPS Hospital Survey, is a survey instrument and data collection methodology for measuring patients' perceptions of their hospital experience. HCAHPS was designed to help government agencies begin to collect and aggregate data on patient’s perspectives of care at the various healthcare facilities in the United States. HCAHPS scores are used to enable objective comparisons of hospitals across a variety of metrics, inform healthcare consumers about the relative standard of care at each facility and create incentives for hospitals and healthcare organizations to compete on patient engagement and satisfaction. This is the September challenge organized by Maven Analytics. You can find the dataset here . The challenge data consists of 7 files: Measurers National result Questions ...
Read more

IT HELP DESK ANALYSIS

-
Image
When its about IT, how we can leave behind the IT help desk which is the major part of this industry. I found this data set interesting to analyze. There is two file one is Agent details and IT tickets data. The initial job had to do was the changes of the data as mentioned below: In the Tickets Table • The client requires the canvas settings of the PBI report to be H:1080 - W: 1920 • The client would like columns Severity and Priority to be split into 2 columns, creating an ID and classification columns. Example Severity Key column = 0 and Severity Type = Unclassified. • The Average Resolution time is 4.5 days. The Client would like to create a new column where if the Resolution time is above 3.5 days = "Outside SLA" and if it is below "Within SLA". This will allow the client to push for all calls to stay within the limit by targeting these calls and agents. In the IT Agents Table • Column Full Name to be split into 2 columns Name and Last Name, where last ...
Read more

Great thought by Mrunal Nandankar

-
Success is not measured by how much a man has, But how much he has done, How far he has gone. Success is the basic human knowledge, Of how well a man has done. It is not taken lightly, Or as it shouldn't be. This is a serious task. One given to man by fate. Only you can determine your success. Only people can comment it. Push your self to the limit, Gas far as you can, Strive for it, For it is important, Your success. One of the most important traits of human kind, Taken for granted by the rich, And serious by the poor. We all have it in us, What it takes to be a success. We just have to reach in deep enough, And we will soon find the success in us, That has been lying there all a long. Success is key to all of life's compances, Enjoy it while it lasts. By Mrunal Nandankar...............
Read more

Engendering revenue without selling

-
There are few companies now a day who are not selling goods or services and generating revenues. These companies are not only generating profits as well as they connecting people all over the world. Yes, hope you understand about which companies I am talking about. Right!!!!!! These are ·          LinkedIn ·          Facebook ·          Twitter ·          Google + More and more people connecting through these various networking sites and connecting with people, companies etc. We are so much benefited now without meet with people. As well as these companies are provides online marketing services through this you can build your contacts with customers, clients, suppliers etc.   I would strongly suggest getting involved in social networking. So keep connecting…………….
Read more

The Global Space Exploration Roadmap

-
Image
All space missions from 1957 to August 2022, including details on the location, date, and result of the launch, the company responsible, and the name, price, and status of the rocket used for the mission. Recommended Analysis How have rocket launches trended across time? Has mission success rate increased? Which countries have had the most successful space missions? Has it always been that way? Which rocket has been used for the most space missions? Is it still active? Are there any patterns you can notice with the launch locations?  Tool: Power BI
Read more

Maven Healthcare Challenge: Aug 2023

-
Image
In recent Maven Analytics challenge, we need to do analysis of hospital survey data. The data is about National & state-level scores from 2013 to 2022 for the Hospital Consumer Assessment of Healthcare Providers and Systems (HCAHPS) survey, a national, standardized survey of hospital patients about their experiences during a recent inpatient hospital stay. First know about, what is HCAHPS? The HCAHPS survey is the first national, standardized, publicly reported survey of patients' perspectives of hospital care. HCAHPS (pronounced "H-caps"), also known as the CAHPS Hospital Survey, is a survey instrument and data collection methodology for measuring patients' perceptions of their hospital experience. HCAHPS is a patient satisfaction survey that was developed by the Agency for Healthcare Research and Quality (AHRQ) in collaboration with Centers for Medicare and Medicaid Services (CMS) beginning in 2002. It was designed to help government agencies begin to collect ...
Read more