HR Analytics and Employee Performance Dashboard in Tableau – Complete Detailed Notes

Course: Tableau Training | Topic: HR Analytics and Employee Performance Dashboard | Level: Beginner to Advanced

Learn Tableau: JustAcademy Tableau Training | Register for a Tableau Course Demo

1. Introduction to HR Analytics and Employee Performance

HR Analytics, also known as Human Resource Analytics or People Analytics, is the process of collecting, organizing, analyzing, and interpreting workforce data to support better human resource decisions. It helps organizations understand employee performance, workforce composition, recruitment, retention, attendance, training, compensation, engagement, and productivity.

Employee Performance Analysis focuses on understanding how employees perform against defined responsibilities, objectives, and performance indicators. It can include performance ratings, goal completion, productivity measures, training outcomes, quality indicators, and manager assessments, depending on the organization's data and policies.

Tableau is a business intelligence and data visualization platform that helps HR professionals transform workforce data into interactive dashboards. Instead of manually reviewing multiple spreadsheets, HR teams can explore workforce metrics through charts, filters, KPI cards, and drill-down views.

For example, a company may want to understand how employee performance ratings differ across departments, whether training participation is associated with improved performance, and whether attrition is concentrated in particular job roles. Tableau can help visualize these patterns and support further investigation.

Official resource: Tableau Human Resources Analytics.

2. Learning Objectives

• Understand the meaning and importance of HR Analytics.
• Learn how Tableau supports workforce reporting and analysis.
• Identify key HR metrics and employee performance indicators.
• Connect employee datasets to Tableau.
• Clean, validate, and organize HR data.
• Create calculated fields for employee counts, active employees, attrition, and performance.
• Analyze workforce distribution by department, job role, tenure, and location.
• Build employee performance comparison charts.
• Analyze training participation, attendance, and performance ratings when suitable data is available.
• Design an interactive HR dashboard with filters and KPI cards.
• Interpret findings responsibly and protect employee privacy.
• Complete a practical HR Analytics Dashboard project.

3. What Is HR Analytics?

HR Analytics applies analytical methods to workforce data to help organizations understand employee-related trends and evaluate HR processes. It supports decisions about hiring, employee development, performance management, workforce planning, retention, and compensation.

3.1 Main Types of HR Analytics

Tableau is particularly useful for descriptive and diagnostic analysis. Predictive and prescriptive analytics may require additional statistical methods, models, or integrations.

4. What Is an Employee Performance Dashboard?

An Employee Performance Dashboard is an interactive visual report that summarizes selected workforce and performance indicators. It helps HR teams, managers, and authorized leadership review trends, compare departments, identify data-quality issues, and explore questions about employee development.

A dashboard can combine employee counts, performance ratings, training records, attendance, goals, and department-level comparisons. The exact content depends on the available data and the organization's performance management framework.

4.1 Benefits of an HR Dashboard

• Provides a consolidated view of important HR metrics.
• Reduces repetitive manual reporting.
• Helps compare performance indicators across teams and time periods.
• Supports workforce planning and training evaluation.
• Highlights potential retention and employee development concerns.
• Enables interactive exploration using filters.
• Helps managers communicate workforce trends clearly.
• Supports more consistent and evidence-informed decisions.

5. Business Scenario

Consider a company with employees across several departments, including Sales, Marketing, Finance, Operations, and Information Technology. The HR department maintains employee records, performance ratings, training history, attendance data, and employment status.

Leadership wants to understand the size and composition of the workforce, compare employee performance ratings, review training participation, and identify departments where attrition or performance-management issues require additional investigation.

6. Tools and Technologies Required

7. Understanding the HR Dataset

A well-designed HR dashboard starts with reliable source data. Employee, performance, training, and attendance data may be stored in separate tables. Before connecting them, determine what each row represents and how the tables relate to one another.

7.1 Employee Master Dataset

7.2 Employee Performance Dataset

7.3 Training Dataset

7.4 Example Employee Dataset

Note: The sample data is illustrative. Performance ratings and training hours are not directly comparable unless the rating scale, job expectations, training definitions, and reporting periods are consistent.

8. Step 1: Connect Tableau to HR Data

