Skill Guide

Data storytelling and employer brand KPI dashboard design

The practice of synthesizing recruitment, engagement, and retention data into a coherent narrative that drives strategic decisions, visualized through a purpose-built dashboard tracking Employer Brand (EB) health.

It transforms HR from a cost center into a strategic partner by directly linking talent initiatives to business outcomes like cost-per-hire, quality of hire, and offer acceptance rates. This capability enables proactive talent management, optimizing recruitment ROI and strengthening the organization's market position.

1 Careers

1 Categories

8.7 Avg Demand

25% Avg AI Risk

How to Learn Data storytelling and employer brand KPI dashboard design

1. **Data Literacy Fundamentals:** Understand core recruitment KPIs (Time-to-Fill, Cost-per-Hire, Source of Hire, Candidate NPS). Learn basic data hygiene (cleaning Excel/Sheets data). 2. **Visualization Principles:** Study the 'Grammar of Graphics' (data-ink ratio, chart selection for comparison vs. composition vs. trend). 3. **Narrative Structure:** Master the 'Situation-Complication-Resolution' (SCR) framework for presenting findings to stakeholders.

1. **Scenario: Quarterly Business Review (QBR) Presentation.** Move from reporting numbers to telling a story: 'Our cost-per-hire increased by 15% (Situation) because our primary sourcing channel, LinkedIn, saw a decline in qualified applicants (Complication). We have piloted a new sourcing tool on GitHub, showing a 20% lower cost-per-qualified-lead in trials (Resolution).' 2. **Method:** Use a dashboarding tool (Power BI/Tableau) to build a live dashboard connecting your Applicant Tracking System (ATS) data. 3. **Common Mistake:** Avoid 'Chartjunk.' Do not use 3D charts, excessive colors, or decorative elements that obscure the data's message.

1. **Strategic Alignment:** Design dashboards that correlate EB metrics with business outcomes. For example, map 'Employee Referral Rate' and 'Quality of Hire' (from performance reviews) against 'Time-to-Promotion' to demonstrate the long-term value of the referral program. 2. **Predictive Modeling:** Implement simple predictive models (e.g., attrition risk scores based on engagement survey data and manager tenure) to move from descriptive to prescriptive analytics. 3. **Executive Storytelling:** Craft a multi-layered narrative for the C-suite. The top layer is a single, impactful KPI (e.g., 'Net Talent Attraction Score'), supported by a drill-down dashboard that executives can explore independently. Mentor junior analysts on translating data into actionable insights, not just reports.

Practice Projects

Beginner

Project

Build a Static Recruitment Funnel Dashboard

Scenario

You are given a messy CSV file from an ATS with 12 months of candidate data (columns: Candidate ID, Source, Application Date, Stage Reached, Rejection Reason, Offer Accepted Y/N).

How to Execute

1. **Clean & Structure:** In Excel/Google Sheets, remove duplicates, standardize source names (e.g., 'Linkedin', 'LinkedIn' to 'LinkedIn'), and add a 'Month' column derived from 'Application Date'. 2. **Calculate Core KPIs:** Use pivot tables to calculate monthly Funnel Conversion Rates (Applied → Screened → Interviewed → Offered → Accepted) and Cost-per-Hire (assuming a fixed budget per source). 3. **Design & Visualize:** Use the 'Situation-Complication-Resolution' structure. The 'Situation' is the overall funnel view. The 'Complication' is a bar chart showing 'Top 3 Rejection Reasons by Stage'. The 'Resolution' is a line chart showing the 'Trend of Cost-per-Hire by Source'. 4. **Write the Narrative:** Add a text box above the charts: 'Our highest volume source (Job Boards) has the lowest offer acceptance rate (45%), indicating a candidate fit issue, while our highest cost-per-hire source (Agency) has the highest acceptance rate (90%). We recommend rebalancing sourcing spend.'

Intermediate

Case Study/Exercise

Diagnose a Silent Employer Brand Problem

Scenario

A fast-growing tech company has stable offer acceptance rates (85%) but a rising '90-day attrition rate' for new hires in engineering. Exit interviews cite 'misaligned expectations.'

How to Execute

