HR Analytics

Increase the probability of successful HR outcomes by using the most effective tools, techniques, and best practices for preparing and communicating HR data and making data-driven decisions. Throughout this course, you will learn how to leverage HR analytics to add value to your organization and which regulations and reporting requirements are most useful and relevant to your position. By applying the Analytics Process Model and utilizing Microsoft Excel, you’ll be ready to organize, analyze, and present HR data.

Learning Objectives

• Identify each phase of the HR Analytics Process Model (APM) and its purpose
• Describe best practices using HR analytics to support data-driven decision making
• Identify HR benchmarks and metrics relevant to agency mission and goals
• Analyze workforce and talent data using Excel to identify trends and other actionable performance information
• Give a short briefing to present analysis results

Course Topics

HR Analytics and the Analytics Process Model

• Exercise: Decision-Making Process
• Overview of HR Analytics
• Exercise: How Do We Make Decisions?
• The Analytics Process Model (APM) and Its Phases
• Human Resources Value Proposition
• HR Analytics in the Workplace and the Human Capital Framework (HCF)
• Exercise: Demonstrating the Analytics Process Model

Excel Quantitative Techniques

• Key Systems of Record for HR Data
• Software Tools
• Metrics, Benchmarks, and Other Indicators
• Using Excel for HR Analytics
• Excel Visualization
• Excel Analytic Techniques

HR Regulations and Reporting Requirements

• HR Laws, Policies, Procedures, and Guidelines
• Key Regulations and Reporting Requirements
• Connecting Missions or Goals to HR Benchmarks and Metrics

Effectively Presenting HR Data

• Assessing Your Audience
• Crafting the Message
• Exercise: Presenting Analysis Results