HR Analytics - 2025
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
8 month duration
2 Month Internship
Course Duration
6 Months of Instructor-led classes with an option of 2 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
Introduction to HR Analytics
The Introduction to HR Analytics is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Tools and software Installation
How to Download Excel
How to Download Power BI (Windows) I
How to Download Power BI (Windows) II
How to Download PostgreSQL
Module 2: Introduction to HR Analytics
Welcome Address
Learning Structure and Roadmap
About Facilitators on the LMS
Stages of learning HR Analytics
What is HR Analytics?
Who is a HR Analyst?
Careers in HR Analytics
Relevance Of HR Analytics
Tools and technologies in HR Analytics
Core skills of a HR Analyst
Applications of HR Analytics in various industries
Module 3: Introduction to Data Analytics
What is Data?
Types of Data
What is Big Data?
Data Analytics and Its Types
Differences between Data Analytics and Data Analysis
Careers in Data Analytics and its relevance
Module 4: Problem Solving
What is a problem?
Types of problems in data analytics
Problems in real-life as a Data Analyst
The problem-solving phase
Seven problem solving techniques
Crisp-DM Framework
KDD - Knowledge Discovery in Databases
Root Cause Analysis
Decision Trees
Pareto Principle
DMAIC Methodology
SWOT Analysis
Mental Maths
Module 5: Building a Portfolio
Portfolio Checklist
Experiencing VScode
Editing the HTML Template
Uploading your portfolio on GitHub Pages
Module 6: Optimize your LinkedIn Profile
Introduction
Creating your LinkedIn Profile
Uploading your Profile Picture and Cover
Crafting your headline
Your About Section
Work Experience
Education
Skills - Endorsements - Recommendations
Always Refer to your LinkedIn Pack
LinkedIn X JobAlytics
UK Visa Sponsorship LinkedIn Extension
Modifying LinkedIn Settings
Week 1
Excel for Analytics I
The Excel for Analytics I is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Introduction to Excel
Overview of Excel for Data Analytics
Introduction to Microsoft Excel
Cell Referencing
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: 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
Excel for Analytics II
The Excel for Analytics II is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: 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
Data Presentation, Storytelling and Dashboarding
The Data Presentation, Storytelling and Dashboarding is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: 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 6
Introduction to Power BI & Data Modelling
The Introduction to Power BI & Data Modelling is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Introduction to Power BI
Introduction to Power BI
Why Power BI and not Excel
Understanding the Power BI Workflow
Types of Data Connector
Power Query Editor
Dax functions and M Language
Case Study - Dax functions and M Language
building your first dashboard PRT 1
building your first dashboard PRT 2
building your first dashboard PRT 3
Module 2: Introduction to Data Modelling
What is Data Modelling?
Why Data Modelling?
Concept of Primary and Foreign keys
Concept of Fact and Dimension Table
Types of Relationships in a data model
Types of Schemas
Build your first Data Model using Draw.io PRT 1
Build your first Data Model using Draw.io PRT 2
Export Draw.io Data Model
Write your first Calendar DAX
Calculated Column vs Measures
Case Study - Data modeling Deskify
Case Study - Creating Dax Measures
Case Study - Dashboard 1
Case Study - Dashboard 2
Case Study - Dashboard 3
Week 7
Intermediate Power BI
The Intermediate Power BI is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Intermediate Power BI (DAX and Dashboarding)
Web Scraping Tabular Format using Power BI Part 1
Web Scraping Tabular Format using Power BI - Case Study Part 2
Web Scraping Non-Tabular Format using Power BI- Case Study PRT 3
Connect Power BI to a Folder part 1
Connect Power BI to a Folder part 2
Connect Power BI to a Folder part 3
Connect Power BI to a Folder part 4
Connect Power BI to a Folder part 5
Connect Power BI to a Folder part 6
Connect Power BI to a API data source
Intermediate DAX Functions
AI Visuals - Case Study (Clarity Care)
AI Visuals Dashboard - Case Study (Clarity Care)
Module 2: Case study on connecting Multiple Data Source
Case study Connect To Multiple Data Source 1
Case study Connect To Multiple Data Source 2
Case study Connect To Multiple Data Source 3
Case study Connect To Multiple Data Source 4
Case study Connect To Multiple Data Source 5
Week 8
Power BI Service
The Power BI Service is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Power BI Service
Introduction to Power BI Service
Case Study (Tri-Fleet Industries) Power BI Service
Loading the Dataset to Power BI Service
Building Tri-Fleet Industries Report
Signing In your Developer Account On Power BI Desktop
Defining roles for RLS (Row-level security)
create a workspace & publish your Report
Adding Team Members to a workspace
Implement Row Level Security (RLS)
Create A Dashboard in power Bi Service
Creating Apps in Power BI service for sharing reports
Creating Scorecard in power Bi Service
Week 11
Introduction to SQL
The Introduction to SQL is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Introduction to SQL
What is a Database
Difference between Database, Data warehouse, Data lake, Data Mart and Delta Lake (A)
Difference between Database, Data warehouse, Data lake, Data Mart and Delta Lake (B)
Why SQL
What is SQL
OLAP vs OLTP
SQL vs NoSQL
Real-World application of SQL as a Data Analyst
Database Tables
Primary vs Foreign Keys
Facts and Dimension Tables
Relationships in SQL
Entity Relationship Diagram
Module 2: Case Study on Basic Functions in SQL
Case Study on Basic Functions in SQL
Restoring Database
Data Types in SQL and Other Preliminaries
Module 3: 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 12
SQL For Data Analytics
The SQL For Data Analytics is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: SQL JOINS
Inner Join
LEFT JOIN
RIGHT JOIN 1
RIGHT JOIN 2
FULL JOIN & ALIASES
Week 13
SQL Functions
The SQL Functions is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: SQL Functions _Module 3
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
Module 2: SQL -Statement, Operators & Agg Functions
The SELECT Statement
SELECT Distinct
The "WHERE" Statement
SELECT Count
The "LIMIT" Statement
The "ORDER BY" Statement
The "BETWEEN" Statement
The "IN" Operator
The "LIKE Or ILIKE" Operator
Aggregate Function - MIN & MAX
Aggregate Function - SUM, COUNT, AVG
GROUP BY
HAVING
Module 3: SQL - JOINS, Union & Sub-Queries
JOINS & UNION
INNER JOINS
LEFT JOINS
RIGHT JOIN
FULL JOIN
UNION
SUB-QUERIES
Module 4: SQL Functions
CASE & WHEN
COALESCE
CAST
Combining COALESCE, CAST & SUBQUERIES
Optimizing your queries
Module 5: Case study connecting powerBI to PostgreSQL
Case study connecting powerBI to PostgreSQL
Week 15
HR Analytics Fundamentals
The HR Analytics Fundamentals is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: HR Analytics Fundamentals
Fundamentals of HR Analytics
Purpose of HR Analytics
Introduction to People Data Basics
Understanding Your Data's Origins
Identify Data Questions To Ask
Areas of HR Analytics
Regulatory Hurdles in HR Analytics
How HR &People Data Drives Impact & The Perception of HR & People Teams
Module 2: HRA -Reducing Workforce Risk & Optimizing Productivity - Overview
Week 17
Key Metrics and Analytical Areas in HR Analytics PRT 1
The Key Metrics and Analytical Areas in HR Analytics PRT 1 is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Analyzing Critical HR Data Points I
Week 19
Key Metrics and Analytical Areas in HR Analytics PRT 2
The Key Metrics and Analytical Areas in HR Analytics PRT 2 is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Analyzing Critical HR Data Points II
Week 21
Extra - Microsoft Fabric and ChatGPT
The Extra - Microsoft Fabric and ChatGPT is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Microsoft Fabric
Module 2: ChatGPT
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
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.
