Tableau for HR and people analytics
Headcount reported three different ways, and an attrition number that changes depending on who was asked.
People data is small, sensitive, and full of definitional traps. Headcount alone can be reported three defensible ways, and attrition changes meaning depending on whether you count leavers against opening headcount, closing headcount or an average.
The technical difficulty is not volume. It is point-in-time reporting, safe aggregation on small groups, and making sure a manager cannot see a team that is not theirs.
What you will actually be asked to build
Dashboards
- Headcount and attrition trending
- Recruitment funnel conversion
- Diversity representation over time
- Engagement survey analysis
Tableau skills they depend on
- Point-in-time headcount with LOD
- Funnel and Sankey-style views
- Careful aggregation on small groups
- Anonymity thresholds and row-level security
Where to learn it
3 courses that teach these skills
None of these is branded as a hr and people course. They are the courses that teach the techniques the work above actually needs. Reviewed August 2026.
-
Advanced Tableau: LOD Calculations
Coursera · Single focused course
One topic, treated properly: identifying data grain, troubleshooting LOD errors, and applying FIXED, INCLUDE and EXCLUDE to business problems rather than toy data.
Best for Fixing the single concept that blocks most intermediate analysts.Watch out Narrow by design. It is a repair job on one skill, not an advanced curriculum. -
Our pickData Analyst in Tableau
DataCamp · Career track, 9 courses
Nine courses that move from connecting data sources through calculated fields and LOD expressions to presentation-ready dashboards, mapped against the Tableau Certified Data Analyst exam domains.
Best for The clearest single route from 'I can build a chart' to 'I can sit the Data Analyst exam'.Watch out Exam-aligned is not the same as exam preparation. You still want timed practice questions before you book. -
Tableau Prep I (TTP101)
Trailhead Academy · Instructor-led class
Tableau's official Prep training. Prep is the part of the stack most self-taught analysts skip, and it is usually the reason their workbooks are slow and their joins are wrong.
Best for Analysts who keep fixing data shape inside Tableau instead of before it.Watch out Priced as corporate training. Hard to justify personally unless an employer is paying.
HR and people Tableau questions
What Tableau skills matter for people analytics?
Level of detail expressions for point-in-time headcount, funnel and stage-conversion views for recruitment, careful aggregation thresholds so small teams are not individually identifiable, and row-level security so managers see only their own reports.
Learn row-level security before you publish anything. In people analytics it is a confidentiality control, not a convenience feature.
How do you calculate headcount at a point in time in Tableau?
You need a record of each employee's start and end dates, and a date scaffold to compare against. A FIXED level of detail expression then counts employees whose start date is on or before the reference date and whose end date is after it or null.
Counting rows in a snapshot export will give you a different answer every time the export runs, which is why headcount so often disagrees between reports.
Is Tableau suitable for confidential HR data?
Yes, with Tableau Server or Tableau Cloud and row-level security configured properly. It is not suitable on Tableau Public, which publishes everything you save.
Anyone learning on Tableau Public should practise on synthetic or published data sets, never on real employee records.