HR & People Data and Analytics Fundamentals

A high level overview of the Basics sections, including outlining upcoming lectures on how to identify questions to ask, who HR. & People data is for and more

You'll finish this lecture with a better understanding of how to ask questions of your data - including the difference between exploratory and targeted questions.

This lecture covers some of the regulatory sensitivity around HR & People data. By the end you'll have a better understanding of how to handle sensitive information, and who to go to if you need help.

This lecture covers where HR & People data generally comes from, and by the end you'll understand some of the limitations this can place on your ability to analyze it.

Here you'll learn about the direct impact HR & People data can have on both the HR or People team, but also on the overall company it is created by.

This lecture covers the importance of data hygiene and the "gut check" - if something seems off about your data, it likely is!

Here you'll get hands-in in our sample data set and learn how to scrub data. This includes things like standardizing locations, identifying missing information and more.

This lecture wraps up our HR & People Data basics section.

Here you'll get a high-level overview of the different tools available to work with HR and People data.

Spreadsheets are an incredibly common tool in HR & People data. Here we'll cover a few of their advantages, and disadvantages.

You'll leave this lecture with a basic understanding of what Business Intelligence (BI) tools are.

You'll get a basic overview of what SQL (Structured Query Language) is, and what a Data Warehouse (DWH) is for. Both are common in larger companies and can handle vast amounts of data.

This lecture wraps up the HR & People Data Tools section.

A high-level overview of Google Sheets, including what this section covers, its menu items, the Explore feature and more.

A high-level overview of Microsoft Excel, including basic navigation.

The lectures covers the difference between Cell and Ranges, and also explains what an Absolute and Relative range are.

The lectures covers the difference between Cell and Ranges, and also explains what an Absolute and Relative range are.

AverageIf allows you to average the values in one column based on some criteria in another - for example averaging sales by region, or test scores by class.

AverageIf allows you to average the values in one column based on some criteria in another - for example averaging sales by region, or test scores by class.

CountIf allows you to count values based on some condition - for example counting the number of people in a specific office.

CountIf allows you to count values based on some condition - for example counting the number of people in a specific office.

CountIfs allows you to count values based on one or more conditions, for example counting the number of individuals in a specific department in a certain location.

CountIfs allows you to count values based on one or more conditions, for example counting the number of individuals in a specific department in a certain location.

Unique gives you a list of all the unique values from a range - for example showing you all the unique office locations. It differs from "Remove Duplicates" in that it is a live list and will update if the data changes.

Unique gives you a list of all the unique values from a range - for example showing you all the unique office locations. It differs from "Remove Duplicates" in that it is a live list and will update if the data changes.

Sum returns a sum total of the range(s) you indicate - for example summing total sales in table.

Sum returns a sum total of the range(s) you indicate - for example summing total sales in table. Sumif does the same, but lets you specify a criteria (like a specific department or location).

This lecture covers the basics of Pivot Tables, which allow you to quick (and fairly easily) aggregate data to use in analysis. They also reduce the risk of error as the system handles most of the heavy lifting and support additional features like drill down.

They are also great for helping non-analysts quickly explore data.

Get hands on with Pivot tables in Excel.

This lecture gets hands on a builds a pivot table using our sample data set.

This lecture outlines the other lectures in this section.

This lecture provides examples of some of general HR & People metrics that you'll get hands-on with.

Learn what some Headcount metrics are, their importance, and how to calculate them.

Learn how to calculate basic headcount metrics in Excel.

Learn about some Engagement metrics, why they're important, and how to calculate them.

Learn to calculate basic turnover metrics in Excel.

Learn about some Diversity metrics, why they're important, and how to calculate them.

Learn to calculate basic diversity metrics in Excel.

Learn about some Recruiting metrics, why they're important, and how to calculate them.

Learn to calculate basic Recruiting metrics in Excel.

Learn what a time series is, what it is useful for, and some of the basic requirements to build one.

Get hands-on building a time-series in Google Sheets. This will be a step-by-step process where you'll break down raw data into a time series to display turnover for the overall company and by individual departments.

This lecture wraps up our Calculating HR & People Metrics section.

This lecture outlines what you'll learn in the HR & People Data Partnerships section.

You'll learn the importance of relationships, as well as some tips for how to build them.

You'll learn the importance of finding common ground, and how to build buy-in for your HR & People data projects.

This lecture will show you how to help your team improve their use of HR & People metrics.

This lecture wraps up our HR & People Data Partnerships section.

This lecture introduces the Presenting HR & People Data section.

Here you'll learn about how to successfully navigate the sensitivity surrounding HR & People data.

You'll learn what an executive brief is, get a live example and learn how to create a good one.

Here you'll learn about some common mistakes made when presenting HR & People data and how to avoid them.

This lecture shows you the importance of telling a story with your information and making it more than just numbers.

This lecture wraps up the Presenting HR & People Data section.

This lecture wraps up the course!

Coupons for discounts on my other courses