Power BI HR Analytics Dashboard: Workforce Intelligence Guide

People are an organization's largest cost and most valuable asset, yet most HR departments make critical decisions --- hiring, compensation, restructuring, benefits --- using intuition, anecdote, and lagging spreadsheet reports. Power BI transforms HR data into workforce intelligence by visualizing headcount dynamics, attrition patterns, diversity progress, compensation equity, recruitment efficiency, and engagement trends in a single interactive platform.

The shift from HR reporting (what happened) to people analytics (why it happened and what to do about it) is the difference between an HR function that reacts to problems and one that prevents them. When you can see that engineering attrition spikes in Q1 every year, that a specific manager's team has 3x the turnover rate of peers, or that female employees leave at a higher rate than male employees at the 3-year tenure mark, you can intervene before the next departure.

This guide covers the complete architecture of an HR analytics dashboard in Power BI, including the data model, essential DAX measures, visualization design for each analytics domain, and implementation considerations for sensitive workforce data.

---

Data Model for HR Analytics

Core Tables

HR analytics data models differ from financial or sales models because workforce data has both stock (point-in-time counts) and flow (event-based changes) characteristics.

Employee dimension (DimEmployee). The central dimension table containing current employee attributes. Key columns include EmployeeID, FullName, Department, Team, JobTitle, JobLevel (Individual Contributor, Manager, Director, VP, C-Suite), Manager (EmployeeID of direct manager), HireDate, TerminationDate (null for active employees), Location, Country, Gender, Ethnicity, AgeGroup, TenureBand (less than 1 year, 1--3 years, 3--5 years, 5--10 years, 10+ years), EmploymentType (Full-time, Part-time, Contractor), IsActive (boolean), BaseSalary, TotalCompensation, CompaRatio (salary divided by market midpoint), and PerformanceRating (most recent).

Headcount snapshot fact table (FactHeadcountSnapshot). Monthly snapshots of headcount by department, location, and demographic attributes. Each row represents the headcount at the end of a month. Columns include SnapshotDate, Department, Location, Gender, Ethnicity, ActiveCount, and FTECount. Snapshots enable accurate historical trend analysis because the employee dimension only reflects the current state.

Event fact table (FactHREvent). Records every significant HR event. Columns include EventID, EmployeeID, EventDate, EventType (Hire, Termination, Promotion, Transfer, Salary Change, Leave of Absence), FromValue (e.g., previous department, previous salary), ToValue (e.g., new department, new salary), and Reason (resignation reason, promotion reason, transfer reason).

Recruitment fact table (FactRecruitment). Tracks the hiring pipeline from job posting through offer acceptance. Columns include RequisitionID, PostingDate, Department, JobTitle, Source (job board, referral, agency, careers page), ApplicationDate, CandidateName, StageID (Applied, Phone Screen, Interview, Offer, Accepted, Rejected, Withdrawn), StageDate, HireDate, and CostIncurred.

Survey fact table (FactSurvey). Employee engagement and satisfaction survey responses. Columns include SurveyID, EmployeeID, SurveyDate, QuestionCategory (Engagement, Satisfaction, Manager, Growth, Culture), Score (1--5 or 1--10), and IsAnonymous.

Date dimension (DimDate). Standard date table shared across all fact tables with fiscal calendar support.

---

Headcount Trends

Active Headcount Measures

Active Headcount =
CALCULATE(
    COUNTROWS(DimEmployee),
    DimEmployee[IsActive] = TRUE()
)

Headcount End of Period =
CALCULATE(
    MAX(FactHeadcountSnapshot[ActiveCount]),
    FILTER(
        FactHeadcountSnapshot,
        FactHeadcountSnapshot[SnapshotDate] = MAX(DimDate[Date])
    )
)

FTE Count =
CALCULATE(
    SUM(FactHeadcountSnapshot[FTECount]),
    FILTER(
        FactHeadcountSnapshot,
        FactHeadcountSnapshot[SnapshotDate] = MAX(DimDate[Date])
    )
)

