People & Culture Data Analyst

• HR data analysis program focus on the data side of human resource management. Using appropriate techniques and tools your department will be able to provide decision makers with the insights to make better people decisions.

1- HR Metrics

• The importance of analyzing HR activities
• The role of data analysis in HR functions
• Analyzing recruitment metrics
• Analyzing employee relations metrics
• Analyzing compensation & benefits metrics
• Analyzing learning & development and performance management

2- Excel & Power BI

• Introduction to Self-Service BI Solutions
• Creating a Power BI Dashboard
• Using Excel as a Data Source for Power BI
• Shaping and Combining Data
• Create Relationships & Calculations

3- HR Statistics

• What is statistics
• Descriptive stat & statistical inference
• The nature of statistical data
• Listing numerical data
• Stem & leaf displays
• Frequency distributions
• Graphical presentations
• Measures of location (Mean- weighted mean- median- mode)
• Measures of variation (Range – variance – standard deviation)
• ANOVA
• Regression
• Correlation

• Understand the importance of data and analytical process for driving decisions
• Use Excel and Power BI to process, combine, clean and analyze HR data
• Calculate appropriate measures – KPIs and ROIs on HR activities
• Identify analytical tools & methods for interpreting, & presenting HR data & support HR decisions
• Use Power BI Desktop to create interactive data visualizations.
• Use HR Statistics to report information.

• Talent Acquisition Specialist, HR Specialist, HR Generalist, HR Supervisor, HR Manager, HR Data Analyst, HR Business Partners