HR Analytics
Certification Program
300+ Hiring Partners
175% Average Salary Hike
Hybrid Model for Project Sessions
www.learnbay.co
+91 77956 87988
Context
About the program 01
Program highlights 02
Why learn HR analytics? 03
Program details 04
Check out what our alumni has to say 05
Career service 06
Learning path 07
Program syllabus 08
Real-time projects and case-studies 09
Certification 10
11
Learnvista Pvt. Ltd. www.learnbay.co +91 77956 87988
About The Program
Our HR Analytics program offers practical training to
2cr enhance careers in this field. Through real-world case
worth studies and industry knowledge, you'll gain the skills
scholarships
awarded needed for success. You'll analyse HR data to make
better decisions in areas such as talent acquisition
and employee engagement, optimising human capital
for a competitive edge. We offer affordable and
relevant education to empower India's workforce.
600+
professionals
secured jobs
after a career We exist to provide accessible, reasonable, and
break industry-relevant education that empowers
India's workforce to grow and develop.
30k+ Thousands of student reviews on Switchup,
Trusted Course Report, Google and more
Learners
Program Highlights
Industry-Relevant & 360 Degree Knowledge
Updated Syllabus Building
Learn the industry's latest tools, Develop practical skills through
techniques & trends. Gain hands- real-world projects and
on experience developing assignments
various apps.
1:1 Dedicated Multiple Career
Mentorship Opportunities
Personalized learning experience Boost hr analytics career and
from experienced industry land roles as hr data analyst, hr
professionals. manager, etc
Why Learn HR Analytics?
60% rise in 250% highest 300+ partner
data science jobs salary hike companies
Placement Report
30K+ 9K+ 50K+
Trusted Learners Successfully Placed Job Interviews Cracked
Book a free consultation with expert Contacts Us
Program Details
ELIGIBILITY
Working professional having more than 6 months of experience in any
domain (Technical/Non-Technical)
Qualification:
BE/B.Tech (from any branch), BBA/MBA, MCA/M.Tech, B.Com, B.Sc
(in any branch)
Course duration : 200+ hours
Weekday Batch : 5 months Weekend Batch : 7 months
Monday - Friday : 2 hrs/day Saturday - Sunday: 3.5 hrs/day
About instructors:
Experienced software development instructors share valuable practical
knowledge and effective solutions, preparing students for success in the
industry.
Total Fees: EASY EMI
₹ 89,000/- + 18% GST ₹ 8,752/month
Financing partners
₹ 1,05,020/-
What Our Alumni's Say
Learnbay has helped me a lot to learn data science
applications in the e-commerce industry. The live
Shravanthi A class concept was really helpful in receiving proper
Data Scientist DS training. Thanks to all my mentors and the
placement team.
230%
Salary Hike
I knew nothing about data science before I joined
Learnbay. But through a variety of instructors, I
Ritesh Kumar steadily developed my notion and received solid
Associate Consultant knowledge and conceptual training in data science
with hike of 150%.
150%
Salary Hike
When I joined Learnbay I did not have any
knowledge apart from the very basics. I gradually
Saurabh Kumar build my concept via various trainers and get
Data Scientist & Statistician trained in data science with strong
knowledge/concepts.
135%
Salary Hike
What Our Alumni's Say
The course structure is excellent with emphasis on
concept building and tools & software at the same
Preksha Mishra time. The support team is excellent and supportive
Lead Data Scientist and quite agile to respond to doubts.
140%
Salary Hike
Thanks to the Learnbay data science course &
excellent guidance, I was able to ace the TCS
Mohd. Israr interview and secure a job with a 210% pay raise.
Data Scientist The real-world time projects helped me develop my
concepts as a data scientist.
210%
Salary Hike
Learnbay stands out with expert-led courses that
offer practical and up-to-date content. Hands-on
learning and ample resources make it accessible
for anyone seeking to upskill in AI, ML, or data
Sweekrithi shetty
science. Learnbay is an excellent choice to learn
and grow in these rapidly-evolving fields.
Learning Path
Projects & Deployment
04 AWS + Azure
Data Visualization
03 Tableau, PowerBI
Business Analytics Tools
02 Excel, Statistics, SQL, MongoDB
01 Cohort Orientation + Preparatory Classes
IBM Course Certificate
Complete your training with the globally
recognized certificate.
Microsoft Course Certificate
Achieve professional growth & increase
earning potential with Microsoft
certification
Obtain an internationally recognized certificate through training
Enhance your IT profile with IBM's certification
Boost job opportunities and earnings with Microsoft’s certification
Career Service
Get 1 year of Job and Placement support
Unleash your career potential with 1 year of unlimited
job access, interview support, and profile review.
Get 3 mock interviews with industry leaders
Master the art of HR analytics and stay ahead of the
curve with mockups and industry insights
Resume build up session
Craft a powerful resume showcasing your expertise in hr
to stand out from the competition.
Get 5-8 interview calls
Receive 5-8 interview calls from a diverse pool of
interested employers/recruiters.
Program Syllabus
HRM
Introduction to Strategic Human Resource Management using Data Analytics
Data analytics in SHRM involves using statistical and analytical methods to
analyze data related to HR functions such as recruitment, retention, training and
development, compensation, and performance management.
Fundamentals of Data Analytics
Understanding organizational development based on analytics
Strategies of HR leadership in a data driven way
The digitized people management process
Importance of data analytics in people management
Overview of Domains
Introduction to BFSI, Marketing, and Sales domains
Importance of analytics in these domains
Tools and techniques for process automation
Current trends and challenges in these domains
Case studies: This section includes case studies from various industries and
domains to illustrate the application of business analytics in real-world scenarios.
TERM 1
Program Syllabus
EXCEL Module 1 (30 hours)
Basic Excel Functions Formatting Worksheets
Creating a New Workbook Creating Headers, Footers, and Page
Navigating in Excel Numbers
Moving the Cell Pointer Adjusting Page Margins and
Using Excel Menus Orientation
Using Excel Toolbars: Hiding, Adding Print Titles and Gridlines, rows
Displaying, and Moving Toolbars to repeat at top of each page
Entering Values in a Worksheet and Formatting Fonts & Values
Selecting a Cell Range Adjusting Row Height and Column
Previewing and Printing a Worksheet Width
Saving a Workbook & Re-opening a Changing Cell Alignment
saved workbook Adding Borders
Applying Colors and Patterns
EXCEL
Using the Format Painter
Managing Worksheets Merging Cells, Rotating Text
Switching Between Sheets in a Using AutoFill
Workbook
Inserting and Deleting Worksheets
Renaming and Moving Worksheets
Editing and Managing Cell Data
Protecting a Workbook
Hiding Columns, Rows, and Sheets Cutting, Copying, and Pasting Cells
Splitting and Freezing a Window Moving and Copying Cells with Drag
Inserting Page Breaks and Drop
Advanced Printing Options Collecting and Pasting Multiple Items
Using the Paste Special Command
Inserting and Deleting Cells, Rows,
and Columns
Editing and Managing Cell Data Using Undo, Redo, and Repeat
Entering Date Values and using Checking Your Spelling
AutoComplete Finding and Replacing Information
Editing, Clearing, and Replacing Cell Inserting Cell Comments
Contents
TERM 1
Program Syllabus
Module 1 (30 hours)
EXCEL
Basic Formulas and Functions Advanced Functions
Creating a Basic Formula Working with the Forms Menu
Cell Referencing Sorting, Subtotaling & Filtering Data
Calculating Value Totals with Copy & Paste Filtered Records
AutoSum Using Data Validation
Editing & Copying Formulas
Fixing Errors in Your Formulas
Formulas with Several Operators and
Cell Ranges
Conditional Formatting
EXCEL
Creating Charts
Creating & Working with Charts
Creating a Chart
Moving and Resizing a Chart
Formatting and Editing Objects in a
Chart
Changing a Chart's Source Data
Changing a Chart Type and Working
with Pie Charts
Adding Titles, Gridlines, and a Data
Table
Formatting a Data Series and Chart
Axis
Using Fill Effects
TERM 1
Program Syllabus
Business Analytics
CASE STUDY
HR Efficiency Analysis:
This case study involved the use of advanced Excel and VBA to analyze a company’s
HR data. The goal of the analysis was to identify any areas in which the company was
losing money due to inefficient HR practices.
Employee Performance Analysis:
This case study involves the use of advanced Excel and VBA to analyze a company’s
employee performance. The goal of the analysis was to identify employees who were
underperforming and to identify areas in their job performance that were lacking.
EXCEL
TERM 1
Program Syllabus
Business Analytics
STATISTICS Module 2 (30 hours)
R programming fundamentals Statistics
Data types in R Variables (quantitative, categorical,
Functions and arguments discrete, continuous)
Manipulating Data Population, sample, sample size
Data transformation with R - the Data visualization basics and R code
Dplyr package (histogram, bar chart, frequency
Building a histogram, bar chart, box distribution)
and whiskers plot with ggplot2
Sampling Techniques
Descriptive Statistics
Probabilistic & non-probabilistic
Measures of central tendency (mean, sampling
median, mode)
EXCEL Simple random, systematic, cluster,
Measures of dispersion (SD, variance, stratified, convenience, quota,
range, IQR) snowball, judgement
Symmetricity/shape measures
(skewness, kurtosis)
Box plot and outliers Probability
Covariance and correlation Binomial distribution
Normal distribution (properties, Z
table, empirical rule, central limit
Probability theorem)
Random experiments and events
(mutually exclusive, joint, dependent,
Inferential Statistics:
independent)
Probability rules Introduction to inferential statistics
Bayes' theorem Sampling techniques (probabilistic
Probability distributions (types: and non-probabilistic)
discrete, continuous) Point and interval estimation
TERM 1
Program Syllabus
STATISTICS Module 2 (30 hours)
Hypothesis testing Experimental Design
Definition, need, significance level, Types of experiments
null and alternative hypothesis. Randomized designs
One/two-tailed tests, critical value, Matched-pair and Block designs
rejection region, Type I/II errors Factorial designs
One sample tests (Z, t, proportion) Experimental units
Control and treatment groups
Multivariate Analysis
Time Series Analysis
Principal Component Analysis (PCA)
Factor Analysis Stationarity and Autocorrelation
Cluster Analysis Forecasting methods
Linear Algebra
Bayesian Statistics
Vectors (plotting, norm, addition,
Bayesian inference
scalar multiplication, dot product,
Posterior distribution
projection)
Bayesian hierarchical models
Matrices (indexing, types, addition,
Markov Chain Monte Carlo (MCMC)
multiplication, transpose,
determinant, trace)
TERM 1
Program Syllabus
CASE STUDY Module 2 (30 hours)
Performance Review Analysis Salary Analysis
Performance review analysis is an Salary analysis is another
important application of statistics important application of statistics
in HR analytics. This technique is in HR analytics. This technique is
used to evaluate the performance used to analyze the salaries of
of employees by using a variety of employees in different roles,
metrics such as attendance, work departments, and levels. Statistical
efficiency, customer feedback, and analysis of salary data helps to
productivity. Statistical analysis of identify discrepancies in salary and
these metrics helps to identify devise strategies to ensure
areas of improvement and track fairness and equity in
progress over time. compensation.
TERM 1
Program Syllabus
SQL Module - 3 (14 hours)
SQL and RDBMS Advance SQL
RDBMS And SQL Operations. Advance SQL Operations
Single Table Queries - SELECT, Data Aggregations and summarizing
WHERE, the data
ORDER BY, Distinct, And, OR Ranking Functions: Top-N Analysis
Multiple Table Queries: INNER, SELF, Advanced SQL Queries for Analytics
CROSS, and OUTER, Join, Left Join,
Right
Join, Full Join, Union
JSON Data & CRUD
Basics and CRUD Operation
Databases, Collection & Documents
NoSQL, HBase & MongoDB Shell & MongoDB drivers
NoSQL Databases What is JSON Data
Introduction to HBase Create, Read, Update, Delete
HBase Architecture, HBase Finding, Deleting, Updating, Inserting
Components, Storage Model of HBase Elements
HBase vs RDBMS Working with Arrays
Introduction to Mongo DB, CRUD Understanding Schemas and
Advantages of MongoDB over RDBMS Relations
Programming with SQL
Programming with SQL
Partitioning
Mathematical Functions Filtering Data
Variables Subqueries
Conditional Logic
Loops
Custom Functions
Grouping and Ordering
TERM 1
Program Syllabus
SQL Module - 3 (14 hours)
Assignments
Working with multiple tables
Practice Joins, Grouping and Subqueries
Using GROUP BY and HAVING Clauses
Practice Aggregation Queries
TERM 1
Program Syllabus
MongoDB Module - 04 (14 hours)
Introduction to MongoDB MongoDB (Advance)
What is MongoDB MongoDB Use cases
Characteristics and Features MongoDB Structures
MongoDB Ecosystem MongoDB Shell vs MongoDB Server
Installation process Data Formats in MongoDB
Connecting to MongoDB database MongoDB Aggregation Framework
Introduction to NoSQL Aggregating Documents
Introduction of MongoDB module Working with MongoDB Compass &
What are Object Ids in MongoDB exploring data visually
Understanding Create, Read, Update,
Delete
Schemas & Relations
Document Structure
Working with Numeric Data
Assignment
Working on Scheme Designing
Obtain the data in the
format you want by
formulating queries that are
both effective and high- Tools covered
performing.
TERM 2
Program Syllabus
Business Analytics
TABLEAU Module 1 (24 hours)
Introduction to Tableau Connecting to Data Sources
Overview of Tableau and its key Connecting to different data sources
features and importing data into Tableau
Introduction to data visualization Working with different data types and
concepts and techniques formats
Understanding the Tableau interface Cleaning and transforming data in
and its main components Tableau
Creating Visualizations in Tableau
Creating basic visualizations using
Tableau, including
Visual Analytics in Tableau
Bar chart
EXCEL Understanding visual analytics
Line chart
concepts and techniques
Scatter plot
Sorting and grouping data in Tableau
Heat map
Using sets and set actions in Tableau
Different chart types and features in
Filtering data in Tableau, including
Tableau, such as:
interactive filters
Tree maps
Bubble charts
Waterfall charts
Applying best practices for Forecasting and Clustering in Tableau
formatting, labeling, and annotations
Creating calculated columns and
in Tableau
using them in visualizations, such as:
Histograms, Box plots
Using Tableau's trend lines to analyze
data
Forecasting and Clustering in Tableau
Using forecasting and clustering
techniques in Tableau
TERM 2
Program Syllabus
TABLEAU Module 1 (24 hours)
Dashboard and Stories in Tableau Mapping in Tableau
Creating interactive dashboards in Using Tableau's mapping capabilities
Tableau to visualize data on maps
Using sheets and objects to design Plotting latitude and longitude data
effective dashboards using Tableau maps
Adding filters, legends, and quick Creating custom geocoding in
filters to dashboards Tableau
Creating stories in Tableau to present Creating polygon maps and using
data in a narrative format WMS and background images for
maps
EXCEL
CASE STUDY
Generating reports on employee performance using Tableau
Tableau can be used to generate reports on employee performance by creating
visualizations using data from performance reviews or evaluation forms. These
visualizations can be used to compare performance against company goals, identify
areas of improvement, and track progress over time.
TERM 2
Program Syllabus
Business Analytics
PowerBI Module 2 (30 hours)
Introduction to Power BI Data Transformation and Modeling
What is Power BI and why use it? Importing and cleaning data
Getting familiar with the Power BI Transforming data with Power Query
interface Editor
Understanding data sources and Creating calculated columns and
connections measures
Creating relationships between tables
Data Visualization and Exploration
Creating basic charts (bar, line, pie, Advanced Analytics with DAX
etc.) Understanding DAX formulas and
Enhancing visualizations with functions
formatting and design
EXCEL Creating complex calculations and
Using interactive features (filters, expressions
slicers, drill down/up) Using time intelligence functions
Creating custom visuals with Power BI
visuals marketplace
Power BI Integration with other tools
Integrating Power BI with Excel
Power BI Service and Collaboration Using Power BI with SharePoint and
Publishing reports to the Power BI Teams
service Connecting to other data sources
Sharing and collaborating with others (Azure, SQL Server, etc.)
Creating and managing workspaces
Using Power BI mobile app
TERM 2
Program Syllabus
PowerBI
Generating reports on recruitment trends using PowerBI
PowerBI can be used to generate reports on recruitment trends by creating
visualizations using data from job postings or recruitment processes. These
visualizations can be used to compare recruitment efforts against company goals,
identify areas of improvement, and track progress over time.
TERM 3
Program Syllabus
Business Analytics
DATA SCIENCE & AI Module 1 (30 hours)
Introduction to Data Science and AI Machine Learning Fundamentals
Definition, history, and applications. Supervised, unsupervised, and
Key components of Data Science and reinforcement learning.
AI (data, algorithms, computing Bias-variance tradeoff, overfitting,
power). and underfitting.
Popular programming language (R) Model selection and evaluation
and development tools (Jupyter metrics (accuracy, precision, recall, F1
Notebook, Spyder) score, ROC curve, AUC).
Hyperparameter tuning and model
optimization techniques
Natural Language Processing (NLP)
Text processing techniques
(tokenization, stemming,
EXCEL Advanced NLP Techniques
lemmatization).
Named Entity Recognition (NER),
Sentiment analysis, document
Topic Modeling, Text Generation.
classification, and information
Pre-trained language models (BERT,
retrieval
GPT, XLNet) and Transfer Learning in
NLP
Popular ML Libraries
Tools covered
scikit-learn, XGBoost, LightGBM,
TensorFlow, Keras, PyTorch.
Model optimization techniques (Grid
search, Random search, Bayesian
optimization)
TERM 3
Program Syllabus
CASE STUDY
Image Classification Chatbot
Develop an AI model that can Build an AI-powered chatbot that can
accurately classify images into communicate with users and respond
different categories. Use popular to their queries in a natural language.
datasets like MNIST or CIFAR-10 and a You can use a natural language
machine learning library like processing library like NLTK or SpaCy
TensorFlow or PyTorch. and a conversational AI platform like
Dialogflow or Rasa
Sentiment Analysis
Employee Outcome Prediction and
Develop an AI model that can classify
Optimization
EXCELtext into positive, negative, or neutral
sentiment. Use popular datasets like Predict employee outcomes such as
IMDb or Twitter sentiment analysis performance, turnover, or job
dataset and a machine learning satisfaction, optimize employee
library like scikit-learn or Keras scheduling or to develop more
effective training programs
Decision Tree Analysis for Employee
Management
Use decision trees to identify the best
course of action for a given situation,
such as whether to terminate an
employee or provide additional
training
TERM 3
Program Syllabus
Deployment AWS+Azure Module - 2 (10 hours)
Introduction to AWS and Azure Setting up the Environment
Machine Learning Services Creating AWS and Azure
Overview of AWS SageMaker and accounts
Azure Machine Learning Configuring the required tools
Key features and benefits of and SDKs (e.g. AWS CLI, Azure
using these platforms CLI, Azure PowerShell)
Understanding different types of Understanding the infrastructure
machine learning algorithms and requirements for training and
CASE STUDY
use cases deploying models (e.g. EC2
instances, GPU instances, Azure
ML Compute)
Data Preparation and Feature
Engineering
Model Training and Evaluation
Understanding the data
Choosing the right machine
requirements for machine
learning algorithm and model
learning models (e.g. structured
(e.g. regression, classification,
vs unstructured data, data size,
clustering)
data quality)
Training models using AWS
Data cleaning and preprocessing
SageMaker and Azure Machine
techniques (e.g. missing value
Learning (e.g. using built-in
imputation, feature scaling,
algorithms, custom code)
encoding categorical variables)
Evaluating model performance
Feature selection and
and tuning hyperparameters (e.g.
engineering techniques (e.g. PCA,
cross-validation, hyperparameter
feature importance)
optimization)
TERM 3
Program Syllabus
Deployment AWS+Azure Module - 2 (10 hours)
Model Deployment and Management
Deploying trained models on AWS SageMaker and Azure Machine Learning (e.g.
creating endpoints, batch inference)
Monitoring model performance and managing versions (e.g. model drift, A/B testing)
Integration with other services and applications (e.g. AWS Lambda, Azure Functions)
techniques (e.g. PCA, feature importance)
CASE STUDY
Advanced Topics in Machine Learning on AWS and Azure
Deep learning techniques and architectures (e.g. neural networks, convolutional
neural networks, recurrent neural networks)
Natural Language Processing (NLP) use cases (e.g. text classification, sentiment
analysis, language translation)
Understanding the costs and pricing models for machine learning on AWS and Azure
(e.g. instance pricing, storage pricing, model deployment pricing)
CASE STUDY
Real-time Projects
Domain: HR
Workforce Planning at GE
GE uses predictive analytics to forecast future talent needs and identify gaps in their
workforce. By analyzing HR data such as employee demographics, attrition rates, and skills,
GE can make informed decisions about hiring and workforce planning.
Predictive analytics, Demographic analysis, Skills gap analysis
Domain: HR
Performance Management at Deloitte
Deloitte uses a data-driven approach to performance management. The company
utilizes analytics to measure employee performance, provide feedback, and identify
areas for improvement
Performance metrics, Feedback analysis, Continuous performance management.
Domain: HR
Succession Planning at AT&T
AT&T uses analytics to identify high-potential employees and develop them for future
leadership roles. By analyzing HR data such as performance metrics, skills, and career
aspirations, AT&T can create targeted development plans for its employees.
Performance metrics, Demographic analysis
Real-time Projects
Domain: HR
Compensation Analytics at Netflix
Netflix uses analytics to determine employee compensation packages. By analyzing HR
data such as market benchmarks, employee performance, and tenure, Netflix can offer
compensation packages that are competitive and fair.
Compensation analysis, Market benchmarking, Performance analysis
Domain: HR
Diversity and Inclusion at Google
Google uses analytics to monitor and improve diversity and inclusion within the
company. By analyzing HR data, such as employee demographics and hiring practices,
Google can identify areas where it needs to improve diversity and create initiatives to
promote inclusion
Diversity metrics, Demographic analysis, Inclusion programs
Contact Us
#1090 Book a counselling session
1st floor, 18th Cross Rd, above with expert
Sangam Sweets, Sector 3, HSR
Layout, Bengaluru, Karnataka Book Now
560102
Follow us on
