
The attached Excel file includes sample data for hands-on practice. Please note that the dataset may differ slightly from the examples demonstrated in the course videos.
The attached Excel file includes sample data for hands-on practice. Please note that the dataset may differ slightly from the examples demonstrated in the course videos.
The attached Excel file contains sample data points to help you practice and apply the concepts covered in this course.
The HR Analytics Certification Course has been designed and instructed by Harjeet Khanduja, Senior Vice President at a leading Fortune 500 organisation, in collaboration with Keka Academy. Harjeet is a seasoned HR professional with 18+ years of experience handling complex organisational structures. This course covers a comprehensive journey from the basics of HR data to advanced analytics tools and AI — teaching you how to collect, analyse, visualise, and storytell with people data, without needing any background in mathematics or statistics.
What you will learn:
HR Analytics Foundation. The DIKW Framework and 4 types of analytics
The POISE Framework — building HR metrics that actually matter
Lagging vs Leading vs Operational KPIs linked to business outcomes
Data collection, cleaning, and validation using Excel and Google Sheets
Essential formulas: VLOOKUP, XLOOKUP, COUNTIF, Pivot Tables, and more
Predictive analytics, Early Warning Systems, and AI use cases in HR
Building free HR dashboards in Looker Studio; using ChatGPT and Gemini for HR analysis
Data visualization — choosing the right chart for the right story
The ABCD Model for building data narratives and presenting to leadership
Data storytelling — Actors, Background, Conflict, and Conclusion
This course is ideal for: Mid-level to Senior-level HR professionals looking to make data-driven people decisions and earn a stronger seat at the leadership table- HRBPs, HR Managers, HR Heads, VP HR, and CHROs