HR & People Data and Analytics Fundamentals
Learn the basics of HR data analytics | Make Better Decisions | Hands on with Excel and Sheets
Lo que serás capaz de hacer
If you're interested in getting a better understanding of what HR (Human Resource) or People data is, how it can by analyzed, and used, and how it can help you drive impact, then this course is for you. I designed this course specifically for individuals just getting started on a Human Resources or People team, or for individuals who are interested in learning the basics of HR or People data and analytics. No prior HR experience is necessary, but basic knowledge of Google Sheets or Excel will be very helpful. This course is a great source for anyone interested in learning more about HR and People data, including: Human Resource / People Generalists Human Resource People Specialists Human Resources Business Partners (HRBPs) People Managers Executives and more! We'll cover the many places HR and People data can come from, including some common challenges (such as abbreviations and nicknames). This course also explores how to partner with other teams to improve how HR and People data is collected - something that will make your work as a HR or People data analyst more satisfying and increase the impact you will have on your team. You'll also get hands on and learn how some basic HR and People metrics are derived, including things like headcount, engagement, diversity, and recruiting metrics . We'll get hands on in Google Sheets and Microsoft Excel to learn how to calculate various metrics and use other features of those tools. We certainly won't get into every HR and People metric, but by the end of the course you'll be able to use fundamental metrics to help your organization better understand its most important asset - its people. In this course you will be exposed to some core skills needed to understand HR data, including: Where HR and People data comes from What HR and People data can be used for How common metrics, such as turnover, are calculated How to avoid common “gotchas” in HR and People data How to present HR and People data to leadership Please join me in this course and start using data to positively influence your organization! REVIEWS "I am really very happy that I chose this course. The timing, content, depth and the way the trainer explains the topics make it easy to understand and engaging. I can highly recommend it!" "I am looking at transitioning into human resources management so I needed to learn the basics and be able to handle entry level positions. I am very happy for the completion of this course as it has given another heads up concerning Headcounts, turnovers and some key formulas that are used in the HR space. Thanks UDEMY" "This experience was simply incredible; it helped me understand the basics of people's data and how I will be able to use them in my daily tasks."
- Explore the basics of HR data & people analytics and what makes it unique
- Familiarize yourself with basic HR analytics tools and what they are used for
- Conduct fundamental HR & people analytics activities, such as data cleaning
- Perform basic HR analytics using mock data
- Identify teams to partner with to improve how your organization uses HR data
- Present HR data clearly and concisely for maximum impact
Temario
UNIDAD 1 - Introduction · 6 leccionesUNIDAD 1 - Introduction
UNIDAD 1 - Introduction
- Welcome & Course Overview
- How to Use Udemy
- Why HR & People Data Matters
- Activity: Calculating Headcount in Google Sheets
- Activity : Calculating Headcount in Microsoft Excel
- Introduce Yourself!
UNIDAD 2 - HR & People Data Basics · 9 leccionesUNIDAD 2 - HR & People Data Basics
UNIDAD 2 - HR & People Data Basics
- Intro to HR & People Data Basics
- Identifying Data Questions to Ask
- Regulatory Hurdles
- Understanding Your Data's Origins & Limitations
- How HR &People Data Drives Impact & The Perception of HR & People Teams
- Data Hygiene: Passing the Gut Check
- Data Hygiene Hands-On
- Wrap-Up: HR & People Data Basics
- Data Basics Discussion
UNIDAD 3 - HR Data Tools · 5 leccionesUNIDAD 3 - HR Data Tools
UNIDAD 3 - HR Data Tools
- Intro to HR & People Data Tools
- Spreadsheets
- Business Intelligence (BI) Tools
- SQL & Data Warehouses
- Wrap-Up: HR & People Data Tools
UNIDAD 4 - Google Sheets and Microsoft Excel Basics · 23 leccionesUNIDAD 4 - Google Sheets and Microsoft Excel Basics
UNIDAD 4 - Google Sheets and Microsoft Excel Basics
- Introduction to Google Sheets
- Introduction to Excel
- Google Sheets Basics - Cell, Ranges, Absolute and Relative Ranges
- Excel Basics - Cells, Ranges, Absolute and Relative Ranges
- Ranges Quiz
- Google Sheets - The Averageif Function
- Excel - The Averageif Function
- AverageIf Quiz
- Google Sheets - The Countif Function
- Excel - The Countif Function
- CountIf Quiz
- Google Sheets - The Countifs Function
- Excel - The Countifs Function
- CountIfs Quiz
- Google Sheets - The Unique Function
- Excel - The Unique Function
- Unique Quiz
- Google Sheets - The Sum Function
- Excel - The Sum and Sumif Functions
- Sum Quiz
- Google Sheets - Pivot Tables Basics
- Excel - Pivot Table Basics
- Google Sheets - Hands On : Pivot Tables
UNIDAD 5 - Calculating HR & People Metrics · 17 leccionesUNIDAD 5 - Calculating HR & People Metrics
UNIDAD 5 - Calculating HR & People Metrics
- Intro to Calculating HR & People Metrics
- General HR & People Metrics
- Google Sheets - Calculating Headcount Metrics
- Excel - Calculating Headcount Metrics
- Exercise: Calculate Headcount Metrics
- Google Sheets - Calculating Engagement Metrics
- Excel - Calculating Engagement Metrics
- Exercise: Calculate Engagement Metrics
- Google Sheets - Calculating Diversity Metrics
- Excel - Calculating Diversity Metrics
- Exercise: Calculate Diversity Metrics
- Google Sheets - Calculating Recruiting Metrics
- Excel - Calculating Recruiting Metrics
- Exercise: Calculate Recruiting Metrics
- Google Sheets - Time Series Basics
- Google Sheets - Hands On : Time Series
- Wrap-Up: Calculating HR & People Metrics
UNIDAD 6 - HR Data& People Partnerships · 6 leccionesUNIDAD 6 - HR Data& People Partnerships
UNIDAD 6 - HR Data& People Partnerships
- Intro to HR & People Data Partnerships
- Building Relationships
- Common Ground & Buy-In
- Improving Use & Utilization of Metrics
- Wrap-Up: HR & People Data Partnerships
- Partnership Chat
UNIDAD 7 - Presenting HR & People Data · 8 leccionesUNIDAD 7 - Presenting HR & People Data
UNIDAD 7 - Presenting HR & People Data
- Intro to Presenting HR & People Data
- Data Sensitivity
- Executive Brief
- Common Mistakes
- How to Tell a Story
- Presenting HR & People Data
- Wrap-Up: Presenting HR & People Data
- Presentation Help
UNIDAD 8 - Conclusion · 1 leccionesUNIDAD 8 - Conclusion
UNIDAD 8 - Conclusion
- Thank you!
UNIDAD 9 - Bonus Section · 1 leccionesUNIDAD 9 - Bonus Section
UNIDAD 9 - Bonus Section
- Discount coupons on my other courses
Tu certificado lo emite la SEP, no solo una plataforma
Al demostrar la competencia recibes un certificado emitido por la Secretaría de Educación Pública a través del Gobierno del Estado de México: un documento oficial que puedes presentar con confianza ante cualquier empleador o institución.
Tu certificado con INEC
- Lo emite la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México
- Documento oficial con folio verificable en línea
- Lo otorga la Universidad Tecnológica Fidel Velázquez
Otras plataformas en línea
- Constancia privada emitida por la misma plataforma
- Solo acredita horas cursadas o asistencia
- Sin respaldo de una autoridad educativa
Tu itinerario, de la inscripción al certificado
- 1
Inscripción con pago único
Pagas $2,800 MXN una sola vez y entras de inmediato al curso.
- 2
Estudias a tu ritmo
9 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.
- 3
Cuestionarios por unidad
8 cuestionarios para comprobar lo aprendido.
- 4
Certificado
Emitido por la SEP a través del Gobierno del Estado de México, con folio verificable.
Un certificado oficial de la SEP
- Emitido por la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México. No es una constancia privada: es un documento oficial, y ese respaldo marca la diferencia frente a otras plataformas en línea.
- Contenido impartido por Robert Hean.
- Folio y QR verificables para compartirlo con quien te contrate.
Empieza hoy, a tu ritmo
Un solo pago y acceso inmediato al curso completo durante 12 meses.
- 9 unidades · 76 lecciones · 45 h
- 12 meses de acceso
- 8 cuestionarios de evaluación
- Certificado emitido por la SEP (Gob. del Estado de México) con folio verificable
Sobre tu inscripción
¿Cómo es el pago?
Un solo pago de $2,800 MXN. No hay mensualidades ni cargos recurrentes.
¿Cuánto tiempo tengo acceso?
12 meses desde tu inscripción, 24/7, para avanzar a tu ritmo.
¿Quién imparte el contenido?
El curso es impartido por Robert Hean; INEC gestiona tu inscripción, evaluación y certificado.
¿Qué pasa cuando vence mi acceso?
Puedes renovar tu cuenta tú mismo desde la plataforma, sin trámites ni esperas.


