HR Data Analysis using Excel

Name: HR Data Analysis using Excel
Rating: 4.3 (31 reviews)

A Practical Approach

Created byYelamanchili Rama Krishna

Last updated 12/2020

English

What you'll learn

How to gather HR data from employees
How to create database in Excel
How to create different data entry forms in Excel
How to get preliminary insights of HR data using Pivot Table
How to visualize HR with Pivot Charts
How to frame hypothesis and test hypothesis
How to find association between two HR variables using Chi Square test
How to measure impact of HR intervention on Employee Performance

Course content

4 sections • 13 lectures • 1h 33m total length

Introduction to HR Data Analysis4:33
Know about various steps in Human Resources (HR) data analysis and learn how the questionnaire is designed and data are collected.
How to create Database in Excel10:38
Learn how to create a database in Excel using your HR questionnaire or data collection instrument. First step in HR data analysis is to create a meaningful database with different field names.
How to Create Data Entry Form in Excel6:37
Learn how to create data entry form in Excel. With the help of Excel data form it is very easy, convenient, and comfortable to enter data into Excel database without any errors.
How to Create Drop Down List Form5:20
Learn how to create drop down menu list form in Excel. With the help of drop down list form you can enter the data into Excel database by just clicking on the options for each question or statement.
How to Transform Codes to Labels in Excel5:37
Learn how to transform codes to variable options in Excel. For convenience we enter data into excel database by using codes. However, at the time of analysis we need variable options to generate reports. Learn how to replace codes with variable options.

How to create Frequency Table on HR data using Excel12:28
As a part of HR data analysis frequency distribution tables are created first to gain preliminary insights of univariate data sets. Learn how to create frequency tables using Excel Pivot Table option.
How to create cross tabulation on HR data using Excel6:54
Cross tabs (tabulations) are created on bivariate data sets. Cross tabulation is a first step in testing hypothesis between two categorical variables.
How to create pie chart on HR demographic data using Excel6:34
Pie chart are very help in visualization of demographic data. In HR research we draw pie charts on different demographic profiles of employees and study participants.
How to create column chart on bivariate HR data using Excel3:56
Learn how to gain preliminary insights of bivariate data and tri-variate data using excel pivot table and column chart.

How to test association between two categorical variables in Excel10:25
To test independence between two categorical variables we use Chi Square test of independence. Learn how to run chi square test of independence in Excel from this lecture.
How to test Homogeneity between groups using Excel8:12
Learn how to test homogeneity or independence of opinion between groups of individuals using chi square test and interpret the result.

How to draw XY Scatter plot on continuous HR data using Excel5:58
XY Scatter plot is drawn to understand the relationship between two continuous variables. If you find any trend or relationship in XY scatter plot then you can perform correlation and regression analysis to understand the influence of independent variable on dependent variable.
Association between two continuous HR variables using Spearman rank correlation6:47
Learn how to measure association and impact of independent continuous variable on dependent continuous variable using rank correlation in Excel.

Requirements

Interest in Human Resources Management
Interest in HR Analytics
Interest in HR Research

Description

Wish to work for companies like Hitachi ABB, Cargill India, Novo Tree Minds, Vertiv (Malaysia), Cummins, ExecBoardinAsia, Accenture, Nielsen Media, Amdocs, GlaxoSmithKline etc. as HR Data Analyst. Then join this course, get great insights of HR data analysis starting from creating HR database to analyzing impact of HR interventions.

Learn how to perform HR data analysis beginning from formulation of objectives to measuring association between skill development and performance appraisal. In this course you will learn how to create database in Excel, create data form, enter data, create tables, draw charts, frame hypothesis, hypothesis testing and report writing. This course will help begin your career in most rewarding HR analytics domain.

Who this course is for:

Beginner with interest in HR
Individual looking for career in highly rewarding HR Analytics
Individual interested in HR research
Under Graduate or Post Graduate curious to learn HR Data Science

HR Data Analysis using Excel

What you'll learn

Explore related topics

Course content

Introduction to HR Data Analysis, Data Collection, Data Entry, Coding5 lectures • 33min

HR Data Tabulation and Visualization with Pivot Table and Charts4 lectures • 30min

Measure Independence between Categorical variables2 lectures • 19min

Association between two continuous variables2 lectures • 13min

Requirements

Description

Who this course is for: