HR data analysis training 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. This entry-level training course offers a solid understanding of HR data analytics and through numerous examples provides you with analytical experience . Due to the hands-on approach of this course, you will be able to immediately apply your new skills and insights within your organization.

Using industry tools, such as Excel and Power BI, you will learn how to merge, clean and analyze large datasets. After analyzing the data and crunching the numbers with your team you will be translating findings into actionable insights and implementing a data-driven approach to HR. By determining the impact of people related decisions you’ll be able to support decisions and boost business performance.

This course is for anyone interested in understanding and analyzing HR data to make data-driven recommendations and decisions. This course is for you if you are in charge of HR analytics or just starting and want to start performing data analytics in HR departments.  This course is relevant and appropriate for HR professionals, HR Managers Data Scientists and Analyst.

1. An overview of HR analytics
   • Differences between HR metrics and HR analytics
   • Basic guidelines in HR analytics
   • Role of HR analytics within the organization
   • The purpose of HR data/metrics
   • Strategy and data driven decision making
   • People analytics and People science- new trends in human resource analytics
   • Agile HR analytics
2. Analytical Techniques and Data in HR
   • Determining measures and data requirements
   • Analitycial models and applications in HR – HR3P
   • HR reporting
   • Scenario planning
   • Statistical methods
   • Collecting data and determining data accuracy
   • Important variables and metrics of interest – KPIs
   • Linking HR to ROI – quantitative approach to workforce ROI
   • Analytical research methods
3. Analytical proces and interpretation of results
   • Choosing the right method to analyze data
   • The analytical process description
   • Tools for analysis
   • Technical considerations of analysis
   • Steps required to conduct analysis
4. Statistical analysis
   • Data types
   • HR Metrics
   • Correlation analysis
   • Regression analysis
   • Hypothesis testing
   • Predictive methods
5. Data analysis in Excel
   • Cleaning and merging data from different sources
   • Exploratory data analysis
   • Statistical methods in Excel – correlation, linear regression
   • Causality analysis
   • Scenario planning
   • Simulations in Excel
   • Data visualization
   • Trend analysis
   • Validating findings
   • Case study
6. Creating dashboards and analytical reports in Excel
   • Interpreting analytical results
   • Tables in Excel – basic powerful analytical tool
   • Advanced Excel functions
   • Presentation of results – analytical reporting
   • Building dashboards in Excel
   • Monitoring and tracking variables of interest with dashboards
7. Visualizations and reporting with Power BI
   • Data manipulations and transformations
   • Connecting to different data sources
   • Creating and Structuring HR data model
   • Visualizing HR data using Power BI dashboards
   • Publishing HR reports and dashboards