Amdor Analytics

HR Analytics- Professional

The course equips learners use data to drive strategic HR decisions. Learn predictive HR modeling, talent analytics, workforce metrics, and advanced HR dashboarding.
2 Months
1 Months
Yes
Professional

About the course

HR Analytics Professional is a practical program designed to help learners use data-driven strategies to improve workforce performance and business outcomes. The course introduces learners to HR metrics, employee data analysis, recruitment analytics, performance tracking, workforce planning, and people management insights. Learners gain hands-on experience using Excel, Power BI, and data visualization tools to analyze HR data, identify trends, and support strategic decision-making. The program also covers employee engagement analysis, retention strategies, and reporting techniques that help organizations make informed human resource decisions. Through practical projects and case studies, students gain the skills needed for modern HR analytics and people operations roles.

Course Curriculum

Module 1: Introduction to Excel
  •  Introduction to Excel Basics

  •  Excel interface/ Environment

  • Cell Referencing

  • Functions 1 (SUM, AVERAGE, COUNT, COUNTA, MAX, MIN etc)

  • Functions 2 

    1. If, NestedIF and IFS
    2.  If_And_Or

      3. Tables, Structured Referencing

             

  • Functions 3 (Vlookup, Hlookup, Xlookup and Index-Match)

  • Business Problem
  • Asking the Right Questions
  • Pivot Tables
  • Dashboard Building
  • Storytelling with Data
  • Power Point
  • Report Presentation
  •  Power BI Basic
  • Power BI vs Excel
  • Power BI Architecture
  • The Power BI Workflow
  • Power BI Dashboard Building
  • Data Modelling
  • Primary and Foreign Keys
  • Fact and Dimension Table
  •  DAX
  • DAX Functions II
  • AI Visuals
  • Dynamic Charts
  • Intermediate Visualizations
  • HR Metrics and KPIs
  • HR Data Privacy and Ethics
  • Talent Acquisition 
  • Analytics
  • Employee Performance Analytics
  • Employee Engagement and Satisfaction

Course Structure

Gbemileke Falade

HR Analytics Facilitator

Gbemileke Falade is a people-focused professional and HR Analytics Facilitator with a background in customer experience and operational systems. With a strong understanding of human behavior and workplace dynamics, he leverages data to drive smarter HR decisions.

He is passionate about helping individuals and organizations use data to improve employee performance, engagement, and retention. Through her facilitation, he simplifies HR analytics concepts, making them practical and accessible for beginners transitioning into tech.

His mission is to bridge the gap between people management and data-driven decision-making, empowering professionals to build more efficient and people-centered workplaces.