1. Open Tableau Desktop.
2. Under Connect, select Microsoft Excel, Text File, or the appropriate database connector.
3. Select the approved HR dataset.
4. Review the fields in the Data Source tab.
5. Set Employee ID and Manager ID to appropriate identifier types, typically String.
6. Verify that Hire Date, Termination Date, and Review Date are recognized as dates.
7. Ensure performance ratings and numeric measures use suitable data types.
8. Inspect null values, duplicate records, and inconsistent categories.
9. Open a worksheet and confirm that employee counts and other basic totals are reasonable.

8.1 Data Preparation Checklist

• Check whether Employee ID uniquely identifies an employee in the master table.
• Investigate duplicate employee records and duplicate performance reviews.
• Standardize department and job-role names.
• Validate hire dates and termination dates.
• Check missing performance ratings and inconsistent rating scales.
• Distinguish current employee records from historical snapshots.
• Validate training completion statuses and training hours.
• Confirm the reporting period for each performance measure.
• Remove unnecessary personal information from the analysis dataset.
• Document the meaning and limitations of each HR metric.

9. Step 2: Understand Tableau Dimensions and Measures

Dimensions categorize data, while measures contain values that can be aggregated. Choosing the right field type and level of detail is essential for reliable HR reporting.

10. Step 3: Create Essential HR Calculated Fields

Tableau calculated fields allow analysts to create new measures and dimensions from existing data. To create one, select Analysis > Create Calculated Field, provide a meaningful name, enter the formula, and validate the result.

Official reference: Tableau – Create a Simple Calculated Field.

10.1 Employee Count

COUNTD([Employee ID])

Use this calculation to count unique employee identifiers. If the dataset contains multiple review records per employee, counting rows will overstate the employee population.

10.2 Active Employee Flag

If the data contains a reliable Employment Status field, create the following calculated field:

IF [Employment Status] = "Active" THEN 1
ELSE 0
END

This formula assumes that the source uses exactly the value Active. If employment status is represented through effective dates, use an appropriate date-based rule instead.

10.3 Active Employee Count

For a master table with one current record per employee, the following is one option:

COUNTD(
    IF [Employment Status] = "Active"
    THEN [Employee ID]
    END
)

This avoids counting multiple transaction or review records as multiple employees. When the dataset contains historical employee snapshots, select the correct snapshot date before calculating current headcount.

10.4 Terminated Employee Count

COUNTD(
    IF [Employment Status] = "Terminated"
    THEN [Employee ID]
    END
)

Use this calculation only when Terminated is a valid and consistent status value. For historical attrition analysis, use termination events and the relevant reporting period rather than relying only on current status.

10.5 Average Performance Rating

AVG([Performance Rating])

Use the average only when ratings are on a comparable scale and the aggregation answers the business question. Because an employee may have multiple reviews, specify the review period and decide whether the analysis should use the latest rating, each review, or another defined summary.

10.6 Performance Rating Band

IF [Performance Rating] >= 4 THEN
    "High Rating"
ELSEIF [Performance Rating] >= 3 THEN
    "Moderate Rating"
ELSE
    "Low Rating"
END

This example assumes a rating scale where higher values represent stronger ratings, such as a scale from 1 to 5. Adjust the thresholds to the organization's approved rating framework. A rating band is a descriptive category, not a complete assessment of employee contribution.

10.7 Employee Tenure in Years

If the analysis uses a fixed reporting date, create a Date parameter named Analysis As Of Date. Then calculate:

DATEDIFF('day', [Hire Date], [Analysis As Of Date]) / 365.25

This produces an approximate tenure in years. Confirm that the hire date is valid and that the analysis date is on or after the hire date. For terminated employees, determine whether tenure should end on Termination Date instead.

10.8 Tenure Group

IF [Tenure in Years] < 1 THEN
    "Less than 1 Year"
ELSEIF [Tenure in Years] < 3 THEN
    "1–2 Years"
ELSEIF [Tenure in Years] < 5 THEN
    "3–4 Years"
ELSE
    "5+ Years"
END

The boundaries are examples. Tenure bands should match workforce-planning needs and should not conceal important differences within groups.

10.9 Training Completion Flag

IF [Completion Status] = "Completed" THEN 1
ELSE 0
END

Use this field to calculate training completion where each record represents a training enrollment. If employees have multiple courses, distinguish course-level completion from employee-level completion.

10.10 Training Completion Rate