New Hires (Period) =
CALCULATE(
    COUNTROWS(FactHREvent),
    FactHREvent[EventType] = "Hire"
)

Terminations (Period) =
CALCULATE(
    COUNTROWS(FactHREvent),
    FactHREvent[EventType] = "Termination"
)

Net Headcount Change = [New Hires (Period)] - [Terminations (Period)]

Headcount Visualization

Area chart showing monthly headcount over 24 months, with hires stacked above and terminations stacked below the zero line. This waterfall-style view reveals growth trajectory and the relative contribution of hiring versus retention.

Department breakdown using a stacked bar chart showing headcount by department over time. This reveals which departments are growing, shrinking, or stable.

Headcount by location on a map visual showing geographic workforce distribution. Bubble size represents headcount. Color can represent growth rate (green for growing, red for shrinking locations).

---

Attrition Analysis

Attrition Rate Calculation

The attrition rate formula is deceptively simple, but incorrect calculation is one of the most common HR analytics errors.

Average Headcount =
(
    CALCULATE(MAX(FactHeadcountSnapshot[ActiveCount]),
        FILTER(FactHeadcountSnapshot,
            FactHeadcountSnapshot[SnapshotDate] = MIN(DimDate[Date])
        )
    ) +
    CALCULATE(MAX(FactHeadcountSnapshot[ActiveCount]),
        FILTER(FactHeadcountSnapshot,
            FactHeadcountSnapshot[SnapshotDate] = MAX(DimDate[Date])
        )
    )
) / 2

Attrition Rate =
DIVIDE([Terminations (Period)], [Average Headcount], 0)

Annualized Attrition Rate =
VAR MonthsInPeriod =
    DATEDIFF(MIN(DimDate[Date]), MAX(DimDate[Date]), MONTH) + 1
RETURN
    (1 - POWER(1 - [Attrition Rate], 12 / MonthsInPeriod))

Voluntary Attrition Rate =
DIVIDE(
    CALCULATE(
        COUNTROWS(FactHREvent),
        FactHREvent[EventType] = "Termination",
        FactHREvent[Reason] IN {"Resignation", "Retirement", "Personal Reasons"}
    ),
    [Average Headcount],
    0
)

Involuntary Attrition Rate =
DIVIDE(
    CALCULATE(
        COUNTROWS(FactHREvent),
        FactHREvent[EventType] = "Termination",
        FactHREvent[Reason] IN {"Performance", "Restructuring", "Misconduct"}
    ),
    [Average Headcount],
    0
)

Attrition Deep-Dive Visualizations

Attrition by department using a bar chart sorted by rate (highest to lowest). Highlight departments with rates above the organizational average. This immediately identifies trouble spots.

Attrition by tenure band using a column chart. Common patterns include high turnover in the first year (onboarding failure), a spike at 2--3 years (career growth frustration), or increasing turnover at 5+ years (burnout or stagnation).

Attrition by manager is the most sensitive but often most actionable view. A table showing each manager's team size, terminations, and attrition rate reveals that some managers consistently retain talent while others consistently lose it. Apply this analysis thoughtfully, using it for coaching and support rather than punitive action.

Attrition heatmap combining department and month on axes with attrition rate as color intensity. This reveals seasonal patterns (resignations often spike in January after bonus payouts and in September when children return to school).

Reason analysis using a donut or treemap chart showing the distribution of termination reasons. For voluntary departures, reasons might include better opportunity, compensation, work-life balance, manager relationship, career growth, relocation, and retirement.

Survival Analysis

Survival curves show the probability that an employee remains with the organization at each tenure milestone. Build this by calculating retention rates at 6 months, 1 year, 2 years, 3 years, and 5 years.

Retention Rate at 1 Year =
DIVIDE(
    CALCULATE(
        COUNTROWS(DimEmployee),
        DATEDIFF(DimEmployee[HireDate], TODAY(), MONTH) >= 12,
        OR(DimEmployee[IsActive] = TRUE(),
           DATEDIFF(DimEmployee[HireDate], DimEmployee[TerminationDate], MONTH) >= 12)
    ),
    CALCULATE(
        COUNTROWS(DimEmployee),
        DATEDIFF(DimEmployee[HireDate], TODAY(), MONTH) >= 12
    ),
    0
)

