Power BI HR Analytics — Complete Workshop Kit

What you get:

A complete, self-paced Power BI workshop that takes you from zero to a published, portfolio-ready HR Analytics dashboard. No prior Power BI experience required.

Inside the kit (instant download):

1. Interactive HTML build guide (245 KB, 2,800+ lines) — step-by-step instructions with 60+ copy-paste formulas, checkboxes to track progress, "What this does" explanations for every formula, and a print-to-PDF button for offline use.
2. HR Data Sample – Innovation Hub.xlsx (3.5 MB) — a realistic, production-quality dataset with 2,000 employees across 9 sheets and 40,000+ data rows covering recruitment, performance, training, exit surveys, salary history, budgets, and engagement.
3. Power BI architecture explained — how VertiPaq, Power Query, the DAX engine, and the data model work under the hood.
4. 25+ DAX measures — COUNTROWS, CALCULATE, DIVIDE, AVERAGE, MEDIAN, VAR/RETURN, eNPS — each with a copy button and a plain-English explanation of what it calculates and why HR teams use it.
5. 6 dashboard pages — Executive Overview, Recruitment Pipeline, Performance & Talent (with 9-box grid), L&D, Attrition Analysis, Workforce Planning — each with visual-by-visual drag-and-drop instructions.
6. PL-300 certification roadmap — exam domains mapped to the workshop, 5 official Microsoft Learn paths with links, free practice assessment link, and a 5-step certification progression from PL-900 to PL-600.
7. Career toolkit — LinkedIn post template, CV entry template, case study structure, resume ATS keyword list, tips for presenting to business executives, and a 6-platform social media sharing guide.
8. DAX & Power Query function reference — 17 functions explained with syntax and where you use them.
9. HR domain scope table — 12 HR functions mapped to dashboard types, KPIs, data sources, and Power BI features.

Who this is for:

College students learning Power BI for the first time → HR professionals wanting to add data analytics skills → Career changers preparing for Data Analyst or BI Developer roles → Anyone preparing for the PL-300 Microsoft certification → Trainers and instructors who want a ready-made workshop curriculum

What you will build:

A complete Hire-to-Retire HR Analytics Dashboard for a fictional startup called Innovation Hub — the same kind of dashboard used at companies like Google, Deloitte, and McKinsey for workforce planning.

Requirements:

Windows PC with Power BI Desktop installed (free download) → No coding experience needed — every formula is copy-paste ready → 4–6 hours to complete the full workshop

Created by Sathiya Seelan | HR Advisory Consultant & Power BI Instructor