SUM([Training Completion Flag])
/
COUNT([Training ID])

Format the result as a percentage. This formula assumes each row is one valid training enrollment and Training ID is populated for every enrollment. If the data contains duplicate enrollments or multiple rows per course, clean or deduplicate the data first.

10.11 Goal Completion Percentage

If Goal Completion is stored as a numeric percentage at the correct level of detail, use:

AVG([Goal Completion])

Confirm whether the source stores percentages as values such as 85 or decimal fractions such as 0.85. Also determine whether every employee has the same number of goals; an unweighted average of employee percentages may differ from a goal-weighted completion rate.

11. Step 4: Calculate HR KPIs

Key Performance Indicators (KPIs) summarize workforce conditions and help managers monitor important objectives. A KPI should have a clear definition, a consistent reporting period, and an appropriate denominator.

11.1 Headcount

Headcount is the number of employees in the defined population at a specified point in time.

Headcount = COUNTD([Employee ID])

Filter or otherwise define the population as of the selected reporting date. For historical headcount, use effective-dated employee records or a validated snapshot rather than simply counting all employees ever present in the dataset.

11.2 Attrition Rate

A common period-based definition is:

Attrition Rate =
(Number of Employee Exits During Period
 / Average Headcount During Period) * 100

Some organizations use starting headcount as the denominator. Always document the company's chosen formula and whether exits include voluntary resignations, involuntary terminations, retirements, or other categories.

11.3 Average Headcount

A simple approximation is:

Average Headcount =
(Starting Headcount + Ending Headcount) / 2

This is useful when only beginning and ending counts are available. Organizations with substantial workforce fluctuations may prefer monthly averages or another approved calculation.

11.4 Employee Turnover

Turnover is a related workforce movement measure. Depending on organizational policy, turnover may include different exit categories. Do not assume that attrition and turnover have identical definitions in every company.

11.5 Average Training Hours per Employee

SUM([Training Hours]) / COUNTD([Employee ID])

This formula is appropriate only when Training Hours are at a valid training-record grain and the denominator represents the intended employee population. Decide whether the KPI should include all employees, only employees enrolled in training, or only active employees.

11.6 Performance Rating Distribution

Use a distinct employee count by rating band if each employee should appear once in the distribution. If the source contains multiple performance reviews, filter to the chosen review cycle or derive a documented employee-level rating.

11.7 Goal Completion Rate

Goal completion can be reported as the percentage of goals completed, the average employee goal-completion percentage, or the percentage of employees meeting a target. These metrics answer different questions and should not be used interchangeably.

12. Step 5: Build HR Analytics Worksheets

12.1 Employee Headcount by Department

1. Create a new worksheet named Headcount by Department.
2. Drag Department to Rows.
3. Drag Employee ID to Columns.
4. Change the aggregation to Count Distinct.
5. Select a horizontal bar chart.
6. Sort departments by employee count.
7. Add the distinct employee count to labels or tooltips.

Business question: Which departments have the largest workforce?

12.2 Employee Performance by Department

1. Create a worksheet named Performance by Department.
2. Place Department on Rows.
3. Place the validated employee-level performance metric on Columns.
4. Use an average or another approved summary measure.
5. Add employee count to the tooltip.
6. Display rating scale information in the title or tooltip.

Business question: How do performance measures vary across departments?

Interpret comparisons carefully. Different departments may use different performance standards, job expectations, review distributions, or evaluation practices.

12.3 Performance Rating Distribution

1. Create a worksheet named Performance Rating Distribution.
2. Place Performance Rating or Rating Band on Columns.
3. Place Employee ID on Rows or Text using the correct distinct count.
4. Filter to the chosen review cycle.
5. Choose a bar chart to show the number of employees in each rating category.
6. Optionally display the percentage of the eligible employee population in each band.

Business question: How are employee ratings distributed under the selected review framework?

12.4 Performance by Job Role

1. Create a worksheet named Performance by Job Role.
2. Place Job Role on Rows.
3. Place the approved performance metric on Columns.
4. Include the employee count for each role.
5. Sort or group the roles as appropriate.
6. Use filters for department and review period.

Business question: How do performance outcomes differ across job roles?

12.5 Training Hours vs Performance

