Course Overview

Certificate Course in HR Analytics & People Insights

Course Title: HR Analytics & People Insights

Start Date: January 10, 2026

Duration: 20–24 hours (4–6 weeks)

Mode: Hybrid (Hands-on + Interactive sessions)

Class Size: Up to 50 participants

Course Equivalent: 2 Credit Hours

Course Fee: BDT 3,000.00

Course Description

Transform from traditional HR to a data-driven HR leader. This hands-on course is designed for HR professionals, managers, and placement officers who want to use real data and dashboards to make smarter decisions in recruitment, performance, retention, and workforce planning. Master Excel and Power BI for HR dashboards, build predictive attrition models, and calculate strategic HR KPIs — no prior technical background required.

Syllabus

Module 1: Introduction to HR Analytics & Data-Driven HR

Hours: 2

Topics

• What is HR Analytics?
• Why HR is shifting from intuition-based to data-driven decisions
• Types of analytics: Descriptive, Diagnostic, Predictive, Prescriptive
• HR data sources (HRIS, ATS, LMS, ERP, surveys)
• Ethical considerations & data privacy

Learning Outcomes

• Understand HR analytics fundamentals
• Identify data opportunities in HR processes

Module 2: HR Data Basics & Data Management

Hours: 3–4

Topics

• Types of HR data (employee, recruitment, performance, learning, exit)
• Data cleaning: removing duplicates, formatting, missing values
• HR data structuring (tables, codes, relationships)
• Basics of Excel formulas for HR
• Data quality issues in HR departments

Tools

• Excel / Google Sheets

Learning Outcomes

• Collect, clean, and prepare HR datasets
• Build structured HR data tables

Practical Activities

• Clean a raw HR dataset
• Prepare a structured HR master file

Module 3: Workforce Dashboards Using Excel

Hours: 4

Topics

• Using Pivot Tables for HR analytics
• Charts for HR insights (bar, trend, pie, waterfall)
• Dashboard fundamentals (design, layout, formatting)
• Building a real-time HR dashboard

KPIs Covered

• Headcount
• Turnover rate
• Absence rate
• Recruitment funnel KPIs
• Hiring velocity
• Diversity ratio

Learning Outcomes

• Build complete HR dashboards in Excel
• Visualize HR KPIs effectively

Practical Activities

• Build an end-to-end HR dashboard from sample data

Module 4: HR Dashboards Using Power BI

Hours: 4–5

Topics

• Introduction to Power BI (interface, data loading, data modeling)
• Using DAX for HR calculations
• Creating visuals for HR datasets
• Slicers & filters for HR segmentation
• Dashboard publishing & sharing

Learning Outcomes

• Create professional HR dashboards using Power BI
• Analyze HR data using interactive tools

Practical Activities

• Build a Power BI dashboard (turnover, recruitment, attendance)
• Publish a dashboard & create role-based views

Module 5: Predictive HR Analytics (Attrition & Performance)

Hours: 4

Topics

• Introduction to predictive modeling concepts
• Identifying predictors: tenure, performance, salary, engagement score
• Building an attrition prediction model (step-by-step)
• Using regression, clustering & trend analysis
• Predicting performance outcomes
• Risk scoring and interpretation

Tools

• Excel (Data Analysis ToolPak)
• Power BI (AutoML – optional)
• Beginner-level AI tools for prediction

Learning Outcomes

• Understand how predictive HR models work
• Identify employee attrition patterns
• Build simple predictive models using available tools

Practical Activities

• Create an attrition prediction model
• Identify high-risk employee groups

Module 6: HR Metrics & KPIs

Hours: 3

Topics

• Core HR metrics:
• Headcount
• Attrition rate
• Recruitment lead time
• Cost per hire
• Training ROI
• Performance distribution
• Engagement index
• Strategic HR Metrics:
• Quality of hire
• Leadership pipeline strength
• Skills gap index
• Talent mobility rate
• KPI dashboards for:
• Talent Acquisition
• Performance Management
• L&D
• Workforce Planning

Practical Activities

• Create a KPI scorecard for an HR department

Module 7: Capstone Project & Assessment

Hours: 2

Capstone Project Options (Choose One)

1. Build an HR Analytics Dashboard (Excel or Power BI)
2. Create a predictive attrition model
3. Develop a KPI scorecard for your HR department

Entry Qualifications

• HR Managers, HR Executives, Talent Acquisition Teams, HR Business Partners
• University CDC/Placement unit members
• Anyone transitioning to data-driven HR roles
• Basic knowledge of Excel is helpful but not mandatory

Career Pathways

• HR Analytics Specialist – High-demand role in multinational & large local companies
• People Analytics Manager – Lead data-driven HR transformation
• HR Business Partner (Analytics) – Strategic partner using data insights
• Workforce Planning Analyst – Forecast hiring & skill gaps
• Talent Intelligence Lead – Drive recruitment with predictive analytics
• HR Dashboard & Reporting Expert – Freelance or full-time in any industry

Assessment Criteria

• Class participation & practical exercises – 30%
• Hands-on assignments & module projects – 30%
• Final Capstone Project & Presentation – 40%
• Certification: Official Micro-Credential Certificate from DIU (minimum 70% grade + 80% attendance)

Course Deliverables

• HR Analytics Excel Toolkit
• HR KPI Templates
• Power BI Dashboard Files
• Clean HR Datasets for Practice
• Lifetime access to recorded sessions & materials