PBIHRP

HR Analytics for Human Resource Professionals

About the Course

This course is designed to provide Human Resource (HR) professionals with in-depth knowledge of human resource with CHRP certification—those who are ongoing and those who are planning to have the course. Participants will learn to develop interactive dashboards, apply advanced analytics techniques, and solve real-world HR challenges using data-driven strategies. Some of the tools that will be used include Power BI, QlikSense, and Python.

Who Can Study

  • HR Managers and Business Partners

  • Talent Acquisition and Recruitment Teams

  • Compensation and Benefits Analysts

  • Learning & Development Specialists

  • HR Data Analysts and Reporting Officers

  • Workforce Planners and Strategy Experts

  • HR Professionals seeking data visualization skills

Course Outline: 12 Modules
Fundamentals of HR Analytics and to other tools

  • Overview of HR analytics and strategic workforce planning

  • Introduction to analytical tools such as Power BI, QlikSense, and Python: ecosystem, versions, benefits

  • Key HR metrics and KPIs (e.g., absenteeism, turnover, training ROI)

  • Real-world case: Linking turnover rate with engagement survey data

  • Connecting analytical tools such as Power BI, QlikSense, and Python to Excel, SQL, HRIS systems, and cloud data
  • Overview of common HR data tables: Employees, Payroll, Recruitment
  • Example: Importing multiple Excel files containing monthly headcount data
  • Using Power Query to clean inconsistent or incomplete HR data
  • Transformations: unpivot, replace values, change data types
  • Example: Cleaning job titles from recruitment system exports

  • Creating relationships between HR tables (e.g., employees to departments)

  • Star schema and normalization concepts for HR datasets

  • Example: Link employees with department, manager, and location data

  • Creating bar charts, line graphs, tables, cards, and slicers using suitable tool chosen by the learner.

  • Choosing the right chart for HR insights (e.g., attrition by month)

  • Example: Visualize headcount by department and gender

  • Introduction to DAX for HR analytics (e.g., age group, tenure)

  • Creating calculated columns: categorize employees by age range

  • Example: Tenure bucket classification (0-1, 2-5, 6+ years)

  • Building dynamic measures: turnover rate, training cost per employee

  • Using DAX functions like CALCULATE, FILTER, COUNTROWS

  • Example: Calculate department-wise turnover over time

  • Combining visuals into professional dashboards

  • Using slicers, filters, bookmarks, and drill-through for interactivity

  • Example: Interactive dashboard to explore recruitment pipeline by stage and department

  • Publishing to Power BI Service and setting up workspaces

  • Sharing reports securely with managers and executives

  • Example: Embedding a dashboard in Microsoft Teams for HR leadership

  • Applying Row-Level Security (RLS) in sensitive HR data

  • Ensuring GDPR and data confidentiality compliance

  • Example: Limiting HRBP access to their region’s employee data

  • Building dashboards for: Diversity and inclusion, Performance and training and Payroll and compensation trends
  • Example: Diversity dashboard showing gender and ethnic breakdown by level
  • Choose a business case (e.g., high attrition, training effectiveness)
  • Design a complete dashboard using course techniques
  • Present to peers and instructors with actionable insights
  • Peer feedback and final assessment
Course Deliverables

  • Editable Power BI dashboard templates

  • Clean HR data samples (Excel, CSV)

  • Reference slides and function cheat sheets

  • Sample case studies and solutions

  • Certificate of Completion

Tools & Software Used

  • Microsoft Power BI Desktop

  • Power BI Service

  • Microsoft Excel

  • SQL Server (optional)

  • Power Query and DAX Editor

  • Microsoft Teams/SharePoint for collaboration

Mode of Study

1. Online Learning
Access your course learning material through our Learning Management System(LMS).

2. Part Time

Early Morning Classes: 6am to 8am
Evening Classes: 5:30pm to 9:45pm

Exemptions
Fees Structure
DURATION FEES
5 days in person. 10 days online Ksh 37,500

Register and enhance your professional skills.

PBIHRP and GRC & Data Protection

  • Duration
    Online: 4 Weeks
  • Investment: Ksh 37,500
Entry Qualifications
  • KCSE C+
  • Kasneb professional qualification
  • Bachelors’ degree from a recognized university
  • Any other qualification considered equivalent to the above
Files