How to Create an Employee Dashboard in Tableau

Creating an employee dashboard in Tableau is one of the most effective ways to transform complex HR data into clear, actionable insights for your team. This post guides you through the process, from planning your metrics to building interactive charts and assembling a shareable dashboard. We'll cover how to connect your data, create essential visuals, and add features that empower your stakeholders to make data-driven decisions.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

What Is an Employee Dashboard and Why Is It Valuable?

An employee dashboard, or HR dashboard, is a visual tool that centralizes and displays key workforce metrics in one place. Instead of spending hours digging through different spreadsheets or HR systems, you get an at-a-glance view of your company’s most important human resource data, like headcount, turnover, diversity, and employee performance.

The core value of building this in a tool like Tableau comes from its ability to:

• Centralize Information: Combine data from your HRIS (Human Resources Information System), recruiting software, and performance reviews into a single source of truth.
• Facilitate Data-Driven Decisions: Move beyond gut feelings by using real data to answer questions about hiring, compensation, retention strategies, and D&I initiatives.
• Save Time: Automate the reporting process. Once the dashboard is built and connected to a live data source, it updates automatically, eliminating the need for weekly manual report creation.
• Improve Accessibility: Empower department heads and managers with secure access to relevant data about their teams, helping them monitor performance and spot trends independently.

Planning Your Employee Dashboard: First Steps

Before you even open Tableau, a bit of planning will ensure your final dashboard is useful and answers the right questions. Without clear goals, even the most beautiful dashboard can fail to provide real value.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

1. Define Your Audience and Their Key Questions

First, identify who will be using the dashboard. The metrics an executive C-suite needs are different from what an HR business partner or a department manager needs to see.

• Executives (CEO, COO, CHRO): Often need a high-level overview. They’re interested in big-picture metrics like overall headcount, quarterly turnover rate, and diversity goals.
• HR Managers: Need more detailed, operational data. They might track things like voluntary vs. involuntary turnover, time-to-hire by department, and employee engagement scores.
• Department Heads: Require a focused view of their specific team. They’ll want to see performance ratings, headcount within their department, and salary distribution for their direct reports.

Once you know your audience, list the primary questions they need to answer. Examples include:

• "What is our current total headcount, and how is it distributed across departments and locations?"
• "Which departments have the highest voluntary employee turnover this year?"
• "How are we progressing toward our diversity and inclusion goals?"
• "What is the average performance rating of employees, and are there outliers?"

2. Gather Your Key Performance Indicators (KPIs)

Your KPIs are the specific metrics that will answer the questions you just defined. Keep your list focused on what's truly essential. Here are some common KPIs for an employee dashboard:

• Headcount: Total number of employees, often broken down by department, employment type (full-time, part-time), or location.
• Turnover/Attrition Rate: The percentage of employees who leave the company over a period, often segmented into voluntary (they quit) and involuntary (they were let go).
• Employee Demographics: Data points like age, gender distribution, departments, and tenure (how long employees have been with the company).
• Recruitment Data: Metrics like average time-to-fill an open position, cost-per-hire, or offer acceptance rate.
• Performance Metrics: Distribution of employee performance ratings (e.g., from 1 to 5).
• Compensation Data: Average salary by department or role to ensure pay equity.

3. Prepare Your Data Source

Your dashboard is only as good as the data it's built on. The most common source for employee data is an HR Information System (HRIS) like Workday, BambooHR, or Gusto. Most businesses will export this data into a centralized spreadsheet.

For this tutorial, we will assume you have an Excel or Google Sheets file with a list of all your employees (both active and terminated). A good dataset should include columns like:

• Employee ID (a unique identifier)
• First Name, Last Name
• Department
• Job Title
• Gender
• Hire Date
• Termination Date (blank if still active)
• Termination Reason (e.g., Voluntary, Involuntary)
• Location (City, State)
• Performance Rating (if available)
• Salary

Ensure your data is clean. This means checking for consistent naming (e.g., "Marketing" vs. "Mktg"), correct date formats, and no missing essential values.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Step-by-Step Guide to Building the Dashboard in Tableau