1. **Hypothesis Generation:** The problem is not the offer, but the pre-hire narrative. Map the candidate journey: Job Description → Career Page → Interview Process → Offer Letter. 2. **Data Triangulation:** Cross-reference the '90-day attrition' data with the 'Source of Hire' and 'Interview Panel Composition'. Is attrition higher for candidates from certain sources or interviewed by specific managers? 3. **Root Cause Analysis (The 5 Whys):** Why are expectations misaligned? (Job descriptions overpromised projects). Why? (Written by hiring managers without HR review). Why? (No standard template or approval process). 4. **Build a Corrective Dashboard:** Create a new dashboard view. The primary KPI is 'Interview-to-Offer Conversion Rate by Hiring Manager' correlated with 'New Hire 90-Day Performance Score'. This makes the problem (and the responsible party) visible. The story is: 'To reduce costly early attrition, we must standardize the JD creation process and train interviewers on setting realistic expectations.'

Advanced

Project

Design an Integrated 'Talent Health' Command Center

Scenario

You are the Head of People Analytics. The CEO wants a single, real-time view of 'organizational talent health' that goes beyond hiring to include engagement, internal mobility, and succession risk.

How to Execute

1. **Architect the Data Model:** Integrate data from four systems: ATS (hiring), HRIS (headcount, tenure, promotions), Engagement Survey Platform (eNPS, sentiment), and Performance Management System (ratings, potential). Define a common 'Employee ID' key. 2. **Define the 'North Star' Metric:** Create a composite index: 'Talent Sustainability Score' = (eNPS * 0.3) + (Internal Mobility Rate * 0.25) + (High-Performer Retention Rate * 0.3) + (Succession Plan Coverage * 0.15). 3. **Build the Narrative Layers:** Layer 1: The North Star Score with a trend line. Layer 2: Drill-down into its four components. Layer 3: Actionable triggers. For example, if 'High-Performer Retention' dips, the dashboard auto-highlights the top 3 at-risk departments (based on manager effectiveness scores and engagement drop-offs) and links directly to the retention intervention playbook. 4. **Enable Proactive Governance:** Implement automated alerts for key thresholds (e.g., alert HRBP if a department's 'High-Performer Regrettable Attrition' exceeds 5% in a quarter).

Tools & Frameworks

Software & Platforms

Microsoft Power BI / TableauSQL (for data extraction & transformation)Advanced Excel / Google Sheets (Pivot Tables, XLOOKUP, Power Query)ATS/HRIS APIs (Greenhouse, Workday, BambooHR)

Use Power BI/Tableau for building interactive, live dashboards. SQL is non-negotiable for pulling and joining data from disparate systems. Excel is for ad-hoc analysis and prototyping. ATS APIs are critical for automating data feeds into your analytics layer.

Analytical & Storytelling Frameworks

Situation-Complication-Resolution (SCR)The 'Grammar of Graphics' (Wilkinson)STAR(S) Method (for behavioral questions)Root Cause Analysis (5 Whys, Fishbone Diagram)

SCR structures any business presentation. Grammar of Graphics principles ensure visualizations are clear and honest. STAR(S) is essential for structuring answers about past projects. Root Cause Analysis tools move you from symptom to solution.

KPI Libraries & Benchmarking

SHRM People Analytics MetricsLinkedIn Talent Insights Benchmark DataBersin by Deloitte's High-Impact Talent Analytics Framework

Use these to define your metrics library and benchmark your performance against industry peers. They provide the 'what to measure' so you can focus on the 'how' and 'why'.

Interview Questions

Answer Strategy

Test the candidate's ability to translate HR metrics into business impact for a non-HR stakeholder. Use the SCR framework. **Sample Answer:** 'The situation is that Marketing views EB as a vague concept. My first step is to ask what metrics they track for our consumer brand (e.g., NPS, conversion rates). I'd then frame our EB dashboard using the same language. The complication I'd highlight is our candidate drop-off rate in the final interview stage compared to our offer acceptance rate for referral hires. The resolution would be a dashboard correlating our EB marketing spend (employer brand campaigns) with the 'cost-per-qualified-applicant' and 'quality of hire' metrics, showing how targeted content directly improves pipeline efficiency and hire quality, mirroring their marketing funnel analysis.'

Answer Strategy

Tests analytical humility, critical thinking, and the courage to challenge data with qualitative insight. **Sample Answer:** 'Our dashboard showed our internship program had a 100% offer acceptance rate, which looked like a huge success (Situation). However, my gut, informed by casual conversations, suggested our interns felt isolated and were not getting meaningful work (Complication). I initiated a confidential 'stay interview' survey with open-ended questions. The data revealed a 40% dissatisfaction rate with mentorship, which our binary acceptance metric had completely masked (Resolution). I presented this nuanced story to leadership, leading to a structured mentorship program and a new 'Intern Experience Score' metric on our dashboard, which is now a leading indicator of future intern-to-full-time conversion.'