HR Analytics Foundation Programme: Self Study
An introduction to HR Analytics, including a step by step guide on how to build your first dashboard using Excel
This unique training program allows you to accelerate your career like never before. Together, we'll make learning HR analytics using Excel look easy and give you everything you need to:
Boost your reputation at work
Save priceless time and effort
Enable key decisions to be made
The key is to know how to create HR reports that get read and result in action. All you need is the right training program to show you how...
Anyone can give you a tutorial on how to create the perfect HR metrics
I want you to be able to invest in your training with peace of mind; so here's a little more about me:
* Jargon-Free Zone: I’ll add the context and deliver the practical exercises that really reinforce your learning.
* All supporting materials you need, including an HR dashboard you can download and use without delay.
* Videos are quick, easy-to-follow and always engaging. Why settle for anything else when it’s time to level-up?
Now you know who I am, it’s time you asked yourself a key question…
Answered yes to any of those questions on the right? Then you've found the perfect course to move to the next level!
Is creating an HR dashboard or updating your current HR dashboard on your to-do list?
Tired of generic courses that leave you feeling frustrated and stuck on how to move forwards?
Want to accelerate your career by demonstrating you’re the go-to person for meaningful reports that get things done?
A message from Lorraine Hunt
How to use the dashboard (Walkthrough)
Before we begin... pre-course survey
1.1: An introduction to HR analytics
ACTIVITY: HR Analytics self assessment
1.2: What HR analytics are not
1.3: Why it is important to measure
ACTIVITY: Assess why HR analytics are important
1.4: Benefits of HR analytics
1.5: HR analytics challenges and limitations
ACTIVITY: Challenges and limitations workbook - Answer questions before next video
1.6: When to use HR analytics
1.7: HR Analytics models and approaches
1.8: Static versus agile reporting
1.9: Types of analytics
END OF MODULE ACTIVITY REMINDER
Stage two: Impact release date
2.1: Aligning your analytics to business goals, objectives and pain points
CHECK: Business goals
ACTIVITY: One question quiz
2.2: Understanding a business goal or challenge - asking why
2.3 Defining your audience
2.4 Identifying audience challenges and translating them into analytics questions
2.5 Deciding your analytics priorities
3.1 Mindset and skillset
3.2 Culture and communication
3.3 Analytics framework and business strategy
3.4 Corporate objectives, diagnostic analytics and predictive analytics
3.5 HR people initiatives - 2 case studies
3.6 Return on investment
Return on investment examples
3.7 Developing a business case
3.8 HR Value chain
4.1 What are data sets?
4.2 Data management, discovery and collection
4.3 How to prepare your data
4.4 Identifying relevant data for your requirements
4.5 Basics of statistical analysis
4.6 Correlation between data
5.1 Formulating metrics that get read: 5 step analytics framework
5.2 Types of HR reporting
5.3 Baseline analytics
5.4 Executing your HR analytics strategy - Concerns and ethics
5.5 Overview of tools and technology
5.6 Data visualisation - Designing your dashboard
5.7 Storytelling
5.8 Case studies
Basic excel formulas (skip this lesson if you already know basic excel)
Step by step guide to building a simple HR Dashboard
You've finished the course!
Before you go...
Special bonus