Analytics

Is this the “Moneyball” moment for HR & Reward?

Is this the “Moneyball” moment for HR & Reward?

    The movie Moneyball tells the real-life story of how a new manager at baseball club Oakland Athletics, Billy Beane used analytics to make massive improvements in the performance and results. Guys with spreadsheets and maths degrees showed their approach...

Database normalisation: a solution for HR data quality issues

Database normalisation: a solution for HR data quality issues

Chronic data quality problems?      "What's wrong with our data?" or  "We've been through several data cleanses but still we are getting problems" or "We hired on a data car to fix this problem, but it still happens - what are we doing wrong?" I've heard it...

How to get better data quality in your HRIS

How to get better data quality in your HRIS

In almost every organisation I’ve worked with, data quality was a problem, and one that was hard for them to overcome. It doesn’t matter whether you’re using SAP, Workday, Oracle or something else – because every database needs data quality to be useful. Bad data...

Create a tracker for your job evaluation project

Create a tracker for your job evaluation project

Trackers are helpful in most projects   When you are reviewing a large number of jobs, you might have hundreds of distinct generic roles to evaluate and provide salary benchmarks for. Some will be at an early stage of the job evaluation and salary benchmarking...

Using IFERROR and VLOOKUP with 2 or more worksheets

Using IFERROR and VLOOKUP with 2 or more worksheets

  There are lots of occasions in Reward where you might want to use lookups in Excel across multiple sheets – for example to pull in data from a pay-for-performance matrix for salary or bonus calculations, for sales commission calculations across different...

10 Basic Excel formulae often useful in Reward

10 Basic Excel formulae often useful in Reward

  From time to time, I find articles or compare notes with other Excel trainers where talk turns to the question “what are your top 10 Excel formulae?” Reward people generally use Excel quite a lot, and in fact it’s not only Reward people, but any analyst that...

Some favourite metrics in HR

Some favourite metrics in HR

Are we measuring what's important?   “If you can’t measure it, you can’t manage it” might seem an absurd assertion, while “what gets measured gets managed” has become a quote attributed (rightly or wrongly) to Peter Drucker. Yet some say instead that “the...