Professional HR Analyst with Power BI

Introduction to HR Analytics

• Fundamentals of HR
• Strategic Role of HR
• People Analytics - Basics
• Basics of Statistics
• Framework for Problem Solving - Define Problem, Collect Data, Build the Model, evaluate and Critique the Model, Present Results and Benefits, Deploy Model
• Critical Stages of Talent Life Cycle
• Case Study - HR Decision Making: Issue Identification and Problem Solving

HR Practices and Benchmarking

• Understanding Important HR Metrics tracked across the Overall Employee Journey
• HR Valuations
• Benchmarking
• Dashboarding of KPIs (Tableau, Excel)
• Performance and Goal Setting
• Providing Performance Feedback

Workforce Planning and Talent Sourcing Analytics

• Key Factors in Selection that Determine Quality of Hire
• Predicting Performance
• Measures to Track - Predictive Analysis
• Acquisition effectiveness
• Employee Training and Development Analytics

Talent Acquisition & Development Analytics

• Key Factors in Selection that Determine Quality of Hire
• Predicting Performance
• Measures to Track - Predictive Analysis
• Acquisition effectiveness
• Employee Training and Development Analytics

Induction and Culture Fit - Value Congruence

• Understanding Organizational Culture; Types of Cultures
• Socialization Process; Stages of Onboarding
• Create an Onboarding Predictive Model
• Value Congruence

Talent Engagement Analytics

• Importance of Employee Engagement
• Major Drivers of Employee Engagement
• Employee Engagement Surveys
• Variations in Employee Engagement across Days
• Employee Engagement Levels in Teams

Collaboration Analytics - Building Effective Teams

• What is Collaboration Importance of Collaboration
• Analysing Collaboration
• Organizational Network Analysis
• Intervening in Organizational Networks

Talent Analytics - Performance, Potential and Rewards

• Jobs, Roles and Competencies
• Performance vs Potential - Key Decision Dilemmas
• Rewards - Key Considerations

Talent Retention Analytics

• Why do Employees leave Organizations
• Different Talent Retention approaches/strategies
• Measures to Track

Employee Wellness - Health and Safety

• What is Employee Wellness Why care about Employee Wellness
• Employee Wellness Program Best Practices
• Using Predictive Analytics to Optimize Employee Wellness

Understanding Concepts of Excel

MS Excel Advance concepts

Advance Data Sorting

Restoring data to the original format

Advance Functions, filters in Excel

Lookup Functions

Pivot table

MIS Reporting & Dashboard

SQL Server Fundamentals

SQL Server 2019 Database Design

SQL Tables in MS SQL Server

Data Validation and Constraints

View and Row Data Security

Indexes and Query tuning

Stored Procedures and Benefits

User-defined functions and Usage

Triggers, cursors, memory limitations

Cursors and Memory Limitation

Transactions Management

Placement Guide

Introduction to Power BI

Power BI Desktop and Data Transformation

Data Analysis Expressions (DAX)

Data Visualization

Power BI Service

Connectivity Modes

Power BI Report Server

R & Python in Power BI

Advanced Analytics in Power BI