Segment survival curves by department, job level, or hire source to identify which populations are most and least stable.

---

Diversity and Inclusion Metrics

Representation Dashboard

Diversity metrics require careful design to be both informative and respectful. Display aggregate data, never individual-level demographic details.

Gender representation using a stacked bar chart showing gender distribution by department and job level. The critical insight is not overall gender balance but whether representation changes at senior levels (the "broken rung" or "glass ceiling" analysis).

Ethnic representation using similar stacked bars. Compare your organization's demographics to the relevant labor market benchmarks for your locations and industries.

Gender Ratio (Female) =
DIVIDE(
    CALCULATE(COUNTROWS(DimEmployee), DimEmployee[Gender] = "Female", DimEmployee[IsActive] = TRUE()),
    CALCULATE(COUNTROWS(DimEmployee), DimEmployee[IsActive] = TRUE()),
    0
)

Diversity Index =
-- Simpson's Diversity Index: probability that two randomly selected employees are from different groups
1 - SUMX(
    VALUES(DimEmployee[Ethnicity]),
    VAR GroupCount = CALCULATE(COUNTROWS(DimEmployee), DimEmployee[IsActive] = TRUE())
    VAR TotalCount = CALCULATE(COUNTROWS(DimEmployee), DimEmployee[IsActive] = TRUE(), ALL(DimEmployee[Ethnicity]))
    RETURN POWER(DIVIDE(GroupCount, TotalCount, 0), 2)
)

Intersectional Analysis

Aggregate gender or ethnicity analysis alone can mask disparities. Intersectional analysis examines combinations --- for example, the attrition rate of women in engineering versus men in engineering, or the promotion rate of underrepresented minorities at the manager level versus non-minorities.

Build a matrix visual with demographic attributes on rows and metrics (attrition rate, promotion rate, average tenure, average compensation) on columns. Conditional formatting highlights statistically significant differences.

Diversity Pipeline

Track diversity at each stage of the employee lifecycle. What percentage of applicants, interviewees, offers, hires, promotions, and terminations belong to each demographic group? A funnel showing these percentages reveals where diversity is lost. If your applicant pool is 45% female but your hire rate is 30% female, the screening or interview process may have bias worth investigating.

---

Compensation Analysis

Pay Equity Overview

Average Salary =
CALCULATE(
    AVERAGE(DimEmployee[BaseSalary]),
    DimEmployee[IsActive] = TRUE()
)

Average Total Comp =
CALCULATE(
    AVERAGE(DimEmployee[TotalCompensation]),
    DimEmployee[IsActive] = TRUE()
)

Compa-Ratio Average =
CALCULATE(
    AVERAGE(DimEmployee[CompaRatio]),
    DimEmployee[IsActive] = TRUE()
)

Salary Range Penetration =
-- How far through the salary range the employee has progressed
DIVIDE(
    AVERAGE(DimEmployee[BaseSalary]) - MIN(DimPayBand[RangeMinimum]),
    MAX(DimPayBand[RangeMaximum]) - MIN(DimPayBand[RangeMinimum]),
    0
)

Pay Gap Analysis

Pay gap analysis compares compensation across demographic groups. The raw (unadjusted) pay gap compares average salaries. The adjusted pay gap controls for legitimate factors (job level, tenure, performance, location) and reveals the residual gap attributable to potential bias.

Power BI can visualize the output of regression-based pay equity analysis. The regression model itself is typically built in Python, R, or a dedicated compensation analytics tool. Import the model results (predicted salary, actual salary, residual) into Power BI.

Visualization: A scatter plot with predicted salary on the X-axis and actual salary on the Y-axis, colored by demographic group. Points above the diagonal line are paid above what the model predicts; points below are paid less. Clusters of a particular demographic group below the line indicate potential pay inequity.

Compensation Distribution

