In this exercise, we’re going to use Google Sheets and Google Data Studio to visualize employee tenure and commute length.
Data Studio is a free collaborative data visualization product and toolset to create charts and reports from multiple data sources. It’s Google’s initial response to other well-established analytics platforms like Microsoft, Tableau and QlikView.
Let’s get started:
First, we opened Google Data Studio to start a new report. The access page will look something like this:
Your next step will be to start a new report.
Once inside your new report, go ahead and click “Create New Data Source” and connect your data source and then click “Add to Report”.
Once connected, you will see a blank canvas. It looks something like this:
Click the “combo chart” icon and then take your cursor and click in the empty canvas and then drag the cursor from upper left to lower right to create a large box. After you let go, you will see your data visualized.
Building reports with Google Data Studio is as simple as opening and setting up a new Word Doc inside the Google Drive environment. Your raw chart (for tenure/commute) should look something like this:
You can improve the look and feel of the chart by accessing “Combo chart Properties” (located in the image above on the right side). With a little design modification, your chart can look something like this:
Based on our data, are we able to say with 100% certainty that long commutes result in better employee tenure? No. Does our data prove beyond any doubt that people with longer commutes are less engaged than those with shorter ones? No. Does this mean that we should ever only hire people with short commutes? No. But there does seem to be some kind of correlation between length of commute and employee tenure.
There are lots of research reports that show employees with shorter commutes stay committed to the company longer – and that a longer commute can even become a negative attribute for some employees. There are also numerous other articles, blog posts and data points that show those with a commute longer than 45 minutes are less satisfied with their lives and report higher anxiety than those who don’t have a long commute each day. And while we’re not able to prove that there is a direct/strong correlation between commute and employee engagement, there does seem to be at least a weak correlation between the two. It seems, at least in this situation, that the longer the commute the shorter the tenure.
Like this tutorial? You can use the same design approach to build up charts around interests such as Career Site Audience, Candidate Acquisition, Employee Behavior, New Hire Conversion, and more.
ABOUT THE AUTHOR
Christopher Mengel is the founder of TalentSum LLC, a strategic talent acquisition consultancy and best practices implementation firm. Some of the world’s most notable companies partner with TalentSum to activate a strong employer brand, attract more people who fit, improve engagement and experiences, and deliver high-performing cultures.
[button href=”https://twitter.com/chrisrmengel” color=”blue”]Twitter[/button] OR [button href=”https://www.linkedin.com/in/christophermengel/” color=”teal”]LinkedIn[/button]
- Subscribe to Get Blog Content in your Inbox
- Join our 2018 Talent Acquisition Research Study
- Download our Spring 2018 Overview PDF
- Learn about TalentSum Pro and our Services