▶ Module 1- Excel expert

This module empowers the participant with a never before seen depth in almost all of Excel's powerful Features with a focus on becoming an Expert, by 'Mastering' each of the mentioned categories. The module offers Tips, Tricks, Data analysis and comprehensive coverage of topics that you may not even be aware of

-       Excel Essentials, Introduction to key board accelerators

-       Manipulating and formatting rows/columns, boarder sheets

-       Data Validation, Hyperlinking, Conditional Formatting

-       Paste Special, Freezing & Unfreezing Panes, Text to Columns

-       Inserting, Viewing & Editing Comments, Removing Duplicates

-       Using VLOOKUP & HLOOKUP, Using SUMIF, COUNTIF, AND AVERAGEIF

-       Using the TRANSPOSE and SUMPRODUCT function

-       Working with dates - DATEDIF, YEAR, YEARFRACE & MONTH

-       Pivot table, Sensitivity analysis with Data tables

-       Charting commonly used, Index, Search, Choose, offset

▶ Module 2- HR Analytics

⁃ Characteristics of HR analytics

⁃ Strategic focus for HR analytics

⁃ Major problems facing HR analytics

Skillsets

⁃ Most important skills required

⁃ Skills needed in a HR analytics team

⁃ Skillsets & experience needed in various positions of the HR analytics process

▶ Module 3- BUILDING THE BUSINESS CASE

Variables

⁃ What are dependent variables and control variables

⁃ Impact of a moderator variable

⁃ How a mediator can affect the outcome

HR Value Chain

⁃ How the HR Value Chain works and who are driving forces

⁃ HR Value Chain can be used to achieve business optimum outcomes from HR

Applying the HR Value Chain in Real Life

⁃ Steps are after defining the business problem

⁃ Explain how you can create measurable and impactful metrics to measure HR effectiveness

Examples of Analytics Cases

⁃ Real time examples where analyse factors that drive employee turnover

⁃ Explain the link between engagement and performance

⁃ Understand the principles that drive absenteeism

Building the Business Case for HR Analytics

⁃ Understand the link between diversity and innovativeness

⁃ Explain the relationship between innovation and revenue

⁃ Describe how education does not translate into leadership

▶ Module 4- DATA AUTOMATION, DATA CLEANING

⁃ Learn how to automate the big data

⁃ Importance of a pilot analysis

⁃ Capability & compliance building of HR analytics

Data & Metrics

⁃ Explain the purpose of HR metrics/data

⁃ Categories of performance

⁃ Performance measurement of various HR operations

Data Cleaning

⁃ Create several descriptive statistics in R

⁃ Understand how to clean HR data in R

⁃ Transform HR data into plots and graphs in R

Creating HR Metrics

⁃ Understand organizations structures

⁃ Understanding of KPIs and result description

⁃ Transform strategic goals to HR metrics and see its result in dashboard

▶ Module 5- REPORTING INSIGHTS

Reporting & Advising

⁃ Describe the various rules of reporting HR analytics

⁃ Understand the mindset in reporting HR analytics

⁃ Explain the importance of data visualization

Data Visualization

⁃ Understand why design is important in reporting

⁃ Explain how to put insights into perspective

⁃ Describe the basic principles of information design

Cash study and assessment