National Insurance Academy, Pune|Information Technology
P767 | Data Analytics (LIC)
Academic Year 2026-2027
Duration
3Days
Scheduled Dates
01 Jun 2026 - 03 Jun 2026
02 Nov 2026 - 04 Nov 2026
Background
Data Analytics in Insurance Business Management is becoming increasingly important. The use of sophisticated data analysis tools and techniques has become extremely essential to ensure data-driven planning and decision making in business development process and CRM.
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 analytics & CRM. This program provides hands-on practical based insight in Analytical CRM.
Learning Objectives
Appreciate Importance of Data Analytics
Understand Data Analytics Types
Understand Data Analytics: CRM & IT Perspectives
Know Data Analytics Tools & Techniques for Data-Driven CRM by using Excel and related tools: Customer Lifetime Value (CLTV), Cluster Analysis for Customer Segmentation, Association Mining, Regression-based Forecasting, Classification-based Predictive Analytics, Simulation based Predictive Analytics, Customer Analytics including Optimization models - using Excel & other tools
Appreciate importance of Data Analytics Best Practices
Key Contents
Data Analytics: CRM & IT Perspectives
Excel-based Data Analysis Tool Pack
Regression-based Forecasting by using Excel.
Excel-based Cluster Analysis for Customer Segmentation
Excel-based Association Mining
Excel-based Simulation for Customer Predictive Analytics
Classification-based Predictive Analytics by using Data Mining Software-Tool
Optimization modelling for Customer Analytics
Big Data Analytics and AI for CRM
Best Practices of Data Analytics for CRM
DPDP Act, 2023
Excel operational knowledge & skills are assumed.
Who Should Attend
Officers in the cadre of A.O. and above from IT and CRM Departments of C.O., Z.O. & D.O. to be nominated by the CO/ZO HRD Department.
Trainees nominated for this programme in the last two years should not be renominated.