Visualizing HR Data Part 2: Using Google’s Cool Motion Chart

In part 1 of my experiment using motion charts for HR data visualization, I tested Trend Compass, which is technically a copy of the Hans Rosling data viz tool. (This is not the most sophisticated or interesting way to show data, but it’s sure fun to watch…)

This time I used the same data: sources of applicants and hires (all sample data) for 20 months, but used Google’s Motion Chart. And I have to say, in terms of ease of use, flexibility, and sheer visual beauty, Motion Chart wins. After I had the data set and a helpful link from the folks at Gapminder I was up and running in about 20 minutes.

I didn’t record audio on this one, but here’s a quick video of the chart in motion: (try it in full screen mode to see detail)

Now, Google lets you tap the Motion Chart from their API, or, it’s right in Google Docs as a widget. Here’s a link to a live published version of the same sheet I used so you can see how I did it.

http://spreadsheets.google.com/pub?key=t9Nub9K-kBQkV3-5FfhHoeg&single=true&gid=0&output=html

Try changing some of the variables for yourself to see how it works.  Mouse over the sources on the right hand side, nice highlighting feature there.

I also recommend hitting gapminder.org to see some really lovely trend data from across the world. I don’t know about you, but I’m having some data fun playing with this new toy…

About these ads

Jeremy Shapiro is an executive in HR at a leading financial services firm, working on talent analytics. Formerly a Senior Vice President of the Hodes iQ Talent Management Suite at Bernard Hodes Group and is a co-author of the HR metrics book Ultimate Performance. Jeremy has coached hundreds of companies in recruiting and HR technology solutions across industries and sizes. Jeremy is a frequent speaker and author on HR technology topics and HR Business Intelligence topics, such as SHRM, IHRIM, the Human Capital Institute, HR.com and more. He is a frequent contributor to articles and whitepapers on HR Business Intelligence. Jeremy holds a Masters of Science in Information Systems from NYU and a B.A in Economics from Rutgers University. Specific topics of research include HR metrics, talent management technology, and next generation recruiting technologies.

Posted in Uncategorized
One comment on “Visualizing HR Data Part 2: Using Google’s Cool Motion Chart
  1. David D'Angelo says:

    Very nice. I think we have arrived at
    “Chart 2.0″.

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

50% of Jeremy

Talent metrics and human capital analytics galore.                                                                        

Upcoming Presentations
Cornell ILR, Metrics that Matter: How HR Analytics Impact the Bottom Line, June 3-4, 2014 or November 13-14, New York, NY

HBR Webinar (Recording) - Competing on Talent Analytics November, 2011

Groups I’m Involved With
Follow

Get every new post delivered to your Inbox.

%d bloggers like this: