HR Data Analysis with Excel and Power BI

Introduction 

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. 

Who is this training for? 

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. 

What will I learn? 

• Understand the importance of data and analytical process for driving organizational decisions 
• Use Excel and PowerBI to process, combine, clean and analyze HR data 
• Calculate appropriate measures – KPIs and ROIs on HR activities 
• Identify analytical tools and methods for interpreting, and presenting HR data and support HR decisions 
• Have detailed knowledge of every step in the analytics process and be able to manage the HR analytics process from front to back 
• Know the most effective way to visualize and present data and translate outcomes into actionable insights 
• Generate effective reports and dashboards to communicate data-driven insights to organizational management 
• Coach and support other HR professionals in data analysis process 

Course outline 

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 
   • Analytical 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 process 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