Want to master Excel and create HR reports that always get read?

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...

The HR Analytics Foundation Programme provides you with a self-study, practical course that ensures you will:

  • Avoid overwhelm

    Thanks to my proven step-by-step process to producing impactful reporting that always adds value.

  • Identify requirements

    Create key HR analytics and make it so much easier for your managers to take action

  • Get to work

    Put excel to work like never before as you create and automate HR metrics, make an HR Dashboard, master pivot tables and a whole host of other key tools and formulas.

Anyone can give you a tutorial on how to create the perfect HR metrics

What YOU need is a proven strategy that guides you through everything you need from beginning to end. What YOU need is guidance from a seasoned HR professional who understands every part of the process…

Pleased to meet you!

I want you to be able to invest in your training with peace of mind; so here's a little more about me:

* HR professional with nearly 35 years’ experience in HR, learning and development.

* 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…

Image of Lorraine Hunt inviting you to email her

Is the HR Analytics Foundation Programme right for me?

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?

You’re busy trying to juggle all the things, so I will get straight to the point and introduce you to the 3 key problems HR professionals come to me with:

  • Problem #1

    You are too busy with Operational to take time to learn something new.

    If you always do what you have always done, you’ll always get the same results.

    Get off the treadmill!

  • Problem #2

    You are overwhelmed thinking about having to learn numbers, think you aren’t techie enough, and that you don’t know the business.

    This is a step-by-step programme that allows you to learn in a structured way at your own pace.

    You can do this!

  • Problem #3

    You don’t know where to start and have no idea how to turn things around.

    Don’t worry, I hear this one all the time… I teach in simple-to-follow blocks so you can build from the ground up with ease.

    Don’t give up!

Course curriculum

  • 1

    Introduction to the course

    • A message from Lorraine Hunt

    • How to use the dashboard (Walkthrough)

    • Before we begin... pre-course survey

  • 2

    STAGE ONE: INTRODUCTION

    • 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

  • 3

    Stage two: IMPACT

    • 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

  • 4

    Stage three: STRATEGY

    • 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

  • 5

    Stage four: DATA SETS

    • 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

  • 6

    Stage five: FRAMEWORK

    • 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

  • 7

    BUILDING YOUR DASHBOARD

    • Basic excel formulas (skip this lesson if you already know basic excel)

    • Step by step guide to building a simple HR Dashboard

  • 8

    Congratulations!

    • You've finished the course!

    • Before you go...

    • Special bonus