Box plot or violin plot showing salary distribution by department and job level. These reveal whether compensation is tightly clustered (consistent pay practices) or widely spread (potential inconsistency). Outliers may indicate retention risk (underpaid) or overpaid situations.

---

Recruitment Funnel Analytics

Funnel Metrics

Applications =
CALCULATE(
    COUNTROWS(FactRecruitment),
    FactRecruitment[StageID] = "Applied"
)

Screen Rate =
DIVIDE(
    CALCULATE(COUNTROWS(FactRecruitment), FactRecruitment[StageID] = "Phone Screen"),
    [Applications],
    0
)

Interview Rate =
DIVIDE(
    CALCULATE(COUNTROWS(FactRecruitment), FactRecruitment[StageID] = "Interview"),
    CALCULATE(COUNTROWS(FactRecruitment), FactRecruitment[StageID] = "Phone Screen"),
    0
)

Offer Rate =
DIVIDE(
    CALCULATE(COUNTROWS(FactRecruitment), FactRecruitment[StageID] = "Offer"),
    CALCULATE(COUNTROWS(FactRecruitment), FactRecruitment[StageID] = "Interview"),
    0
)

Offer Acceptance Rate =
DIVIDE(
    CALCULATE(COUNTROWS(FactRecruitment), FactRecruitment[StageID] = "Accepted"),
    CALCULATE(COUNTROWS(FactRecruitment), FactRecruitment[StageID] = "Offer"),
    0
)

Time to Fill =
AVERAGEX(
    FILTER(FactRecruitment, FactRecruitment[StageID] = "Accepted"),
    DATEDIFF(FactRecruitment[PostingDate], FactRecruitment[HireDate], DAY)
)

Cost per Hire =
DIVIDE(
    SUM(FactRecruitment[CostIncurred]),
    CALCULATE(COUNTROWS(FactRecruitment), FactRecruitment[StageID] = "Accepted"),
    0
)

Source Effectiveness

A matrix visual showing each recruitment source (LinkedIn, Indeed, referral, agency, careers page, university) with columns for applications, hires, cost per hire, time to fill, and 1-year retention rate reveals which sources deliver the best talent most efficiently.

Quality of hire is the ultimate recruitment metric. Measure it by tracking the performance rating, promotion rate, and retention rate of hires from each source. A source that delivers cheap, fast hires who leave within a year is less valuable than an expensive source that produces long-tenured high performers.

Recruitment Dashboard Layout

The recruitment page should feature a funnel visualization showing conversion rates between stages, KPI cards for open requisitions, average time to fill, cost per hire, and offer acceptance rate, a source effectiveness table, and a trend line showing hiring volume over time with a forecast based on open requisitions and historical fill rates.

---

Engagement and Satisfaction

Survey Analytics

Average Engagement Score =
CALCULATE(
    AVERAGE(FactSurvey[Score]),
    FactSurvey[QuestionCategory] = "Engagement"
)

eNPS =
-- Employee Net Promoter Score
VAR Promoters =
    CALCULATE(COUNTROWS(FactSurvey), FactSurvey[Score] >= 9, FactSurvey[QuestionCategory] = "Engagement")
VAR Detractors =
    CALCULATE(COUNTROWS(FactSurvey), FactSurvey[Score] <= 6, FactSurvey[QuestionCategory] = "Engagement")
VAR Total =
    CALCULATE(COUNTROWS(FactSurvey), FactSurvey[QuestionCategory] = "Engagement")
RETURN
    DIVIDE(Promoters - Detractors, Total, 0) * 100

Engagement-Attrition Correlation

The most powerful analysis in people analytics is the relationship between engagement scores and subsequent attrition. Build a visualization showing departments or teams plotted with engagement score on one axis and subsequent-quarter attrition rate on the other. A strong negative correlation validates that engagement surveys predict turnover, making engagement a leading indicator that HR can act on before attrition occurs.

Survey Trend Analysis

Track engagement scores over multiple survey administrations (quarterly or annually). A line chart showing category-level trends (Engagement, Manager Relationship, Growth Opportunity, Compensation Satisfaction, Culture) reveals which aspects of the employee experience are improving or deteriorating.