1. Create a worksheet named Training vs Performance.
2. Place employee-level Training Hours on Columns.
3. Place the selected employee-level Performance Rating on Rows.
4. Place Employee ID on Detail so that each mark represents the intended employee-level observation.
5. Add department or job role to Color if it improves interpretation.
6. Check for duplicated records and missing values.
7. Use a trend line only when appropriate and clearly label it as an association.

Business question: Is training participation associated with performance differences?

Important: A scatter plot or trend line cannot establish that training caused a performance change. Employee role, experience, training selection, manager support, and other factors may influence both variables.

12.6 Attrition by Department

1. Create a worksheet named Attrition by Department.
2. Place Department on Rows.
3. Use the distinct count of eligible employee exits for the selected period.
4. Calculate the attrition rate with the approved denominator.
5. Show counts and rates together when useful.
6. Apply consistent period filters and clearly identify the exit definition.

Business question: Which departments show higher employee exits or attrition rates?

12.7 Workforce Trend Over Time

1. Create a worksheet named Workforce Trend.
2. Place the appropriate reporting month on Columns.
3. Place headcount on Rows.
4. Use a line chart.
5. Confirm that each month's value represents the workforce at the intended point in time.
6. Add hiring and exit measures if reliable event data is available.

Business question: How has workforce size changed over the selected period?

13. Step 6: Design the HR Analytics Dashboard

A useful HR dashboard presents key workforce information clearly and allows authorized users to explore the factors behind the summary metrics.

13.1 Recommended Dashboard Layout

----------------------------------------------------------
| HR ANALYTICS AND EMPLOYEE PERFORMANCE DASHBOARD         |
----------------------------------------------------------
| Period | Department | Job Role | Location | Status      |
----------------------------------------------------------
| Headcount | Active Staff | Attrition | Avg Performance |
----------------------------------------------------------
| Headcount by Department | Performance Rating Distribution|
----------------------------------------------------------
| Performance by Job Role | Training vs Performance        |
----------------------------------------------------------
| Attrition Trend         | Training Completion            |
----------------------------------------------------------
| Workforce Trend / Detailed Approved HR Summary           |
----------------------------------------------------------

13.2 Assemble the Dashboard

1. Click New Dashboard in Tableau.
2. Rename it HR Analytics and Employee Performance Dashboard.
3. Choose a suitable dashboard size for the intended screen.
4. Add KPI worksheets for headcount, active employees, attrition, and performance.
5. Add department, job-role, and rating visualizations.
6. Add training and workforce trend views if the source supports them.
7. Place filters in a consistent location.
8. Configure dashboard actions and useful tooltips.
9. Use clear titles, readable labels, and consistent number formats.
10. Test the dashboard with different departments and reporting periods.

13.3 Recommended KPI Cards

14. Step 7: Add Filters and Dashboard Actions

Filters allow users to analyze selected workforce groups. Use them to support legitimate business questions while maintaining access restrictions for sensitive data.

14.1 Useful Dashboard Filters

• Review Period: Select a performance cycle or reporting period.
• Department: Compare workforce groups.
• Job Role: Focus on a role or role family.
• Location: Compare offices or regions.
• Employment Status: Select active or historical employee groups.
• Tenure Group: Compare employees by length of service.
• Training Name: Review selected training programs.
• Performance Rating Band: Focus on a rating category.

14.2 Apply a Filter to Multiple Worksheets

1. Display the desired filter on the dashboard or worksheet.
2. Open the filter menu.
3. Select Apply to Worksheets.
4. Choose the worksheets that should respond to the filter.
5. Verify that each selected view uses compatible data and field definitions.
6. Test the dashboard using several filter combinations.

14.3 Dashboard Actions

Dashboard actions can make a chart interactive. For example, selecting a department in the Headcount by Department chart can filter the performance and training views to that department. Test the action carefully so that it does not unintentionally remove required context from KPI calculations.

15. Step 8: Analyze Employee Performance Responsibly

Employee performance metrics need context. A single rating, attendance value, or productivity measure rarely represents an employee's full contribution. The dashboard should support informed discussion rather than automatically judging individual employees.

15.1 Performance Rating Analysis

Review rating distributions across teams and periods. Consider whether the rating scale, review cycle, role expectations, and evaluation process are consistent. Differences between departments may reflect different standards or responsibilities rather than differences in employee ability.

15.2 Goal Completion Analysis

