Uncover the hidden barriers to employee retainment and success in your organization, using the data resources you already have!
Bill Yost, People Analytics Technology Lead at Google, teaches this live online 6-week course.
Where better to sharpen your skills for a changing world than with Google People Analytics wayfinder Bill Yost? Experience leading an HR analytics project first-hand while learning how to source, analyze, and influence with data.
Don't let intimidation around big data hold you back in your career anymore. Discover simple but powerful ways to unlock value in any type of data — even data you didn't know you had!
Wouldn't it be great to go beyond subjective employee surveys and understand how to really support your people? This course teaches you how to help your workforce thrive using the same data-based decision making practices that power your business.
Start getting real-time insights into what motivates your people — working with the resources you already have.
Skip boring pre-recorded classes! Learn for the real-world as you investigate and solve a mock company's biggest workforce challenge.
Tap into data from unconventional sources to answer pressing HR questions. Discover what Bill's learned in ten years of successfully tracking down data from across business areas.
Build your influence with every audience. You'll practice on your own and in small groups to translate data into compelling, targeted presentations.
Start setting and meeting audacious targets for the business and your career. You'll learn how to validate your HR recommendations and confidently lead the charge in hiring, retention, and employee engagement.
Get acquainted with the manifold benefits of HR analytics for both employers and employees.
Assignment #01: Introducing the business problem
You've just been hired as an HR analyst for vacyoum, a developer of robot vacuums. vacyoum has manufacturing, software development, and standard business functions with ~1000 employees worldwide, but they struggle with attrition — particularly amongst their top talent.
Research the questions in Bill's Exploration worksheet to better understand vacyoum's business problem.
Discover essential data inputs and how they're used to bring value to human resources.
Assignment #02: Gathering data from "janky" sources
Part 1: The HR executive assistant sends you vacyoum's performance review and exit interview files. What are some analyses you can perform using the data provided in class to answer the business question? What further data or questions would you like clarity on?
Part 2: The data has five errors. Can you find them all? Create a report summarizing the data provided.
Convert raw data from rudimentary sources into foundations for insights.
Assignment #03: Creating data where none appears to exist
You learn that your company's HR system implementation wasn't deployed and they don’t have a central roster to give you. However, you do have access to transactional data on employee badge swipes, times, and IDs.
Combine this data with your existing data to produce a daily roster of employees. Be ready to explain assumptions and liberties you took to account for gaps in the data.
Bill shares his methods for gathering data where it doesn't exist.
Assignment #04: Gathering employee data
Gathering employee data
vacyoum's leadership wants to define their top talent as those who believe most strongly in the company’s vision. They need you to measure how employees perceive their role and the company.
Follow Bill's Data Collection Plan worksheet to define your path forward.
Learn how to use intersecting business metrics to create analysis.
Assignment #05: Working with recurring feeds and less-than-optimal data
Working with recurring feeds & less-than-optimal data
You get the good news that the company HR system has been deployed and employee acquisition/attrition data is being generated daily — but there's a catch. The data can only be exported in PDF, which makes analysis much harder. Luckily, the company has provided credentials for you to pull the data directly from their SQL Server instance.
Next, use Tableau and the data you’ve obtained thus far to start creating a reporting / analytics platform. Answer the following questions to guide your preparation.
Explore the breadth of analytical options that become available once you've established your data sets.
Assignment #06: Navigating the opinion-to-analytics pipeline
In a meeting, you overhear a VP say they believe the company's new training program is leading to increased loss of talent. Separately, you’ve just figured out how to access two very exciting data sources.
How can you use this data in your existing reporting platform to support your analyses? How would you approach addressing the VP’s theory of the relationship between the new training program and attrition?
Build this data into your reporting platform. Make sure the platform provides the appropriate level of flexibility for your business clients.
Learn how to test hypotheses for what course of action should be taken based on your data, using advanced statistics.
Assignment #07: Gathering novel data sources
You learn that another part of the HR function has been exploring whether or not increasing the amount of mentor meetings per year reduces employee attrition risk. Since this data can be useful for your work, you courteously request access to a .csv file of all mentor/mentee meetings by date.
When metrics, analytics, and insights are ready to share with leadership, what roles do you approach first to facilitate enthusiastic buy-in? What are the tools and techniques that can help you get your message across?
Assignment #08: Proving the value of monitoring analytics
vacyoum is super excited that you're finally cracking into HR Analytics. What leadership would really like now is to have a real-time view into the great metrics you're bringing to them.
+ Case study: How HR made customers happy
Work alongside Bill in real time to produce a holistic data view in Tableau Public. You'll learn how to keep your finger on the pulse of your organization with common HR data points, metrics, rates, and trends to monitor.
Assignment #09: Introducing novel analyses to the business
Part 1: Continue working in Tableau Public to finalize implementation of updates made in the workshop.
Part 2: Prepare a slide introducing leadership to one new metric not covered in class. Assume your audience has never seen the metric before. Add this new metric into your reporting platform.
Learn how to gather leadership buy-in for further analysis and investment in HR analytics.
Assignment #10: The intersection of actionable + insightful + sensitive data
The data owner has decided to give you access to one of the most sensitive datasets at the company, employee demographics. Complete Bill's Working with Sensitive Data worksheet to understand how to safely build this data into your reporting platform.
Simulate an urgent business inquiry that requires collaboration, data finesse, and beautiful visualizations to respond.
Assignment #11: The urgent business need always prevails
Work in groups of 3-4 to produce an HR solution to vacyoum's problem of high attrition.
Hear about industry disruptors and employment opportunities in the HR analytics space from a distinguished corporate leader.
Assignment #12: Finalizing your Tableau reporting platform
Part 1: Prepare your Tableau reporting platform for distribution to stakeholders and/or end users. Submit it to the class folder for final review by Bill.
Part 2: Imagine you will move on from the project in two weeks and need to leave behind notes that will inform the direction of the program for the next year. What do you say? What documentation should you leave behind so that future analysts can maintain your platform?