Remember how easy it was for Jed Clampett of Beverly Hillbillies fame? One day he was shootin' at some food and up through the ground came some bubblin' crude. It was just sitting there, waiting for him.
Take a look in front of you. There's a precious commodity just sitting there, waiting for you. As the promo I received in my email today claimed, you're sitting on a goldmine of information. Last I checked, that goldmine's sitting smack dab on your property.
I'm talking about employee data of course. And the reason I'm sending out this reminder is because so many of the companies that I've worked with do not mine their data. When I ask them for data on their employees, they give me their best guess. Or they reference an executive presentation with data that turns out to be more than 12 months old.
Of course, just like any data, employee data is only valuable if you're going to use it to make decisions. So why leave it buried, when you could be using it to make more strategic decisions every day about your company's most important asset?
Data on these four topics could be immensely valuable in your daily discussions:
- Distribution of employees by defining variables like age, sex, length of service, employment status, bonus eligibility and so on. Also by variables that communicate compensation insights. Each company has its own sensitivities, but I think about measures like: Percentage of employees below midpoint by five years of service; percentage eligible for bonus who did not receive one; percentage of those exceeding expectations who keep that rating three years in a row. You get my drift.
- Variance of employees across the organization. Most companies are not small enough or cohesive enough to be studied as a single entity. There is a lot of insight to be gotten from identifying variations across departments and/or divisions. Are there big differences in age or length of service? If there are, do you know the reason?
- Fact-based evaluation on vital staffing questions. Do you know where all your risks are? Are your strengths holding up? This type of analysis should be the basis of an ongoing strategic discussion with leadership, based on data that is refreshed regularly.
- Trends will teach you how much you can rely on your data and how quickly change is ocurring. A 2012 snapshot of salaries may end up being misleading if the story changes when you add 2010 and 2011.
Why not set up some programs that mine your HRIS data on a daily or weekly basis, so you can have fresh data for every discussion? IBM claims that the last decade has delivered us so much information, analytics will be the next "big thing."
Don't wait to have others tell HR that the time has come. Dig into your goldmine now!
Margaret O'Hanlon is founder and principal of re:Think Consulting. Join Margaret and her Compensation Cafe colleagues, Ann Bares and Dan Walter, at the WorldatWork 2012 Total Rewards Conference for a chat on "Everything We Do (in Compensation) Is Communications." Margaret brings deep expertise in total rewards communications and change management to the dialog at the Café. Before founding re:Think Consulting, she was a Principal in Total Rewards Communications and Change Management with Towers Perrin. Margaret is a member of the Board of Directors of the International Association of Business Communicators (IABC), Pacific Plains Region. She earned her M.S. and Ed.S. in Instructional Technology at Indiana University. Creative writing is one of her outside passions, along with Masters Swimming.
Very timely post! Many HR pros have neither the time or the skill set to truly mine their data.
But, many have access to internal experts (often in finance, or marketing at very big companies) who ae great at this type of work.
With a little work removing/replace key fields like ID number and names, they can have the mining done by others and everyone can reap the fortunes.
Posted by: Dan Walter | 05/09/2012 at 08:43 AM
Yes, indeed, Margaret, you are on target. Econometric and demographic analysis can tell you a lot that you never realized. I once analyzed the historical pay progression records of a major East Coast utility who had a 100-year record of pay by seniority alone in all ranks and levels except top management. Before I rolled out a high-visibility brand-new revolutionary "pay for performance" system, I quietly informed the CEO that my review proved they ALWAYS had a merit pay program, but it was covert and informal. Plum assignments, reclassifications and promotional progressions had been manipulated to substitute for formal P4P systems. That recognition of an informal historical tradition of merit pay was very helpful to the transition to an open formal program.
Posted by: E. James (Jim) Brennan | 05/09/2012 at 11:21 AM
Yep, Dan. I encourage everyone to silence the "we can't get it done with everything else on our plate" mantra. Admit it guys, sometimes that's HR speak for, "I don't feel like it." As Dan pointed out, there are many ways to get this done and it's likely that people in your company who deal with databases who are the ones to do it. Start with the data that is fundamental to understanding employees. Set up a program. The hard work is then finished. Immediate and ongoing pay off for HR and, I believe, your career as a strategic advisor. Just check out how much insight Jim provided the CEO.
Posted by: Margaret O'Hanlon | 05/09/2012 at 11:24 AM