Analyze goal completion only when goals are documented and measured consistently. Some roles may have qualitative goals while others have quantitative targets. Use role-specific context when comparing outcomes.

15.3 Training Analysis

Compare training participation, completion, assessment results, and performance outcomes where the data supports it. Account for the timing of training and performance reviews. Employees may attend training because they are already high-performing or because additional support is needed.

15.4 Tenure and Performance

Compare performance measures across tenure groups to explore onboarding and development patterns. Do not assume that longer tenure always means higher performance, or that differences between tenure groups demonstrate a causal relationship.

15.5 Attendance and Productivity

Attendance data should be interpreted with approved definitions, leave categories, work arrangements, and role requirements. Avoid treating protected leave, disability-related accommodations, or other sensitive circumstances as negative performance indicators.

16. Step 9: Advanced HR Analysis

16.1 Performance Trends Over Time

When multiple review periods are available, compare employee-level or department-level performance trends over time. Ensure that each observation represents a comparable review period and that changes in the rating scale are accounted for.

16.2 Employee Attrition Analysis

Use employment start and end dates to examine exits over time. Segment attrition by department, job role, tenure, or other appropriate factors. Keep the distinction between descriptive association and causal explanation clear.

16.3 Training Effectiveness

Training effectiveness can be assessed through completion, assessment scores, skill demonstrations, and relevant outcomes. If comparing before-and-after performance, account for differences in timing, eligible populations, and other changes that may affect results.

16.4 Workforce Planning

Combine current headcount, hiring trends, exits, role distribution, and approved workforce plans to identify potential staffing needs. Forecasts should state their assumptions and should not be treated as certain outcomes.

16.5 Performance Benchmarking

Compare performance metrics against approved organizational targets or benchmarks. Ensure that the benchmark applies to the relevant role, business unit, and time period. Avoid ranking employees across incomparable jobs using a single unadjusted measure.

17. Step 10: Common Data Problems and Solutions

18. Step 11: Dashboard Performance and Design Best Practices

• Use a clear title and state the reporting period.
• Put the most important workforce KPIs near the top.
• Use bar charts for department and job-role comparisons.
• Use line charts for time-series metrics.
• Use distributions to understand rating patterns instead of showing only averages.
• Keep colors consistent and accessible.
• Limit the number of filters to those that support meaningful analysis.
• Use tooltips to explain metrics and definitions.
• Reduce unnecessary marks and redundant worksheets.
• Validate totals after combining multiple data sources.
• Use extracts or optimized queries where appropriate.
• Test dashboard loading time with realistic data volumes.

19. Step 12: Employee Data Privacy and Security

HR data may contain sensitive personal, compensation, performance, health-related, or employment information. Dashboard design must follow the organization's privacy, security, and access policies.

• Show only the employee information required for the stated business purpose.
• Restrict salary and individual performance details to authorized users.
• Use aggregated reporting when individual-level data is unnecessary.
• Apply row-level security where users should see only permitted employee groups.
• Remove unnecessary personal identifiers from shared dashboards.
• Avoid publishing sensitive employee data to public workbooks.
• Check export, download, and sharing permissions.
• Use small-group suppression or other safeguards when reporting could identify individuals.
• Follow applicable company policy and legal requirements.
• Review whether a metric could create unfair or misleading employee comparisons.

20. Step 13: Publish and Share the HR Dashboard

1. Save the Tableau workbook with a clear name.
2. Validate employee counts, performance metrics, and attrition calculations.
3. Confirm that data sources refresh correctly.
4. Publish to Tableau Server or Tableau Cloud if available.
5. Assign access permissions based on job responsibilities.
6. Test the dashboard with an authorized viewer account.
7. Confirm that filters and dashboard actions work as intended.
8. Verify that downloads and underlying data access are restricted appropriately.
9. Document the definitions, assumptions, and refresh schedule.

For dashboard inspiration, see Tableau Human Resources Dashboard Examples.

21. Practical Project: HR Analytics and Employee Performance Dashboard

Project Objective: Build an interactive Tableau dashboard that summarizes workforce size, employee performance, training participation, and attrition using a validated HR dataset.

21.1 Project Requirements

