HR Analytics
The HR Analytics course is tailored to equip both novices and experienced professionals with essential skills in HR and data analytics. The program uses practical, real-world scenarios to teach problem-solving, HR metrics analysis, and data-driven decision-making. Through interactive learning methods, students will gain the ability to analyze, model, and visualize HR data to support business strategies. Tools such as Microsoft Excel, Power BI, and SQL are extensively covered to enhance analytical proficiency.
1 Course instructors
Instructor led course
6 month duration
2 or 6 Month Internship
Course Duration
6 Months of Instructor-led classes with an option of 2 or 6 Months Internship
Projects
8 Projects
(20% Discount ongoing - Limited slots)
Program fee payment can be in instalments
Course Description
The HR Analytics course is a comprehensive and practical program designed for individuals at any level of expertise, whether you're new to the field or an experienced HR professional aiming to enhance your analytical skills. The course delivers hands-on, real-world training in HR analytics, blending the use of cutting-edge tools like Microsoft Excel, Power BI, and SQL with essential HR metrics and data analysis techniques.
Through interactive, problem-solving-based learning, participants will gain critical skills in analyzing and interpreting HR data, enabling them to provide data-driven insights that support strategic decision-making in their organizations. You'll learn to clean, model, and visualize HR data, while also developing dashboards and reports that align with HR and business objectives.
The curriculum covers a wide range of topics, from foundational concepts in data analytics and HR performance evaluation to advanced applications such as predictive modeling and data storytelling. Students will not only understand the theoretical underpinnings of HR analytics but also gain the confidence to apply their learning through portfolio projects and a virtual internship, ensuring they can immediately add value in their workplaces.
Course Curriculum
Week 0
Week 0 : Introduction
The Week 0 : Introduction is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Installations
How To Download And Install Microsoft Office
How To Download And Install Power BI On Windows
How To Download And Install Power BI On Mac Book
How To Download And Install PostgreSQL
Module 2: Module 0: Introduction to Problem solving
Welcome Address
Introduction To The Programme
Stages In Learning Data Analytics
Data & Big Data
Data Analytics & Career Paths
Intro To Problem Solving & CRISP DM Methodology
Root Cause Analysis
Decision Tree
Adjusting Your Decison Tree In Draw.Io
Pareto Principle
DMAIC Framework
SWOT Analysis
Prioritization Matrix
Creating A Prioritization Matrix Using Excel & Power Point
Module 3: How to Upload Projects on Github
How to create a Portfolio project in Github
Module 4: Portfolio Creation
Portfolio Checklist
Experiencing VScode
Editing the HTML Template
Uploading your portfolio on GitHub Pages
Week 1
Week 1: Microsoft Excel And Data Cleaning
The Week 1: Microsoft Excel And Data Cleaning is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 1: Introduction To Excel
Overview Of Excel For Data Analytics
Introduction To Microsoft Excel
Cell Referencing
Module 2: Module 2: Excel Operations
Excel Shortcuts
Paste Specials
Move Or Copy Data
Hiding And Unhiding Rows/Columns
Freeze Panes
Grouping And Ungrouping Data
Module 3: Module 3: Data Cleaning Functions
Introduction To Data Cleaning In Excel
TRIM Function
CLEAN And VALUE Function
UPPER, LOWER, PROPER And CONCATENATE
SUBSTITUTE Function
LEFT, RIGHT And SEARCH Function
UNIQUE And Remove Duplicate
Week 2
Week 2: Excel For Data Analytics
The Week 2: Excel For Data Analytics is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 4: Data Analyst Toolkit
Data Validation And Conditional Formatting
Referencing, Data Validation And Conditional Formatting
Aggregate Function
Aggregate Function Vs Subtotal
IF, NestedIF And IFS
IF & And, IF & OR And IFERROR
Excel Table, Structured Referencing And COUNTIF
SUMIF(S) And AVERAGEIF(S)
Lookup Functions
Module 2: Extras - Excel Functions
Formulas And Functions In Excel 1
Formulas And Functions In Excel 2
Formulas And Functions In Excel 3
Index And Match
Vlookup
Xlookup
Text Manipulation In Excel
Week 3
Week 3: Dashboarding using Excel
The Week 3: Dashboarding using Excel is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 5: Dashboarding Using Microsoft Excel
Dashboard Introduction
Exercise Intro
Data Analytics
Pivot Tables And Dashboard
Dashboard And Slicers
Module 2: Extra: Dashboarding Exercise
Pivot Table 1
Pivot Table 2
Pivot Table 3
Building Your Dashboard 1
Building Your Dashboard 2
Week 4
Week 4: Getting Started With Power BI
The Week 4: Getting Started With Power BI is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 6: Getting Started with Power BI
Introduction To Power BI for Business Intelligence
The Architecture of Power BI
Concept of Primary Keys and Foreign Keys
Concept of Fact and Dimension
UNderstanding Facts and Dimension in Data Modelling
Data Importation
Data Transformation in Power Query
Creating a Calendar Dimension Table
Building a Data Model
Week 5
Week 5: Building your Dashboard In Power BI
The Week 5: Building your Dashboard In Power BI is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 7: Build your Dashboard in Power BI
Writing DAX Measures
Creating a Dashboard Template in Your report
Building your first Dashboard Part 1
Creating Slicers in Power BI
Building your first Dashboard Part 2
Week 6
Week 6: Power BI Service
The Week 6: Power BI Service is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 8: Power BI Service
Introduction to Power BI Service
Loading the dataset in Power BI
Creating a simple dashboard in Power BI
Defining roles for RLS (Row-level security)
Saving your work & signing in PBI service
Signing in on PBI desktop & Publishing your Report
Row level security (RLS) in PBI Service
Creating Apps in pbi service for sharing report
Creating scorecards in Pbi Service
Creating & Working with Dataflows
Week 7
Week 7: SQL for Analytics
The Week 7: SQL for Analytics is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 9: SQL (Structured Query Language)
Introduction to SQL
Restore your NorthWind Database
SQL Syntax 1
SQL Syntax 2
SQL Syntax 3
SQL Syntax 4 & Save your work
Week 8
Week 8: SQL Joins
The Week 8: SQL Joins is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 10: SQL JOINS
Inner Join
LEFT JOIN
RIGHT JOIN 1
RIGHT JOIN 2
FULL JOIN & ALIASES
Week 9
Week 9: SQL Functions
The Week 9: SQL Functions is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 11: SQL Functions
Introduction To The Case Study
Download And Extract The Database
Restore The Database
CASE & WHEN
COALESCE
CAST
Combining COALESCE, CAST & SUBQUERIES -1
Combining COALESCE, CAST & SUBQUERIES -2
Week 10
Week 10: HR Analytics
The Week 10: HR Analytics is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 12: Introduction to HR Analytics
Introduction to HR Analytics
What is HR Analytics
Areas Of HR Analytics PRT 1
Areas Of HR Analytics PRT 2
Areas Of HR Analytics PRT 3
Module 2: Module 13: Introduction to HR Analytics Metrics
Intro to Improving HR KPI Tracking
Calculating measures on Improving HR KPI Track (Part 1)
Calculating measures on Improving HR KPI Track (Part 2)
Creating Dashboard Template on Improving HR KPI Tracking (Part 1)
Creating Dashboard Template on Improving HR KPI Tracking (Part 2)
Creating Dashboard Template on Improving HR KPI Tracking (Part 3)
Week 11
Week 11: Employee Absenteeism
The Week 11: Employee Absenteeism is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 14: Absenteeism
Introduction to Employee Absenteeism
Importing Your Echo Media Data Into Power Bi
Echo media Data Transformation in Power Query
Calculating DAX for ECHO Media Data
Create your Dashboard Solution for Echo Media PRT 1
Create your Dashboard Solution for Echo Media PRT 2
Week 12
Week 12: Employee Diversity and inclusion
The Week 12: Employee Diversity and inclusion is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 15 : Employee Diversity and inclusion
1. Introduction to Diversity and Inclusion in HRA
2. Case study on Diversity and Inclusion for Acme Corporation
Getting your Dataset into Power Bi
4. Transforming your Dataset in Power Query for Acme Corporation
5. Creating your Calendar Dim for Acme Corporation
6. Calculating Key Measures for Acme Corporation
7. Creating your Dashboard Templet for Acme Corporation
8. Creating your Dashboard solution for Acme Corporation
Week 13
Week 13 : Microsoft Fabrics & ChatGPT
The Week 13 : Microsoft Fabrics & ChatGPT is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 16: Microsoft Fabrics
Introduction to Microsoft Fabrics
Download a copy of the dataset
Set up your Microsoft developer Account
Activating Fabric items
Creating a Fabric Workspace, Lakehouse and upload data into your lakehouse
Writing python codes in Fabric (Data Science)
Module 2: Module 17 : Using ChatGPT for Data Analytics
Meet Your Instructor
Mary Anene
Team lead FA and HR
Mary is a Senior Data Associate with 5+ years of experience across industries. She leverages data to solve problems, drive growth, and empower individuals through training and mentorship.
Job Opportunities
With our Data Analytics Cerificate, you get to work as any of the following:
HR Analyst
HR Data Analyst
People Analyst
Workforce Planning Analyst
Talent Analytics Specialist
Compensation Analyst
Benefits/Reward Analyst
Talent Analyst
HR Operations Analyst
Diversity/Inclusion Analyst
Course Reviews
Got a full-time job with Hugo, in Chicago Illinois as a People Operations Analyst after training with 10Alytics on the HR Analytics program
Victor Oyesina
Landed a full time job with the Telus International, Canada as a HR Data Analyst after training with 10Alytics on the HR Analytics Program
Maureen
Landed a job as a HR Analyst in Birmingham, UK after training with 10Alytics on the HR Analytics Program
Thelma
Select your preferred pricing plan
As an edu-tech brand, we specialize in providing the essential skills and knowledge you need to unlock high-paying opportunities in the dynamic world of technology. Our mission is simple: to empower individuals to pursue their dreams and excel in high-demand tech roles through intensive, hands-on training.
8-Month Plan
Learners looking for extended industry exposure and advanced skill-building.
6 months of classroom learning + 2 months of internship.
Payment Plan: $150 per month for 5 months.
What You Get:
- Extended internship for in-depth practical experience.
- Access to all advanced course materials and certifications.
- Mentorship and career guidance throughout your journey.
12-Month Plan
Learners looking for extended industry exposure and advanced skill-building.
6 months of classroom learning + 6 months of internship.
Payment Plan: $125 per month for 8 months.
What You Get:
- Extended internship for in-depth practical experience.
- Access to all advanced course materials and certifications.
- Mentorship and career guidance throughout your journey.
