National Insurance Academy, Pune, India

We are pleased to announce following two Online MDP courses for the benefit of Insurance Industry:

1.   P785 Advanced Excel for Data Analytics (Open To All)

2.   P781 Power BI Development (Open to All):

Who Will Get Benefited?

Schedule

1.   P785 Advanced Excel for Data Analytics (Open To All):  

Duration: 5 days

Dates: 15.06.2020 – 19.06.2020

            For fees: contact   uebagwan@niapune.org.in; programoffice@niapune.org.in

Need of this Course: Excel is one of the most widely used spreadsheet software across industries world-over. Microsoft has been continuously enhancing analytics-related features of Excel. Advanced features like VBA Macros (though traditional), Power Query, Power Pivot, Power View, Power Map in MS Excel are getting increasing popularity amongst Business Managers, Data Analysts across various departments in Insurance, Banking, other financial services and in other industries including IT/ITES, for developing dynamic dashboards. Excel’s integration with RDBMS like Microsoft SQL Server, Oracle, MySQL & others; Big Data platform like Hadoop, Social Media platforms and of course with Microsoft Azure, are becoming need of the hour. Against this background, this workshop has been arranged.

            Coverage:

            Professional Practices of Spreadsheets, Dashboard Development,

Advanced Excel Functions,

Advanced Pivot Table

Excel Data Analysis Toolpack

Advanced Charting / Visualization

What-If Analysis: GS, SM & DT

KPIs Development

Power Query (using Excel2013 or higher version)

Power Pivot (using Excel2013 or higher version)

Power Map & Power View (using Excel2013 or higher version)

Excel VBA Macros

Virtual Group Demonstrations by Participants at the end of the course.

 

Entire Workshop will be online with hands-on practical along with necessary conceptual inputs, by using Excel 2013 or higher.

 

2.   P781 Power BI Development (Open to All):

Duration:         5 days

Dates: 29.06.2020 – 03.07.2020

            For fees: contact   uebagwan@niapune.org.in; programoffice@niapune.org.in

Need of this Course: Power BI is gaining increasing popularity for developing dynamic dashboards for Business Intelligence. Power BI Desktop is freely available tool from Microsoft for developing such BI solutions though Power BI is available on Azure platform also. Power Analytics features like Power Query, Power Pivot, Power View as integral part of Power BI along with Power Map in MS Excel are getting increasingly important for Data Analysts and BI Development work. Power BI desktop can be integrated with Excel on one side and with RDBMS like SQL Server, Oracle, MySQL & others, Big Data platform like Hadoop, Social Media platforms also with Microsoft Azure. Against this backdrop, this workshop has been arranged.

Coverage:

Introduction to Power BI - Overview,

Power BI Desktop Setup & Overview Hands-on,

Power Query (in PowerBI),

Power Pivot (in PowerBI),

Power View (in PowerBI),

Power Map (in PowerBI),

Using Power BI for Professional Dashboard Development

Virtual Group Demonstrations by Participants at the end of the course.

 

Entire Workshop will be online with hands-on practical along with necessary conceptual inputs, by using Power-BI development tool, Excel 2013/or higher. Power BI Development Tool will be provided by us.

 

Who will Get Benefited (Participants’ Profile):

Executives in any cadre and from any department of Life Insurance or General Insurance related entity, having passion to learn Advanced Excel / Power BI for Data Analysis will get benefited from these online remote hands-on workshops. Excel operational knowledge & skills are assumed. Executives in the cadre of Officer, Manager or Higher Management from IT / Analytics from any office interested in Data Analysis across various areas representing Life Insurance, General Insurance, Insurance Broking organizations, Marketing, CRM, Actuarial, Investment, Health, Motor, Claims Management, Audit will get benefited from these workshops. 

 

Schedule: (for both these Online MDPs)

Session1: 10:00am to 11:00am followed by a 09 minutes break

Session2: 11:10am to 12:10pm followed by 09 minutes break

Session3: 12:20pm to 01:20pm

We request you to nominate officials for the above referred courses.

Regards,

Ujwala Bagwan

AO-Programme Office

National Insurance Academy     http://niapune.org.in/

Balewadi, Baner Road, NIA PO

Pune 411045, India

Tel: 91-20-27204053 (D); 27204000 (B)

E-mail: uebagwan@niapune.org.in; programoffice@niapune.org.in

 

-----***-----