• Employee master dataset with Employee ID, department, job role, hire date, and employment status.
• Performance dataset with review date and performance rating.
• Training dataset with course enrollment and completion information, if available.
• Termination records or reliable historical status data for attrition analysis.
• Calculated fields for employee count, active status, tenure, and performance categories.
• Worksheets for workforce distribution, performance ratings, training, and attrition.
• Dashboard filters and appropriate access controls.

21.2 Project Implementation

Step 1: Import the Data

Connect Tableau to the approved employee, performance, and training files. Confirm that Employee ID is consistent across the datasets and inspect the row-level grain of each table.

Step 2: Clean and Validate

Check duplicate employees, duplicate reviews, missing ratings, inconsistent job roles, invalid dates, and incomplete status values. Document any exclusions.

Step 3: Create Calculated Fields

Create employee counts, active employee flags, tenure groups, performance rating bands, training completion measures, and approved attrition calculations.

Step 4: Build Worksheets

• Headcount by Department.
• Performance Rating Distribution.
• Performance by Job Role.
• Training Completion by Department.
• Training Hours vs Performance.
• Attrition by Department.
• Workforce Trend over Time.

Step 5: Assemble the Dashboard

Place KPI cards at the top, department and rating charts in the main section, and trend or training analysis below. Add filters for review period, department, job role, location, and employment status where appropriate.

Step 6: Validate Results

Compare Tableau totals with the source data. Check that employee counts are distinct, that performance records use the correct review period, and that attrition uses the approved exit definition and denominator.

Step 7: Publish Securely

Publish to an approved Tableau environment, restrict access to authorized users, and confirm that individual-level employee information is not exposed to unintended audiences.

21.3 Expected Project Outcomes

• A consolidated view of workforce size and composition.
• Improved visibility into performance-rating distributions.
• Better understanding of training participation and completion.
• Clearer analysis of employee exits and workforce trends.
• Interactive exploration of department and role-level patterns.
• A documented and secure dashboard for HR reporting.

22. Interview Questions and Answers

Q1. What is HR Analytics?

Answer: HR Analytics uses workforce data to understand employee trends and support decisions about recruitment, performance, training, retention, and workforce planning.

Q2. What is an HR dashboard?

Answer: An HR dashboard is an interactive visual report that summarizes selected HR metrics and allows authorized users to explore workforce patterns.

Q3. What is employee performance analysis?

Answer: It is the process of examining defined performance indicators, such as review ratings, goal completion, quality, or role-specific productivity measures.

Q4. What is headcount?

Answer: Headcount is the number of employees in a defined population at a specified point in time.

Q5. How do you count unique employees in Tableau?

Answer: Use COUNTD([Employee ID]) when the objective is to count distinct employees rather than individual transaction or review rows.

Q6. What is employee attrition?

Answer: Employee attrition refers to employees leaving an organization under a defined set of exit categories and during a specified period.

Q7. How is attrition rate calculated?

Answer: A common formula divides qualifying employee exits during a period by average headcount for that period, then multiplies by 100. The organization should document its exact definition.

Q8. Why is the grain of HR data important?

Answer: The grain describes what one row represents. A table may contain one row per employee, review, or training enrollment. Combining tables at different grains can duplicate records and distort counts or averages.

Q9. How can Tableau compare employee performance across departments?

Answer: Create a department-level visualization using a validated performance measure, then add employee counts, review-period filters, and tooltips that explain the rating scale.

Q10. What is a calculated field in Tableau?

Answer: A calculated field derives a new value or category from existing fields using a formula, such as an active employee flag or performance rating band.

Q11. How do you calculate employee tenure?

Answer: Use the difference between the hire date and a defined reporting date. For former employees, use the appropriate termination date when measuring completed tenure.

Q12. How can training effectiveness be analyzed?

Answer: Review completion, assessment outcomes, and relevant performance measures while considering the timing of training, employee selection, and other factors. Correlation alone does not prove that training caused an outcome.

Q13. What is the difference between a measure and a dimension?

Answer: A dimension groups data, such as Department or Job Role, while a measure is a value that can be aggregated, such as Training Hours or Salary.

Q14. Why can performance averages be misleading?

Answer: Averages can hide variation, small group sizes, different rating scales, and differences in job responsibilities. They should be interpreted alongside distributions and context.

Q15. How do you handle multiple reviews for one employee?

Answer: Define whether the analysis uses all reviews, the latest review, or a specific review cycle. Use the appropriate employee-level or review-level calculation to avoid double counting.

