Skip to main content
Phase ext-people-analytics 4 weeks 25 of 32

People Analytics

People AnalyticsData-Driven HR
Sign in to track your progress and take assessments

Learning Activities

Test your understanding and reinforce your learning

Resources (3)

📖 ★★★
Work Rules!: Insights from Inside Google That Will Transform How You Live and Lead 11h

Laszlo Bock

📖 ★★★
Nine Lies About Work: A Freethinking Leader's Guide to the Real World 6h SK

Marcus Buckingham, Ashley Goodall

🎓 ★★☆
People Analytics 12h

University of Pennsylvania (Coursera)

Extension: People Analytics

“Without data, you’re just another person with an opinion.” - W. Edwards Deming

Why This Extension?

HR is becoming increasingly data-driven. People analytics transforms gut feelings into evidence-based decisions. Whether you’re in HR or managing people, understanding how to measure and improve human capital is essential.

Prerequisites: Phase 3B (People Operations)

Week 1: Foundations of People Analytics

Core Concepts

People Analytics: Using data to understand and improve human capital decisions. Also called HR analytics, workforce analytics, or talent analytics.

The Analytics Maturity Model: Most organizations are still at descriptive analytics (what happened). The goal is predictive (what will happen) and prescriptive (what should we do).

Data-Driven HR: Moving from “we think” to “we know” - using evidence rather than intuition for people decisions.

This Week’s Reading

📖 The Power of People by Guenole, Ferrar & Feinzig (Chapters 1-4)

The Analytics Maturity Model

LevelTypeQuestionExample
1DescriptiveWhat happened?Turnover was 18% last year
2DiagnosticWhy did it happen?Turnover higher in new hires, specific departments
3PredictiveWhat will happen?Based on patterns, these employees are flight risks
4PrescriptiveWhat should we do?Retention interventions for at-risk employees

Key People Metrics

CategoryMetrics
HeadcountTotal employees, FTE, contractor ratio
MovementTurnover rate, retention rate, internal mobility
RecruitmentTime-to-fill, cost-per-hire, offer acceptance rate
EngagementeNPS, engagement score, pulse survey results
PerformanceHigh performer ratio, ratings distribution
DevelopmentTraining hours, promotion rate, succession pipeline

Reflection Questions

  1. What people data does your organization currently track?
  2. What decisions are made based on intuition that could be data-informed?
  3. Where is your organization on the analytics maturity model?

Week 2: Measurement & Analysis

Core Concepts

Turnover Analysis: Not all turnover is equal. Regrettable vs. non-regrettable, voluntary vs. involuntary. Understanding patterns is key.

Engagement Analytics: Measuring engagement beyond the annual survey. Pulse surveys, sentiment analysis, behavioral indicators.

Performance Analytics: Understanding what drives high performance, not just measuring outcomes.

This Week’s Reading

📖 The Power of People by Guenole, Ferrar & Feinzig (Chapters 5-8)

Turnover Analysis Framework

DimensionQuestions
WhoHigh performers? New hires? Diverse talent?
WhenFirst 90 days? 1-2 years? After promotion/no promotion?
WhereSpecific teams? Managers? Locations? Functions?
WhyExit interview themes? Engagement correlation?

Calculating Key Metrics

MetricFormulaBenchmark
Turnover Rate(Separations / Avg Headcount) × 10010-15% (varies by industry)
Regrettable Turnover(High Performer Separations / Total) × 100Ideally < 5%
eNPS% Promoters - % Detractors> 10 is good, > 30 is excellent
Time-to-FillDays from req opened to offer accepted30-45 days typical

Application Exercise

Create a turnover analysis for your organization:

  1. What’s your overall turnover rate?
  2. Break it down by tenure, department, manager
  3. What patterns emerge?
  4. What hypotheses would you test?

Week 3: Predictive Analytics

Core Concepts

Flight Risk Modeling: Using patterns to predict which employees are likely to leave. Early warning enables intervention.

Talent Prediction: Predicting success in roles based on attributes. Moving beyond gut-feel hiring.

Statistical Thinking: Understanding correlation vs. causation, significance, and the limits of prediction.

This Week’s Reading

📖 Predictive HR Analytics by Edwards & Edwards (Selected chapters)

Flight Risk Indicators

CategorySignals
EngagementDeclining survey scores, reduced participation
PerformanceRecent decline, no recent promotion
ActivityProfile updates, reduced system usage
DemographicsTenure sweet spot (1-3 years), life events
EnvironmentNew manager, reorg, peer departures

The Predictive Process

1. Define the outcome to predict (turnover, performance)
2. Identify potential predictors (data available)
3. Build a model using historical data
4. Validate the model on new data
5. Deploy and monitor
6. Iterate and improve

Caution: Ethics & Privacy

ConcernConsideration
PrivacyWhat data is it appropriate to use?
BiasDoes the model perpetuate historical inequities?
TransparencyCan we explain why someone is flagged?
AgencyDoes this help people or surveil them?

Week 4: Implementation & Impact

Core Concepts

Storytelling with Data: Analytics is useless if it doesn’t drive action. Translation and communication are as important as analysis.

The Analytics Roadmap: Building capability over time. Start small, prove value, expand scope.

Change Management for Analytics: Getting buy-in from skeptical leaders and building trust in data.

This Week’s Reading

📖 The HR Scorecard by Becker, Huselid & Ulrich (Selected chapters)

Google re:Work Case Study

