HR Analytics Using Excel

By Subbulakshmi Somu | Dayananda Sagar College of Arts, Science and Commerce

Learners enrolled: 8544

The course "HR Analytics using Excel" is designed to equip learners with the knowledge and skills to effectively utilize Excel as a tool for Human Resources (HR) data analysis and decision-making. In the 8-week course, learners will discover the basics of HR analytics and master Excel skills to process, analyse, and visualize HR data effectively.They will explore various HR analytics concepts, such as descriptive, diagnostic, predictive, and prescriptive analytics, and understand their applications in HR management. The course will cover topics such as creating HR dashboards, trend line analysis, correlation, and regression using Excel. Learners will gain hands-on experience in applying Excel's features and functions to interpret HR metrics, identify trends, and make data-driven decisions. Additionally, they will explore real-world examples and cases of HR analytics to understand how data insights can drive strategic HR initiatives and improve workforce management. By the end of the course, learners will be proficient in creating dynamic HR dashboards, conducting various data analyses, and presenting HR analytics insights effectively. Whether for talent acquisition, employee performance evaluation, or workforce optimization, "HR Analytics using Excel" empowers learners to leverage Excel's capabilities to enhance HR decision-making.

Summary

Course Status :	Completed
Course Type :	Core
Language for course content :	English
Duration :	8 weeks
Category :	Management Studies
Credit Points :	3
Level :	Postgraduate
Start Date :	19 Jan 2024
End Date :	30 Apr 2024
Enrollment Ends :	29 Feb 2024
Exam Date :	18 May 2024 IST
Shift :	Shift 2

Note: This exam date is subject to change based on seat availability. You can check final exam date on your hall ticket.

Page Visits

Course layout

Week 1: Introduction to HR Analytics

Week 2: Data and Its Types

Week 3: Descriptive Analytics through Data Visualization

Week 4: Descriptive Analytics - Data statistics

Week 5: Diagnostic Analytics

Week 6: Predictive Analytics

Week 7: Prescriptive Analytics

Week 8: Reporting and Dashboard creation

Click here for syllabus page

Exam schedule

Books and references

None

Instructor bio

Subbulakshmi Somu

Dayananda Sagar College of Arts, Science and Commerce

Dr. Subbulakshmi Somu is an Associate Professor at Dayananda Sagar College of Arts, Science and Commerce. Her areas of teaching are Organizational Behaviour, Human Resource Management, Strategic HRM, and HR Analytics. With a strong academic background, she holds a Ph.D. in Human Resource Management from Annamalai University, Chidambaram, Master's degree in Business Administration from Anna University, Chennai, where she was a university rank holder. Additionally, she has completed her M.Sc. in IT from Madras University and is also NET qualified. Her research areas include Strategic Human Resource Management, HR Analytics, Nudge Theory, and Entrepreneurship. She has presented her research papers at prestigious national and international conferences, including the PAN-IIM World Management Conference and the International conference at IBS, Hyderabad, where she received accolades for her outstanding work, including best paper awards. She published in Scopus-indexed and peer-reviewed UGC-approved journals. She is an esteemed reviewer for the Academy of Management (AOM) and various other journals of international repute. She also holds the distinction of being a certified Mendeley advisor by Elsevier, UK, reflecting her expertise in reference management and high-quality publishing. She has conducted numerous Faculty Development Programs (FDPs) and workshops for faculties and research scholars across the country. Her workshops have focused on topics like high-quality publishing, reference management, and research tools such as SPSS, Smart PLS, Psychometrics, and mediation and moderation analysis.

Course certificate

Enrolling and learning from the course is free. However, if you wish to obtain a certificate, you must register and take the proctored exam in person at one of the designated exam centre’s. The registration URL will be announced when the registration form is open. To obtain the certification, you need to fill out the online registration form and pay the exam fee. More details will be provided when the exam registration form is published, including any potential changes. For further information on the exam locations and the conditions associated with filling out the form, please refer to the form.

Grading Policy:

Assessment Type	Weightage
Mid-Term & End-Term	25%
Final Exam	75%

Certificate Eligibility:

40% marks and above in Mid Term & End Term
40% marks and above in the final proctored exam

Score	Type of Certificate
>=90	Gold
75 - 89	Silver
70 - 74	Bronze
40 - 70	Successfully Completed
<40	No Certificate

Sample Certificate:

Disclaimer: In order to be eligible for the certificate, you must register for enrolment and exams using the same email ID. If different email IDs are used, you will not be considered eligible for the certificate.

SWAYAM Helpline / Support