Q16. How can you protect employee information in Tableau?

Answer: Apply appropriate permissions, restrict sensitive fields, use row-level security where needed, aggregate data when possible, and follow organizational privacy policies.

Q17. What is workforce planning?

Answer: Workforce planning aligns employee capacity and skills with business needs by examining headcount, staffing movements, role requirements, and future workforce scenarios.

Q18. What should be checked before publishing an HR dashboard?

Answer: Validate source data, employee counts, formulas, reporting periods, filters, refresh behavior, access permissions, and sensitive information exposure.

23. Practice Exercises

1. Connect Tableau to an employee master dataset.
2. Identify dimensions, measures, identifiers, and dates.
3. Calculate distinct employee count.
4. Create an active employee flag.
5. Build a bar chart showing headcount by department.
6. Create performance rating bands.
7. Build a performance-rating distribution chart.
8. Compare performance measures by job role using a consistent review period.
9. Calculate employee tenure and create tenure groups.
10. Analyze training completion by department.
11. Build a training-hours versus performance visualization.
12. Calculate attrition using a documented definition.
13. Create a workforce trend chart if historical records are available.
14. Combine the worksheets into an interactive dashboard.
15. Validate the dashboard against the source data and review privacy controls.

24. HR Dashboard Quality Checklist

Data Quality

• ☐ Employee identifiers are consistent.
• ☐ Duplicate employee and review records have been investigated.
• ☐ Employment dates and statuses are valid.
• ☐ Performance ratings use a documented scale.
• ☐ Training records use consistent completion statuses.

Metrics and Calculations

• ☐ Headcount is calculated for the intended reporting date.
• ☐ Active employee definitions are documented.
• ☐ Attrition uses the correct exit categories and denominator.
• ☐ Performance metrics use the correct review period.
• ☐ Training completion uses the correct enrollment population.

Dashboard Design

• ☐ KPI cards have clear titles and definitions.
• ☐ Charts use suitable visual encodings.
• ☐ Filters work across the intended worksheets.
• ☐ Tooltips provide meaningful context.
• ☐ Labels and number formats are consistent.

Privacy and Publishing

• ☐ Access is restricted to authorized users.
• ☐ Sensitive fields are excluded or protected.
• ☐ Row-level security is tested where needed.
• ☐ Export and download permissions are appropriate.
• ☐ The published dashboard has been checked for accidental data exposure.

25. Quick Revision Notes

• HR Analytics: Analysis of workforce data to support HR decisions.
• Employee Performance: Evaluation of defined performance indicators.
• Headcount: Number of employees in a defined population at a specific time.
• Attrition: Employee exits during a defined period.
• Performance Rating: Rating recorded under an approved performance framework.
• Tenure: Length of an employee's service during a defined period.
• Training Completion Rate: Share of eligible training enrollments completed.
• Goal Completion: Measure of progress against defined objectives.
• COUNTD: Tableau function that counts distinct values.
• Calculated Field: A field created from existing data using a formula.
• Dashboard Filter: An interactive control for exploring selected records.
• Workforce Planning: Aligning staffing and skills with organizational needs.
• Data Grain: The meaning of one row in a dataset.
• Row-Level Security: Restricting data visibility according to user permissions.

26. Conclusion

HR Analytics and Employee Performance Dashboard development in Tableau helps organizations turn workforce data into meaningful visual insights. By combining employee counts, performance ratings, training metrics, attrition analysis, and workforce trends, HR teams can review important patterns in a structured and interactive way.

Reliable HR analysis depends on clear metric definitions, appropriate aggregation, consistent review periods, and careful treatment of employee records. Performance and training comparisons should be interpreted with context, while sensitive employee information must be protected through appropriate access controls.

By completing the practical project and exercises in these notes, learners can develop the skills needed to connect HR datasets, create calculated fields, build interactive dashboards, validate workforce KPIs, and communicate findings responsibly.

Explore Tableau Training: JustAcademy Tableau Training

Register for a Course Demo: Register for a Tableau Course Demo

Additional Learning Resources

• Tableau – Human Resources Analytics
• Tableau – Human Resources Dashboard Examples
• Tableau – Creating Calculated Fields
• Tableau – Visualizing Key Performance Indicators
• JustAcademy – HR Analytics Dashboard Project Example