---

Data Privacy and Security

Sensitive Data Handling

HR data is among the most sensitive in any organization. Implement robust security measures.

Row-level security restricts data access by organizational unit. HR business partners see only their assigned departments. Executives see their reporting hierarchy. The CHRO and HR analytics team see everything. Implement RLS using the same pattern described in the financial dashboard guide, with a security mapping table connecting user identities to organizational units.

Aggregation thresholds. Never display demographic data for groups smaller than 5 employees. A diversity breakdown showing "1 employee in the Asian category in the Finance department" effectively identifies an individual. Build DAX measures that suppress small groups.

Suppressed Count =
VAR RawCount = COUNTROWS(DimEmployee)
RETURN IF(RawCount < 5, BLANK(), RawCount)

Data classification. Label the dashboard as confidential in the Power BI Service. Restrict export and download permissions. Audit access logs regularly.

---

Frequently Asked Questions

What HRIS systems integrate well with Power BI?

Workday, SAP SuccessFactors, BambooHR, ADP, UKG (Ultimate Kronos Group), and Oracle HCM Cloud all have Power BI integration options through APIs, data exports, or dedicated connectors. For smaller organizations using spreadsheet-based HR records, Power BI connects directly to Excel files or Google Sheets. The most robust approach is extracting HRIS data into a data warehouse (Azure SQL, Snowflake) on a daily schedule, then connecting Power BI to the warehouse.

How do I handle employees who transfer between departments?

Use the event fact table to track transfers as discrete events. The headcount snapshot table captures the correct department assignment at each point in time. When calculating attrition by department, decide whether to attribute the attrition to the department the employee left from or the department they were in at termination. Industry standard is the department at the time of termination.

What is a healthy employee attrition rate?

Industry averages vary significantly. Technology companies typically see 15--20% annual voluntary attrition. Healthcare and retail see 20--30%. Government and education see 5--10%. A useful benchmark is comparing your rate to your specific industry and geography. More important than the absolute rate is the trend direction and whether attrition is concentrated in high-performing employees or evenly distributed.

Can Power BI predict employee attrition?

Power BI can visualize attrition risk scores generated by predictive models, but the prediction itself is best built in Python (scikit-learn), R, or Azure Machine Learning. Typical predictive features include tenure, recent performance rating change, compensation relative to market, manager tenure, commute distance, and engagement survey scores. The model outputs a risk score for each employee, which Power BI displays as a risk heatmap or sorted list for HR to act on.

How often should HR dashboards refresh?

Weekly refresh is sufficient for most HR metrics. Headcount, attrition, and diversity data do not change minute-to-minute. Recruitment dashboards benefit from daily refresh during active hiring periods. Engagement dashboards refresh after each survey administration. The exception is workforce planning during restructuring or M&A events, where daily or even real-time headcount visibility may be needed.

How do I ensure compliance with data privacy regulations (GDPR, CCPA)?

Implement data minimization --- only include the data fields necessary for analysis. Apply RLS rigorously so only authorized personnel access sensitive data. Aggregate small groups to prevent individual identification. Document your data processing purposes and legal basis. Enable audit logging in the Power BI Service to track who accesses the dashboard and when. For organizations subject to GDPR, ensure that employee consent covers analytics use or that the processing falls under legitimate interest with appropriate safeguards.

---

Professional HR Analytics Development

Workforce analytics transforms HR from a cost center into a strategic function. But building a dashboard that HR leaders trust with sensitive workforce decisions requires expertise in both Power BI and human capital metrics.

ECOSIRE's Power BI services include dashboard development for HR and people analytics, data modeling for complex HRIS integration, and implementation services for organizations building their first people analytics capability.

---

People analytics is not about replacing human judgment with algorithms. It is about giving HR leaders the evidence base to make better decisions faster. When attrition risk is visible before the resignation letter arrives, when pay equity gaps are quantified before they become lawsuits, and when engagement trends are tracked before they become culture crises, the HR function moves from reactive to strategic. That shift starts with the right dashboard.