This is a practical course to provide you with the Advanced HR Analytics skills to enable you perform predictive analytics in excel for Human resources. In this course we shall dive into advanced statistical tests which include; linear regression analysis, Multiple regression analysis, logistic regression analysis and structural equation modeling. This course focuses on HR Analytics with a practical focus on data cleaning for Human Resource Analytics, actual data analysis in excel, Interpreting of the results and execution. We will perform predictive analytics with data models using linear regression and multiple regression analysis. We will use simple practical illustrations with data models to make it easy for you to learn and apply the concepts in a real HR world. In this course data has been provided as a downloadable resource so that you can learn and practice.

What you will learn

• Knowledge on the advanced statistical tests such as linear regression analysis, Multiple regression analysis, logistic regression analysis and structural equation modelling

• Become proficient in excel data analysis tools

• Use pivot tables for filtering and sorting data for HR Analytics in excel

• Implement predictive models such as simple and multiple linear regression to predict outcomes

• Telling story with data

This course is for you if you are interested in advancing your HR analytics in MS Excel.