Legsonshow Linda Bareham Video 39 High Quality Page

| Timestamp | Topic | Core Insight | |-----------|-------|--------------| | 00:00 – 05:30 | Intro & Guest Background | Linda’s journey from a data‑science graduate to a people‑analytics pioneer; why “people are data points with feelings.” | | 05:31 – 12:45 | Defining People Analytics | Distinguishes descriptive, diagnostic, predictive, and prescriptive analytics. Emphasises the “People‑First” lens that avoids reductionist metrics. | | 12:46 – 22:10 | The “Four‑Quadrant Talent Dashboard” | A reusable template (Performance, Potential, Engagement, Inclusion) that can be built in Excel, PowerBI, or Looker. Demonstrates a live build using a fictional SaaS company. | | 22:11 – 30:55 | DEI Metrics That Matter | Moves beyond head‑count ratios to “Inclusion Indexes” (psychological safety, belonging, voice). Shows how to weight each index for a Composite DEI Score. | | 30:56 – 38:20 | Predictive Turnover Modeling | Walk‑through of a logistic‑regression model that predicts voluntary attrition with 78 % accuracy; key variables: manager‑team NPS, internal mobility rate, and career‑path clarity. | | 38:21 – 45:05 | Data Ethics & Governance | Linda’s “Four‑P” rule (Purpose, Privacy, Permission, Provenance). Practical checklist for HR leaders to audit their analytics pipelines. | | 45:06 – 52:40 | Case Study: Re‑designing a Hiring Funnel | Real‑world example from Bunzl: reducing time‑to‑fill by 33 % while increasing under‑represented hires by 21 % through structured interview scoring and bias‑adjusted AI screening. | | 52:41 – 58:55 | Career Advice for Aspiring People‑Analytics Professionals | 5‑step roadmap: (1) Learn SQL & a statistical language, (2) Get HR fundamentals, (3) Build a portfolio project, (4) Network in HR tech meetups, (5) Secure a “data‑partner” mentor. | | 58:56 – 01:04:30 | Future‑of‑Work Trends | • Rise of skill‑based talent marketplaces
• Hybrid‑work productivity metrics (focus‑time vs. meeting‑time)
• AI‑augmented people managers – ethical guardrails. | | 01:04:31 – 01:12:00 | Rapid‑Fire Q&A | Lightning‑round on favorite books (Thinking, Fast and Slow), tools (Tableau, Snowflake), and personal habits (daily 15‑minute “data‑journal”). |

CDS = (0.4 × Representation Index) + (0.3 × Inclusion Index) + (0.2 × Equity Index) + (0.1 × Opportunity Index) legsonshow linda bareham video 39 high quality

Practical tip: Normalize each sub‑index to a 0‑100 scale before weighting. Use Monte‑Carlo simulation to test how changes in one component affect the overall CDS over a 12‑month horizon. | Timestamp | Topic | Core Insight |

| Resource | Type | Link (shortened) | |----------|------|------------------| | People Analytics Lab – Dashboard Templates | Downloadable Excel/PowerBI files | bit.ly/pal‑dashboards | | DEI Inclusion Index Survey | 12‑question validated questionnaire | bit.ly/inclusion‑index | | Predictive Attrition Notebook | Python notebook on GitHub | github.com/lbareham/attrition‑model | | Linda’s Recommended Reading | Books & articles | Thinking, Fast and Slow – Daniel Kahneman; Work Rules! – Laszlo Bock; The Power of People – Linda Bareham (forthcoming) | | Future‑of‑Work Webinar (Oct 2024) | Recorded live session (relevant to episode) | youtu.be/FXt9kKxVZyU | CDS = (0