Each skill is a few short lessons, then practice. You rate yourself at the start and again at the end.
Core to the job
Chapter 2
People analytics
Calculate the staff leaving rate so others can check it
What you'll learn
Metric definition
People data join
Attrition rate
Actionable finding
Practice
Build an Attrition Dashboard from Open Workforce Data20 min
Chapter 2
SQL and dashboards
Write queries that join tables and build a dashboard
What you'll learn
Join keys
Chart for question
Distribution shape
Signal and noise
Practice
Write Three HR Queries in Plain SQL15 min
Build an Attrition Dashboard and Test Whether the Gap Is Statistically Real45 min
Chapter 5
HR systems
List a new hire's records and spot staff data errors
What you'll learn
Employee record
Downstream change
Standard report
Payroll reconciliation
Audit trail
Practice
Audit 20 employee records for data hygiene30 min
Chapter 5
Data privacy
Spot privacy and bias risks, and drop needless data
What you'll learn
Data minimisation
Consent and access
Group performance gaps
Small group risk
Early risk escalation
Sensitive data inventory
Retention schedule
Subject access request
Practice
Audit one HR file for data risks20 min
Chapter 6
Survey design
Rewrite weak survey questions neutrally, then run a short survey
What you'll learn
Neutral questions
Balanced rating scale
Representative group
Comment themes
Practice
Spot What's Wrong with These Five Survey Questions15 min
Design a Targeted Feedback Survey for a Service20 min
Analyse a Set of Exit Survey Responses and Surface the Real Reason People Left25 min
4 more in the plan
Critical thinkingSpot a weak assumption and ask where numbers come fromCh 7
What you'll learn
The hidden assumption
Argue the other side
The base rate
Fact vs inference
Wanting it to be true
Practice
Spot the Weak Link in an Argument10 min
CommunicationRewrite an update for two different readers, cutting extra linesCh 8
What you'll learn
Lead with the point
Match detail to the reader
Said versus heard
Specific feedback
Practice
Write a Six-Line Delay Message10 min
Working with othersContribute to group work, ask for help and credit teammatesCh 8
What you'll learn
Early team friction
Clear ownership
Challenge ideas, not people
Lead or follow
Problem solvingTest each possible cause of a problem instead of guessingCh 8
What you'll learn
Problem vs symptom
Clean problem splits
Root cause
Deciding under uncertainty
Practice
Separate the Problem from the Symptom10 min
Your plan
Chapter by chapter.
12 chapters, in this order. Chapter 1 is free.
1~1 wk
See what people analytics lead work involves
StartFree
2~1 wk
Turn workforce data into trusted decisions
Skills
31–2 wks
Build an attrition or diversity dashboard
Project
4~1 wk
Talk to a working people data analyst
People
5~1 wk
Keep people data accurate and safe
Skills
6~1 wk
Design surveys and read the answers well
Skills
7~1 wk
Test claims before you build on them
Skills
8~1 wk
Explain problems and solve them together
Skills
91–2 wks
Capstone: build a hiring funnel dashboard
Project
10~1 wk
Answer the questions interviewers ask
Interview
11~1 wk
Decide how you will get in
Decide
12on your timeline
Send your first applications
Apply
The job
What a People Analytics Lead does
Turns staff data into clear answers leaders can act on, such as why people quit and how to keep them. Builds the trusted data foundation that the human resources (HR) team relies on.
The work
Build attrition models that predict which staff may quit soon
Design headcount, hiring, and diversity dashboards leaders check each week
Pull and clean people data from the human resources information system (HRIS)
Analyse staff surveys to find why people stay or leave
Define shared metrics so every team counts headcount the same way
Turn findings into plain reports that managers actually use
Check data for privacy, fairness, and errors before sharing it
A typical day
Refresh dashboards and check overnight data for gaps or errors
Meet HR leaders to frame a question, like rising team turnover
Pull data, clean it, and test a model for the answer
Write a short report and walk managers through what it means
Plan the next survey and review questions with the team
Fix a broken data feed between the HRIS and the dashboard
Tools
HR systems (HRIS): Workday, SuccessFactors, BambooHRBusiness intelligence (BI): Power BI, Tableau, LookerSpreadsheets: Excel, Google SheetsQuery and code: SQL, Python, RSurveys: Qualtrics, Culture Amp, Microsoft FormsData modelling: dbt (a tool for shaping data tables)
Ways in
There is more than one route.
Ways to study
Bachelor degree: statistics, data science, economics, or psychology
Bachelor degree: human resources or business with strong data courses
Short courses: SQL, dashboards, and people analytics basics
Certificate: business intelligence or data analysis foundations
Workplace training: HR analytics rotations and on-the-job mentoring
How people get their first job
Apply for HR analyst, data analyst, or people operations roles
Do an internship that touches HR data, surveys, or reporting
Build a portfolio dashboard from open workforce or census data
Earn a free SQL and dashboard certificate, then practise weekly
Volunteer to analyse member or survey data for a club or nonprofit
How long does it take to become a people analytics lead with Welica?
The plan is 12 chapters, 3 months at 15 to 30 minutes a day. You can go faster or slower; the plan moves with you.
Do I need a degree?
Not always. Common routes are bachelor degree: statistics, data science, economics, or psychology, bachelor degree: human resources or business with strong data courses, short courses: SQL, dashboards, and people analytics basics, certificate: business intelligence or data analysis foundations, or workplace training: HR analytics rotations and on-the-job mentoring.
What is free?
Chapter 1, See what people analytics lead work involves, is free for good. Premium unlocks the rest of the plan.