📊 Day 3: HR Analytics & Business Intelligence

Ghaziabad, Mohan Nagar

Drafted by: HR Prateek Sharma

📈 Key Metrics

Attrition Rate (A.R): Total Employees Left / Total Employees × 100
Example: 45/1500 × 100 = 3%

Yearly Increment of Employee = 10%

🔍 Four Types of Analytics

1. Descriptive Analytics

Like describing the problem to a doctor

• Name, Age, Gender, Address
• Last college name
• Kinship Rule: Blood relations allowed in companies (preference-based)
• Considerations: Discrimination, same company experience

2. Diagnostic Analytics

Statistics = The science of understanding data

Key measures: Mean, Median, Mode, Variance, Standard Deviation, Correlation

Statistical Tests:

• ANOVA Test
• Chi-Square Test
• Z Test
• T-Test
• Null Hypothesis Checking

3. Predictive Analytics

Descriptive + Diagnostic = Predictive

• Predicts who will leave the organization
• Uses Machine Learning
• Correlation: Relations between variables (-1 to +1)
  • Direct correlation
  • Indirect correlation
  • No correlation

Example Flow:
• Pratik left the organization (Descriptive)
• Why did Pratik leave? (Diagnostic)
• Heemani will leave the organization (Predictive)

4. Prescriptive Analytics

• Suggestions
• Remarks
• Decisions to be taken

💼 Key Systems

• HRMS: Human Resource Management System
• LMS: Learning Management System (studying in ITS)
• LMS: Lead Management System (sales in marketing)
• MIS: Management Information System (qualification, attendance)

📊 Excel Functions

Basic: Sum, Minimum, Maximum, Large, Small

Advanced: VLOOKUP, HLOOKUP, INDEX, MATCH, SUMIF, SUMIFS, MINIF, MINIFS, MAXIF, COUNTIF, COUNTIFS, Pivot Table, Conditional Formatting, Remove Duplicates, Dashboard

Excel Limits:

• Rows: 10,48,576
• Columns: 16,384
• Note: Servers can handle unlimited data

🔧 Business Intelligence Tools

Power BI (Microsoft)

• Create reports & dashboards
• Share reports
• Data modeling (merging multiple datasets)
• All Excel functionality plus more

Alternative Tools:

Tableau
by Salesforce

Google Looker Studio
by Google

QuickSight
by Amazon

Zoho Analytics
by Zoho

🗄️ SQL - Structured Query Language

Essential for database management and data analysis

Ghaziabad, Mohan Nagar

Design & Content by HR Prateek Sharma

Day 3 - HR Analytics & Business Intelligence Training