Welcome

Yuvijen · Excel · Power BI · Tableau

HR Metrics and Dashboards

A comprehensive, hands-on guide that bridges HR theory with practice — turning raw people data into insightful, decision-ready dashboards in Excel, Power BI and Tableau.

4
Modules, foundations to advanced
18
Topic-wise chapters
3 Tools
Excel, Power BI & Tableau
Hands-on
A practical exercise per chapter

What’s inside every chapter

The metric, defined

Each topic opens with what the metric measures, why it matters to HR, and how it ties back to organisational goals.

How it's calculated

Clear formulas and worked calculations — recruitment funnels, turnover and retention rates, training ROI, engagement scores and more.

Hands-on exercise

Every chapter ends with a build-it-yourself activity in Excel, Power BI or Tableau, assigned to fit the topic.

Dashboard design

Step-by-step guidance on visualising metrics — choosing the right chart, layout, slicers and filters for an interactive HR dashboard.

Key HR functions

Dedicated coverage of recruitment, performance, learning & development, retention, demographics, compensation and engagement.

From data to decisions

Move beyond reporting into predictive analytics — spotting high-risk turnover and making confident, data-driven HR decisions.

Browse the modules

Foundations · BI Tools
The Four-Module Path
Tools

How to use this book

Read a chapter top to bottom the first time: each opens by defining the metric and why it matters, shows how it is calculated, then walks you through building the dashboard that brings it to life. Don’t just read the hands-on exercises — open Excel, Power BI or Tableau and build them yourself, because that is where the skill sticks. New to the BI tools? Start with the Fundamentals of BI Tools section and its companion books. When you need a refresher, the Syllabus page is your map to every module and topic.

About the authors

Photo of Vijayakumar P

Vijayakumar P is an Educator & Data Analytics Professional with 8+ years in Analytics, AI and HR. UGC-JRF-NET in Management.

Read full profile ↗

Photo of Rani C

Rani C is an Educator & HR Business Intelligence Professional with 8+ years in HRM and HR Analytics. UGC-NET in Management.

Read full profile ↗

References

  • Microsoft Power BI Dashboards Step by Step. O’Connor, Errin. Amazon ↗
  • Tableau Your Data!. Chabot, Christian. O’Reilly ↗
  • Statistics for Management. Levin, Richard I., & Rubin, David S. Amazon ↗