HR professionals, it’s time to learn a skill that will transform the way you work. 

Learn advanced analytic techniques on Excel and uncover data-driven insights that aid in HR decision-making and reporting.

1. Program duration:16 weeks

2. Students study at the rate of10 hours/week

3. Access duration is 12 months

TOOLS

Advanced Excel Add-ins, Excel

MODULES INCLUDED

Excel for Advanced Analytics

• Simple data manipulation with Excel Functions

• Data Visualization with Excel

• Advanced data manipulation with Excel

• Implementing analytics in Excel

Intro to HR Analytics

• Overview of HR Analytics

• Analytical Problem Solving Framework

• Improving Measurement Maturity

Statistical Analysis with HR Data

• Introduction to Statistics

• Workforce Analytics Examples and Case Studies

• Analytics in Talent Management

Advanced Analytics in HR

• Advanced Statistical Analysis

• Predictive Analytics and HR use cases

• Data Visualization and Effective Presentation

• Implementation of HR Analytics outcomes

Salary Range:

India – INR 6-12 lacs

Global – $60,000 to $1,08,000

What does a HR Analyst do?

Analyze internal and external HR data to uncover data-driven insights that aid in HR decision-making and reporting. Typical areas include attrition management, retention strategies, pay scale calibration, training effectiveness etc.

Growth curve:

HR professionals who have expertise on data analysis skills tend to grow faster than their non-analytical counterparts.

WHAT YOU GET

The Catalyst Approach

Learn through video lectures, live question and answer sessions conducted by the faculty, assignments, interactive case study workshops with senior faculty and industry mentors. Know more.

Video lectures

You get to view 25 hours of video lectures & 32 hours of pre-recorded classroom training, as many times as you wish to.

Jigsaw Learning Center

Gain free access to a variety of supplemental resources like handouts, reference material, guides, lecture transcripts and student forums for a period of 12 months.

Faculty Assistance

Get all your course-related queries solved by the Jigsaw Faculty via email, phone and chat for your program duration.

Q&A Sessions

Have questions? Ask our analytics mentors during the 2 hour Q&A session every Saturday for your program duration

Mobile App

Learn on the go, wherever you are with a LIFETIME access to Jigsaw's course videos

Career Counseling

Avail professional guidance on resume building, interview preparation and identification of relevant opportunities, for the analytics field.

General Support

We have your back! Our student support teams are available on the weekends for call and 24/7 on email for your course duration

FINAL OUTCOME

This specialization will prepare you for the role of an HR analyst

WHO SHOULD DO IT

Any HR professional or aspirant looking to develop skills for data driven decision making in HR