HR analytics from scratch - free course from Skillbox, training, Date: November 29, 2023.

Main course

Introduction
You will learn what is included in the concept of “HR analytics” and how analysis is used in personnel management.

Stages of development of HR analytics in a company
Study the levels of HR analytics and its applications using case studies. Learn how HR can influence business performance.

Working with HR data
Consider the types of data and their sources, learn how to collect and process information for analysis.

Logic when working with data
You will learn the basic principles of data analysis and learn how to break down the overall analytics process into specific steps.

General HR metrics
Learn to work with basic metrics and manage HR processes using KPIs.

Selection and adaptation metrics
Learn the key metrics for recruiting and onboarding personnel. Learn to calculate your recruitment funnel and estimate hiring costs.

Learning and Development Metrics
Learn to use the potential matrix and metrics for training and selection, and determine training KPIs.

Metrics for assessing motivation
Learn how to evaluate the effectiveness of reward and recognition programs. Learn how to apply the ENPS score and evaluate the degree of employee engagement.

HR analytics tools. Excel
You will understand how to optimize your work with Excel tables, using all the capabilities of the service.

HR analytics tools. Statistics and analytics
Master the basic principles of statistics, learn to use basic formulas for calculations.

Power BI for HR Analyst
Learn how to create interactive reports for HR and business, and create dashboard layouts based on HR metrics. Get acquainted with the capabilities of BI systems. You will understand how to create HR reports, build graphs and charts in the Power BI BI system.

Basic Python
Learn the basics of the Python programming language and how it is used in data analytics. Learn to assign tasks to developers and communicate with them in the same language.

HR reporting
You will learn what types of reports there are and understand the principles of their generation. Learn to select sources for reports and create graphs.

Data presentation
Learn to competently visualize and clearly design data and tables. Learn the basics of storytelling. You will be able to present your analytical solutions.

Bonus Course: Advanced Excel

Bonus module. Excel formulas and functions. Introduction
Master simple arithmetic operations in Excel, study the types of functions.

Bonus module. Excel formulas and functions. We continue to work with formulas
Learn how to enter functions. Get acquainted with the VLOOKUP, GLOOKUP, IF functions. Master the text formulas SPACE, PROPNACH, LEFT, RIGHT, CAPITAL.

Bonus module. Excel formulas and functions. More complex formulas
Learn to combine different conditions and make more complex calculations. Master the functions AND, OR, COUNTIF, SUMMIF, COUNTIFS, SUMIFS.

Bonus module. Excel Pivot Tables
Learn how to make a pivot table and simplify the process of comparisons and finding patterns.

Graduation project

Assessing the effectiveness of the HR process
You will select the HR metrics necessary for the assessment, collect data, make calculations and analyze the results. Then prepare and present a presentation with the results of your analysis.