With your plan and data ready, it's time to build. We’ll create a basic but powerful dashboard with KPIs, key charts, and interactive filters.

Step 1: Connect to Your Data

Open Tableau Desktop or Tableau Public.

1. Under Connect, select the type of file you’re using. For this example, click on Microsoft Excel.
2. Navigate to your employee data file and open it.
3. Tableau will take you to the Data Source pane. You'll see the sheets from your workbook on the left. Drag your employee sheet onto the canvas.
4. Review the data grid to make sure Tableau is reading the columns and data types correctly (e.g., dates are marked with a calendar icon, numbers with a #).

Step 2: Create Core KPIs as Individual Worksheets

KPI cards are large numbers that give an instant summary. We’ll start with "Total Headcount." Each KPI should be its own worksheet.

1. Click the New Worksheet tab at the bottom. Rename this sheet "Total Headcount."
2. From the Data pane on the left, drag Employee ID onto the Text mark in the Marks card.
3. By default, it may sum the IDs. Right-click the Employee ID pill in the Marks card, go to Measure, and select Count (Distinct). This ensures each employee is counted only once.
4. To make it a true KPI card, click on the dropdown menu in the toolbar above your blank canvas that says “Standard” and change it to Entire View so your numbers are big. Format the font to be larger and centered.

Repeat this process for other key KPIs in new worksheets. For example:

• Attrition Rate: You’ll likely need a calculated field for this.
• Average Tenure: Create a calculated field to measure the difference between today's date and the hire date.

Step 3: Build Your Main Visualizations

Now, let’s build a few essential charts on separate worksheets. Having organized and descriptive titles for each chart is incredibly important.

Chart 1: Headcount by Department (Bar Chart)

1. Create a new worksheet and name it "Headcount by Department."
2. Drag the Department dimension to the Columns shelf.
3. Drag Employee ID to the Rows shelf. Then, right-click it, go to Measure, and change it to Count (Distinct).
4. You now have a bar chart! To enhance it:

Chart 2: Monthly Headcount Trend (Line Chart)

1. Create a new worksheet and name it “New Hires over Time.”
2. Drag your Hire Date field to your Columns shelf. Right-click it to change the format to Month/Year.
3. Drag Distinct Count of Employee ID to Rows, and Tableau automatically creates a line chart showing your new hires each month.

Chart 3: Map of Employee Distribution

1. Create a new worksheet and name it "Employee Distribution."
2. Drag your Country field to the map to create a visualization of employee distribution. Tableau automatically populates Longitudes and Latitudes.
3. Drag the Distinct Count of Employee ID to Size and Color Marks to see your most popular employee locations based on the size of the circles on the map.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step 4: Assemble Your Dashboard

Now comes the best part - bringing everything together.

1. Start a new dashboard, and name it something like “Employee Dashboard.”
2. On the left, you’ll see the worksheets you created - your KPI cards and charts.
3. Drag and drop these sheets onto the dashboard canvas. I recommend placing the KPI cards at the top for an instant overview, followed by the detailed charts. A common layout uses Tiled to arrange items automatically and Floating for specific fine-tuning.

Step 5: Add Interactivity

A dynamic dashboard is more valuable than a static report. Add interactive elements like filters to make your dashboard versatile and insightful.

1. Create a filter for a key dimension, such as department. Go to one of your sheets (like “Headcount by Department”).
2. From the Data pane, find your dimension and right-click to select "Show Filter."

Final Thoughts

Building an employee dashboard in Tableau transforms your raw HR data from static spreadsheets into an interactive, dynamic resource. By carefully planning your metrics and KPIs, you can build a powerful dashboard to track your workforce more efficiently, spot trends before they become problems, and back up your HR team's strategic decisions by displaying key company metrics.

For teams that need a comprehensive solution to combine data across systems like QuickBooks and Tableau, we recommend Graphed. It connects to all your data sources and instantly creates professional dashboards and reports, allowing you to focus on strategic analysis without the hassle of data wrangling.