HR Analytics Course Curriculum

HR Analytics Course Curriculum

Comprehensive Data Analytics Training

Institute: Ghaziabad, Mohan Nagar

Course Designer: HR Prateek Sharma

📊 HR Analytics Fundamentals
HR Analytics Introduction
Tools Discussion
HR KPI Introduction
HR Funnel and Selection Process
HR Different Phases Analysis
HR Tools and How to Keep Notes
📈 Excel Mastery
Excel Introduction
Google Sheet and Basic Functions
Excel Basic and Advanced Formulas
Data Summarization & Insights
Excel Pivot Table and Charts
Pivot Chart Advanced and Summarization
Excel Lookup: V-Lookup, X-Lookup, H-Lookup
Index, Match & Conditional Formatting
Dashboard Using AI
Dashboard in Excel - KPI's
Final Dashboard and Summary
💡 AI & Modern Tools
AI Tools for HR
Daily Learning Blog Writing
QNA and Notes Making in Detail
📊 Power BI Excellence
Power BI Introduction
Premium Account Creation
ETL, ELT Introduction
Financial Dashboard Project
Power BI Advanced Visuals
Map, Funnel, Ribbon, Gauge
COVID-19 Dashboard Project
Power BI Append or Combine
Power BI Merge or Joins
ELT, ETL, Transformation on Superstore
Data Modeling and Cardinality - Star vs Snow Schema
Max HealthCare Dashboard Development
Slicer, Formatting, Image Action
Publish, Share, PDF Export
🔢 DAX Programming
DAX Introduction
Measure vs Column vs Table
Aggregate Functions, DateTime Functions
DAX Time Intelligence
HR Dashboard Test with Google Sheet Data
📉 Tableau Fundamentals
Tableau Introduction
Visuals Creation - Dimensions vs Measures

© 2025 Ghaziabad, Mohan Nagar | Designed by HR Prateek Sharma

Transform Your HR Career with Data Analytics

Comments

Post a Comment

Popular posts from this blog

  HR Analytics - Day 2 Notes 📊 HR Analytics - Day 2 Ghaziabad, Mohan Nagar 🔄 Different Phases of HR Phase 1: Job Posting Internal Hiring: Recruiting from within the organization External Hiring: Recruiting from outside the organization External Hiring Process: Recruitment Example Scenario: 1000 resumes received for 2 job positions Step 1: Short Listing - ATS (Applicant Tracking System) From 1000 resumes → ATS shortlists → 100 candidates ⚠️ Critical Point: Selection of wrong candidates = Loss of time KPI Metri...
Read more
  HR Analytics - Day 1 Notes 📊 HR Analytics - Day 1 Ghaziabad, Mohan Nagar 💱 Currency Conversion Reference $1 Million = ₹8,000 Cr $5 Million = ₹40,000 Cr $50 Million = ₹40 Lakh Crore 📚 Key Terminology BPO Business Process Outsourcing GPU Graphics Processing Unit KRA Key Responsibility Area KPI Key Performance Indicator - Quality of work, helps che...
Read more
  Day 3 - HR Analytics Notes 📊 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 comp...
Read more