DDL Case Study · Analytics Engine

HeartBeat

Organizational growth intelligence — a daily two-question check-in that surfaces mood trends, energy drift, burnout risk, growth themes, and nudge effectiveness across every team in real time.

Problem

Annual engagement surveys arrive 12 months late. Managers detect burnout by turnover, not signal. Growth conversations happen quarterly at best. No system connects how people feel to what they need to grow — in real time.

Approach

DDL's check-in engine: every daily response becomes a fact row with employee, team, period, topic, and skill dimensions. Two questions. 45 seconds. The pattern recognition engine handles the rest — surfacing risk, themes, and resource nudges.

Deliverable

Org intelligence dashboard — mood/energy pulse chart, team heatmap with signal badges, burnout risk radar, growth theme clusters, nudge effectiveness tracking, daily check-in UX preview, and full star schema architecture.

♥ Organization Overview

Avg Mood

3.6

of 5.0 · steady

— no change vs 7d avg

Avg Energy

3.2

of 5.0

▼ 0.3 vs 7d avg

Participation

73%

137 of 187 today

▲ above 60% target

At-Risk Flag

12

3+ low-mood days in 14d

Nudges Delivered

94

today · 68% opened

Top Growth Theme

Stakeholder Comms

mentioned 23x this week

♥ 30-Day Mood Pulse

 Positive (3.5+) Neutral (2.5–3.4) Low (<2.5)

⚠ Mid-period dip correlates with Q1 planning sprint · recovered within 5 days

♥ Team Heartbeat — This Week

Team	Size	Mood	Energy	Δ 7d	Part.	Signal
Product	24	4.1	3.8	↑ 0.4	88%	Thriving
Engineering	42	3.6	3.4	— 0.0	76%	Stable
Design	12	3.8	3.5	↑ 0.2	83%	Healthy
Sales	28	3.4	3.0	↓ 0.3	71%	Watch
Customer Success	18	2.9	2.6	↓ 0.6	67%	At Risk
Support	22	2.4	2.1	↓ 0.8	59%	Critical
Marketing	16	3.5	3.2	— 0.1	75%	Stable
People Ops	8	4.0	3.9	↑ 0.3	100%	Thriving

⚠ Risk & Burnout Radar

!

Support — Critical: 10-day declining trend. Mood 2.4, energy 2.1. Participation dropping. 6 of 22 employees flagged at-risk. Top blocker: "ticket volume + unclear escalation"

!

Customer Success — Declining: Mood dropped 0.6 in 7 days. 4 of 18 flagged at-risk. Recurring theme: "handoffs from Sales are incomplete"

⚠

Sales — Watch: Energy declining, participation slipping. 3 employees mention "unclear quota changes" in free text. Correlated with recent comp plan update.

→

Cross-team signal: "process friction" mentioned by 18 employees across 5 teams this week. Highest density in CS + Support. Likely systemic, not team-specific.

🎯 Growth Focus — Top Themes

23Stakeholder communication

19Process documentation

17Prioritization

14Cross-team handoffs

12Product knowledge

11Client discovery

9Escalation handling

8Async communication

📚 Nudge Effectiveness

Stakeholder Comms Playbook78% opened

Correlated with +0.4 mood shift in recipients over 5 days

Escalation Tier 2 SOP72% opened

Support team — most requested doc. 3 employees saved it.

Sales-to-CS Handoff Template45% opened

Delivered to CS but low adoption — may need redesign or manager push

Q1 Prioritization Framework22% opened

Low engagement despite high topic mentions — content may not match need

Architecture · Star Schema

CREATE TABLE Fact_CheckIns (
  checkin_id  INT  PRIMARY KEY
  employee_id  INT  REFERENCES Dim_Employee
  team_id  INT  REFERENCES Dim_Team
  period_id  INT  REFERENCES Dim_Period
  topic_id  INT  REFERENCES Dim_Topic
  skill_id  INT  REFERENCES Dim_Skill
  mood_score  INT   -- 1-5
  energy_score  INT   -- 1-5
  growth_focus  TEXT   -- free text response
  nudge_delivered  BOOLEAN  
  nudge_opened  BOOLEAN  
  sentiment_class  VARCHAR(15)   -- positive | neutral | stressed | blocked
-- The daily two-question check-in IS the fact table
-- Every response = one row in Fact_CheckIns
-- Every nudge = a measurable outcome tied back to the row

HeartBeat Engine · v0.1 · Organizational Growth Intelligence · Built by DDL · 2026