4 min read

The One Model Difference #1: We're Your HR Data Cleansing Service

The One Model difference that really sets us apart is our ability to extract all your messy data and clean it into a standardized data catalog. Let's dive deeper.

One Model delivers people analytics infrastructure. We accelerate every phase of your analytics roadmap. The later phases of that roadmap are pretty fun and exciting. Machine learning. Data Augmentation. Etc. Believe me, you’re going to hear a ton about that from us this year.

But not today. Today we’re going to back up for a minute and pay homage to an absolutely wonderful thing about One Model:  We will help you clean up your data mess.

Messy Data? Don't distress.

Josh Bersin used this phrasing in his talk at the People Analytics and the Future of Work conference. From my notes at PAFOW on Feb 2, 2018:

You know there are huge opportunities to act like a business person in people analytics. In the talk right before Josh’s, Jonathan Ferrar reminded us that you get $13.01 back for every dollar you spend on analytics.

But you have to get your house in order first. And that’s going to be hard. Our product engineering team at One Model has spent their careers figuring out how to pull data from HR systems and organizing it all into effective data models that are ready for analytics.

If your team prefers, your company can spend years and massive budgets figuring all this out... Or, you can take advantage of One Model.

When you sign up with One Model:

1) We take on responsibility for helping you extract all the data from your HR systems and related tools. 

2) We connect and refine all that data into a standard data catalog that produces answers your team will actually trust. Learn what happened to Synk when they finally had trust.

Big data cleansing starts with extracting the data from all your HR and related tools.

We will extract all the data you want from all the systems you want through integrations and custom reports. It’s part of the deal. And it’s a big deal!

For some perspective, check out this Workday resource document and figure out how you’ll extract your workers’ FTE allocation from it. Or if Oracle is your thing, you can go to our HRIS comparison blog and read about how much fun our founder, Chris, had figuring out how to get a suitable analytics data set out of Fusion. In fact, my coworker Josh is pulling some Oracle data as we speak and let me tell you, I’m pretty happy to be working on this post instead.

Luckily for you, you don’t need to reinvent this wheel! Call us up. We’ll happily talk through the particulars of your systems and the relevant work we’ve already done. The documentation for these systems (for the most part) is out there, so it’s not that this is a bunch of classified top-secret stuff. We simply have a lot of accumulated experience getting data out of HR systems and have built proprietary processes to ensure you get the most data from your tools.

In many cases, like Workday, for example, we can activate the custom integration we’ve already built and have your core data set populated in One Model.  If you go down that road on your own, it’ll take you 2 - 3 days just to arrange the internal meeting to talk about how to make a plan to get all this data extracted. We spent over 10,000 development hours working on our Workday extraction process alone. And once you do get the data out, there’s still a mountain of work ahead of you. Which brings us to...

The next step is refining your extracted data into a standardized data catalog.

How do you define and govern the standard ways you are going to analyze your people data? Let’s take a simple example, like termination rate. The numerator part of this is actually pretty straightforward. You count up the number of terminations. Beyond that, you will want to map termination codes into voluntary and involuntary, exclude (or include) contractors, etc. Let’s just assume all this goes fine.

Now what about the bottom part? You had, say 10 terminations in the given period of time, so your termination rate is... relative to what headcount? The starting headcount for that period? The ending headcount? The average headcount?

How about the daily average headcount? Go with this for two reasons. 1) It’s the most accurate. You won’t unintentionally under or overstate termination rate, giving you a more accurate basis of comparison over time and the ability to correctly pro-rate values across departments. See here for details. And 2) If you are thinking of doing this in-house, it’ll be fun to tell your team that they need to work out how to deliver daily average headcounts for all the different dimensions and cuts to meet your cleaning data requirements.

If you really want to, you can fight the daily average headcount battle and many others internally. But we haven’t even gotten to time modeling yet, which is so much fun it may get its own upcoming One Model Difference post. Or the unspeakable joy you will find managing organizational structure changes, see #10.

On the other hand, One Model comes complete with a standard metrics catalog of over 590 metrics, along with the data processing logic and system integrations necessary to collect that data and calculate those metrics. You can create, tweak, and define your metrics any way you want to. But you do not have to start from scratch.

If you think about it. This One Model difference makes all the difference. Ultimately, you simply have to clean up your messy data. We recognize that. We’ve been through it before. And we make it part of the deal.

Our customers choose One Model because we're raising the standard and setting the pace for people analytics. If you are spending time gathering and maintaining data, then the yardstick for what good people analytics is going to accelerate away from you.  If you want to catch up, book a demo below and we can talk.

Tell us you want to meet.


About One Model:

One Model helps thriving companies make consistently great talent decisions at all levels of the organization. Large and rapidly-growing companies rely on our People Data Cloud™ people analytics platform because it takes all of the heavy lifting out of data extraction, cleansing, modeling, analytics, and reporting of enterprise workforce data. One Model pioneered people data orchestration, innovative visualizations, and flexible predictive models. HR and business teams trust its accurate reports and analyses. Data scientists, engineers, and people analytics professionals love the reduced technical burden. People Data Cloud is a uniquely transparent platform that drives ethical decisions and ensures the highest levels of security and privacy that human resource management demands.

Why is a Tech Startup Blogging about Spring Cleaning?

Why is a Tech Startup Blogging about Spring Cleaning?

How did Spring cleaning become a thing, and why do we do it? It’s officially March. Daylight savings has us up an hour earlier, the weather’s...

Read More
How You're Wasting 75% of the Power of Employee Surveys

How You're Wasting 75% of the Power of Employee Surveys

The employee survey still is perhaps the most ubiquitous tool in use for HR to give their employees a voice. It may be changing and being disrupted...

Read More
Steam Powered Data Science for HR

Steam Powered Data Science for HR

We’re back with another installment of our One Model Difference series. On the heels of our One AI announcement, how could we not take this...

Read More