Google’s People Analytics has delivered breakthrough insights:

ProjectInsightImpact
Project OxygenWhat makes a great manager? 8 behaviorsManagement training, performance improvement
Project AristotleWhat makes teams effective? Psychological safetyTeam development, norms setting
Hiring ResearchStructured interviews > unstructuredInterview process redesign

Building Your Analytics Practice

PhaseFocusActivities
FoundationData infrastructureClean data, basic reporting, metrics definitions
DescriptiveWhat’s happeningDashboards, regular reporting, trend analysis
DiagnosticWhy it’s happeningSegmentation, correlation analysis
PredictiveWhat will happenModeling, forecasting
PrescriptiveWhat to doRecommendations, experiments

Capstone: People Analytics Project

Design a people analytics initiative:

  1. Business Problem: What question needs answering?
  2. Data Requirements: What data do you need?
  3. Analysis Approach: How will you analyze it?
  4. Communication Plan: How will you share insights?
  5. Expected Impact: What decisions will improve?

Key Frameworks

FrameworkSourceApplication
Analytics Maturity ModelThe Power of PeopleAssessing capability
Seven PillarsThe Power of PeopleBuilding analytics function
HR ScorecardHR ScorecardMeasuring HR impact
Flight Risk ModelPredictive HR AnalyticsRetention targeting

Resources

Books

Free Resources

Courses

AI Learning Integration

Analytics Problem Design Prompt

Help me design a people analytics project.

My organization has these challenges:
[describe 1-2 people challenges, e.g., high turnover, hiring quality, engagement issues]

Walk me through designing an analytics approach:
1. What specific question should we answer?
2. What data would we need?
3. What analysis method would work?
4. How would we measure success?
5. What are potential pitfalls?

Data Interpretation Prompt

Help me interpret some people analytics data.

Here's what we found:
- Turnover is 22% overall
- Turnover for employees with tenure < 1 year is 35%
- Turnover for employees whose manager has < 6 months experience is 40%
- Engagement scores dropped 8 points in department X
- High performers have 12% lower turnover than average

Ask me questions to help me:
1. Understand what's really happening
2. Identify root causes
3. Develop hypotheses to test
4. Propose interventions

Phase Assessment

Complete the following to demonstrate people analytics competency:

  1. Quiz: People Analytics Concepts (30%)
  2. Case Study: Analytics Challenge (70%)
    • Analyze workforce data
    • Identify insights and patterns
    • Recommend evidence-based interventions
AI-Powered Learning
🤖

Use with Any AI Assistant

Copy these prompts into Claude, ChatGPT, Gemini, or NotebookLM for personalized Socratic tutoring. No account needed - bring your own AI.

🎓

Socratic Tutor

I'm studying People Analytics (Phase EXT-PEOPLE-ANALYTICS of my MBA program). Act as a Socratic tut...

View full prompt
I'm studying People Analytics (Phase EXT-PEOPLE-ANALYTICS of my MBA program).

Act as a Socratic tutor - don't give me direct answers. Instead, ask me questions to help me discover insights about these concepts: People Analytics, Data-Driven HR.

Start by asking what I already know about one of these topics, then guide me deeper with follow-up questions. Challenge my assumptions when appropriate.

After each of my responses, either:
1. Ask a deeper follow-up question
2. Point out a gap in my reasoning
3. Connect my answer to another concept

Let's begin.
📝

Concept Quiz

Quiz me on People Analytics. Ask 10 questions covering: People Analytics, Data-Driven HR. Rules: - ...

View full prompt
Quiz me on People Analytics. Ask 10 questions covering: People Analytics, Data-Driven HR.

Rules:
- Mix question types (multiple choice, short answer, scenario-based)
- Start easier, get progressively harder
- After each answer, tell me if I'm right or wrong and explain why
- Keep a running score
- At the end, summarize what I know well vs. need to review

Ask the first question now.
🔧

Framework Application

Help me apply the main frameworks from this phase to a real situation in my life or work. First, as...

View full prompt
Help me apply the main frameworks from this phase to a real situation in my life or work.

First, ask me to describe a recent challenge or decision I faced.

Then guide me through analyzing it using these frameworks:
- Which framework applies best?
- What would each framework reveal about the situation?
- What would I do differently knowing this?

Don't lecture - ask questions that help me discover the insights myself.
💼

Case Discussion

I want to practice case analysis for People Analytics. Give me a short business scenario (2-3 parag...

View full prompt
I want to practice case analysis for People Analytics.

Give me a short business scenario (2-3 paragraphs) involving People Analytics, Data-Driven HR.

Then ask me:
1. What's the core problem?
2. Which frameworks from People Analytics apply?
3. What biases might cloud judgment here?
4. What would you recommend?

After each answer, push back on my reasoning before moving to the next question.
👶

Explain Like I'm 5

I'm studying People Analytics and need to understand these concepts deeply: People Analytics, Data-D...

View full prompt
I'm studying People Analytics and need to understand these concepts deeply: People Analytics, Data-Driven HR.

For each concept, ask me to explain it in simple terms (as if to a child).

If my explanation is unclear or wrong, don't correct me directly. Instead:
1. Ask clarifying questions
2. Give me a scenario that tests my understanding
3. Help me refine my explanation

The Feynman technique says if you can't explain it simply, you don't understand it well enough.

Open AI Assistant

Tip: NotebookLM is great for uploading books and getting AI summaries.