Human Resource analytics is a data-driven approach to managing people at work. As per Deloitte survey, 75 percent of the organizations believe that using HR/ People/Workforce analytics is critical for organizations of the future.
HR analytics is considered as one area where organizations have a significant capability gap across the board. It is estimated that around 80 percent of the current HR workforce do not have the required analytics skills to analyze this increasingly data-driven area. As the power of analytics is changing businesses, understanding all dimensions of the workforce is critical for gaining competitive advantage.
Why You Should Attend:
The role of HR analytics is transforming how the HR department operates. It helps to give HR a strategic seat at the table for business decision-making and ensures those decisions are based on verifiable data. HR analytics can help to answer a number of key organizational questions and importantly, help the business to gain a competitive advantage.
It’s also about fairness and accountability when you look at it – it’s easier to point to decisions based on clear data than to those where opinion is the basis. Many a times, HR personnel needs to prepare and present the report in the intuitive way that management demands. This workshop will help the HR personnel to prepare and present insightful analysis and reports to help the decision makers to act swiftly.
Measuring the ROI of HR initiatives, help companies to ensure that HR initiatives are contributing to the overall success of the organization, both in terms of employee satisfaction and financial performance. HR metrics like Absenteeism, Turnover rates, Recruitment efforts in terms of time and cost, Human capital should be helpful for any business to monitor ROI.
Who Should Attend:
HR Executives who wish to advance their HR analytical skills and move into more strategic roles.
HR Managers & leaders specially managers involved in recruitment and talent acquisition, talent and organizational development and talent retention.
HR Business partners and Business leaders seeking insights into how HR data can impact organizational performance.
Department heads & leaders looking to optimize team performance.
Professionals who are looking to upgrade their career in HR Analytics.
Upon completion of HR analytics training, participants will gain the skills to make data-driven decisions by analyzing key HR metrics, improving employee performance, achieving a competitive advantage, identifying and solving workforce problems, realizing cost savings, and ensuring compliance with employment laws and regulations.
Training Outline Modules:
Module 1: Introduction and Essential Concepts
Overview of Human Resources Functions
Analytical Application Use Cases in HR
Understanding Various HR Metrics
Focus on Key Recruitment and Training Metrics
Module 2: Just Enough Statistics
Descriptive Statistics: Mean, Mode, Median, Variation, Shape of Data
Interpreting Meaningful Ratios and Percentages
Creating Meaningful Graphs
Demonstration of a Simple Dashboard
Module 3: Essential Excel Skills
Essential Excel Tasks and Shortcuts
Data Cleaning, Exploration, Validation, and Correction
Advanced Excel Skills: Graphs, Charts, Dashboards
Module 4: Building Simple Dashboard
Understanding and Constructing HR Dashboards
Key Performance Indicator (KPI) Metrics
Module 5: Continued Excel Skills
Calculations, Pivots, Lookups
Excel Functions for HR Analytics
Module 6: Learning Power BI
Connecting/Accessing Data in Power BI
Cleaning, Exploring, Validating, and Correcting Data
Building Dashboards in Power BI
Module 7: Case Study
Case Study: Employee Training and Performance Evaluation
Building Dashboards for the Case Study
Generating Insights from Analytics
Module 8: Bring Your Data
Interactive Session: Participants Bring Their Data
Practical Application and Analysis
Recap and Q&A Session
Preeti Pandhu, holding an MSc and BSc in Applied Statistics, began her career as a lecturer before joining a SAS company's Audit and Research team for a decade. With roles ranging from L&D Manager to Analytics Specialist, she led projects in pricing, optimization, and predictive modeling. In the last four years, Preeti has crafted masterclass training programs, garnering acclaim in Southeast Asia. She has trained companies like SAS, Marina Bay Sands, Lenovo, OCBC Standard Chartered, SingPost in Singapore, and SAS, DBS, Bank Mandiri in Indonesia. Noteworthy collaborations in India include the Great Lakes Institute of Management, Fractal, Allianz, and Citi. Preeti's expertise extends to a technical review of Philip Holland's "SAS Programming and Data Visualization Techniques."