Skip to content

Data. Make it so.

March 6, 2013

Data winsFor the past few hours I’ve been at the bottom of a spreadsheet under 45,192 rows of data. I started with a spreadsheet of all customers trained to date by Kronos since 2010. That data wasn’t pristine, so I dropped by our Enterprise Data Warehouse (EDW) to build a query to find the correct industry missing in 1,526 customer records. Then I joined the 2 databases using Microsoft Access. Finally, using Excel again, a pivot table revealed:

We train a lot of customers.

butts in seats

The cool thing about data is that it’s precise. Yeah, our education team trained 40,036 students during the past 3 calendar years on our workforce management solutions. I know, it’s not cool “big data,” but even that has its limits. It’s just data, but the numbers are real, and they’re fabulous.

4 Comments leave one →
  1. Sarah T permalink
    March 6, 2013 3:46 pm

    That’s a bunch of people!

    Like

  2. Prashanth permalink
    March 12, 2013 12:20 am

    Awesome!

    Like

  3. April 9, 2015 9:16 am

    Data cannot use contractions. This picture should read: “I am detecting much win in this sector.”

    Like

Trackbacks

  1. Why Kronos? The training experience you expect! | Working Smarter Cafe

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: