Human Analytics Certificate Program
Duration: 4 Weeks, 4 days (10:00 - 16:00)

Participant Profile: Expert and above level HR employees and Managers

Thanks to the "HR Analytics - Data Analysis, Data Visualization and Reporting Certification Program", where you will learn the use of HR Analytics, Business Intelligence (BI) and Data Mining tools as well as advanced techniques related to reporting and data analysis, you will be able to predict the future in the changing field of Human Resources today.

About the Training
Objectives:

At the end of the training program, you will be able to identify which report you can prepare using which tools,

You will be able to design automated reports through SQL queries.

You will be able to make Business Intelligence reports accessible on mobile.

You will gain competence in data visualization and making sense of data.

You will be able to shorten the long process of reporting and preparing data for reporting

Data will make sense! You will be able to test how to use both visual and analytical tools through real data-cases.

The training is 70% based on application, project and case studies. It is sufficient to know basic level Excel to participate in the training.

Day I

HR Strategy and Reporting relationship
Strategic reporting work
Data Visualization
Dashboard Design Training
Dashboard case study
Advanced Reporting Techniques
Data Consolidation
Applications
HR Metrics (selection from a set of 100 HR Metrics)
HR KPIs (different from Metrics)
Global HR Metric Examples and Calculations
Basic Concepts of Business Intelligence

Day II

Business Intelligence and Human Resources Solutions
Dimension, Fact Study
HRIS Concept and Examples
What is a Data Model?
Going beyond Turnover, Retention and other Demographic reporting
Business Intelligence case studies
Case1: Migration of recruitment dashboard report to business intelligence
HR Report sharing from mobile
Different BI tools
Case2: Text Mining Basic Business Intelligence Case
Case3: Mobile business intelligence report design case
Case 4: Future forecasting Models in Business Intelligence

PROJECT WORK
BI report design project of different data sets with the BI tool of the participants' choice

Day III

Introduction to HR Analytics
Use of Forecasting Algorithms in HR
Basic Regression analysis
Distributions
Outlier Identification
Case1: Annual leave Roy (rest of year) forecasting case
Case 2: Turnover future prediction modeling
WEKA Data Mining
Designing a regression model with WEKA Data Mining tool

Day IV

HR Analytics Cases
HR Analytics, HR Business Intelligence and HR Data Mining Studies
Correlation and Logistic Regression with R Studio
Case1: HR analytics study with leaver profiling (predicting which type of employees will leave)
Case 2: Which variable increases sales more.
Case 3: Statistical tests between categorical variables (gender, age range, performance score)