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
8 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 5
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 6
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)
Week 7
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
Week 9
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
Week 10
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 For Data Analytics
Week 11
SQL Functions
The SQL Functions is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: SQL Functions
Week 13
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
Week 15
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 17
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 19
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.
