NATIONAL
INSURANCE ACADEMY
PUNE
P767- PROGRAMME ON DATA ANALYTICS (LIC)
(2023-24)
Background:
Excel is becoming to be one
of the most widely used spreadsheet software tools in the insurance industry. It
is now possible to develop dynamic dashboards by using excel for better customer
management and customer engagement. This program provides hands-on practical
based insight in Analytical CRM.
Ø
Appreciate Importance of Data Analytics
Ø
Understand Data Analytics: CRM & IT Perspectives
Ø
Understand Data Analytics Types
Ø
Appreciate importance of Data Analytics Best Practices
Ø
Know Data Analytics Tools & Techniques for Data-Driven
CRM by using Excel and related tools
Ø
Customer Life Time Vale (CLTV)
Ø
Cluster Analysis for Customer Segmentation
Ø
Association Mining
Ø
Regression-based Forecasting
Ø
Classification-based Predictive Analytics
Ø
Simulation based Predictive Analytics
Ø
Customer Lead Management System (CLMS), Customer Conversion Optimization
Program Contents:
Ø
Data Analytics: CRM & IT Perspectives
Ø
Excel-based Data Analysis Tool Pack
Ø
Excel-based Cluster Analysis for Customer Segmentation
Ø
Excel-based Association Mining
Ø
Regression-based Forecasting by using Excel
Ø
Excel-based Simulation for Customer Predictive Analytics
Ø
Classification-based Predictive Analytics by using Data Mining
Software-Tool
Ø
Customer Conversion Optimization
Ø
Best Practices of Data Analytics for CRM
Ø
Big Data Analytics and AI for
CRM,
Excel operational knowledge &
skills are assumed.
Administrative Officers in
the IT and CRM Depts. in Central Office
Nomination by CO-HRD in
consultation with CO-IT and CO-CRM Departments
Duration:
3 Days
Dates:
05.02.2024-07.02.2024