Auto Insurance company is facing issues in retaining its customers and wants to advertise promotional offers for its loyal customers. They are considering CLV as a parameter to classify loyal customers.
Predict the customer life-time value for an Auto Insurance Company. Its revenue will increase if the amount claimed by customers who have insured in the company is low. Bookish definition: CLV is the total revenue the client will derive from their entire relationship with a customer. CLV gives the marketers an intuition of market structures, financial planning and other future consequences. It helps marketers to find optimum marketing spending to acquire and retain customers.
https://public.tableau.com/app/profile/soumit.kar/viz/CustomerValueAnalysisinAutoInsurance/BUSINESS
Minimize the number of fields.
Minimize the number of records
Optimize extracts to speed up future queries by materializing calculations, removing columns and the use of accelerated views
https://github.com/Sou-786/Ineuron-internship/blob/main/CLV_HLD%20.docx.pdf
https://github.com/Sou-786/Ineuron-internship/blob/main/Tableau_Architecture.docx
https://github.com/Sou-786/Ineuron-internship/blob/main/wireframe%20documentation.pdf
