How to Create a Recruitment Dashboard in Tableau

Tracking your recruitment pipeline in a messy spreadsheet is a fast way to fall behind on hiring goals. A well-designed Tableau dashboard, however, transforms that raw data into a clear story, showing you exactly where your top candidates are coming from, how long it takes to hire them, and where bottlenecks are slowing you down. This guide will walk you through how to plan, build, and optimize a powerful recruitment dashboard in Tableau, step by step.

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

First, Plan Your Dashboard: What Metrics Should You Track?

Before you even open Tableau, you need to decide what you want to measure. A great dashboard answers important questions, not just shows a bunch of numbers. Start by focusing on the core metrics that reveal the health and efficiency of your hiring process.

Think of your metrics in a few key categories:

Recruitment Funnel Metrics

These metrics track the flow of candidates through each stage of your hiring process, from initial application to signed offer. They help you pinpoint where candidates are dropping off.

• Applications per Opening: Total number of applications for a specific role.
• Qualified Candidates (by stage): The count of candidates who pass the initial screen, technical interview, final interview, etc.
• Offers Extended vs. Offers Accepted: How many offers are you making, and how many are being accepted?
• Conversion Rate: The percentage of candidates who move from one stage to the next (e.g., Application to Phone Screen rate).

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

Efficiency and Speed Metrics

Time is money, especially in recruiting. These KPIs help you understand how fast your team is moving.

• Time-to-Fill: The total number of days from when a job is posted to when a candidate accepts the offer. This is a classic C-suite metric used to measure the overall efficiency of the recruiting function.
• Time-to-Hire: The total number of days from when a candidate first applies to when they accept the offer. This measures the agility of your process from the candidate's perspective.
• Time Spent in Each Stage: How long are candidates waiting for a phone screen? How many days pass between the final interview and the offer? This helps you spot specific bottlenecks.

Source and Quality Metrics

Where are your best hires coming from, and how can you find more of them? These metrics help you optimize your recruiting spend and strategy.

• Source of Hire: A breakdown of which channels your hired candidates came from (e.g., LinkedIn, employee referrals, job boards, career site).
• Cost per Hire: The total cost of recruiting (ad spend, recruiter salaries, etc.) divided by the number of hires made.
• Offer Acceptance Rate: (Offers Accepted / Offers Extended) * 100. A low rate might indicate issues with compensation, company culture, or the interview process.
• Quality of Hire: This is harder to measure but incredibly valuable. You can track this by looking at the 6- or 12-month performance review scores of new hires or their retention rate.

Preparing Your Recruitment Data for Tableau

Your dashboard will only be as good as the data you feed it. Most recruitment data lives in an Applicant Tracking System (ATS) like Greenhouse, Lever, or Workday. You'll typically need to export this data as a CSV or Excel file.

Alternatively, if you're a smaller company or just starting, you can manage this in a well-structured Google Sheet or Excel workbook. Whichever you use, make sure your data is clean and organized with clear column headers like:

• Candidate ID
• Job Posting ID
• Job Title
• Department
• Recruiter Assigned
• Application Source (LinkedIn, Referral, etc.)
• Application Date
• Phone Screen Date
• Interview 1 Date
• Offer Extended Date
• Offer Accepted Date
• Candidate Stage (Screening, Interview, Offer, Hired, Rejected)

Step-by-Step: Building Your Dashboard in Tableau

Once your data is ready, it's time to build your visualizations. We’ll create a handful of core charts that form the backbone of a great recruitment dashboard.

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 1: Connect Your Data

Open Tableau and connect to your data source. Under the "Connect" panel on the left, choose "Microsoft Excel," "Google Sheets," or the appropriate server connection for your database. Select your file and Tableau will display your data fields in the "Data Source" tab.

Step 2: Create a Recruitment Funnel Chart

The funnel is the heart of your dashboard. A simple bar chart is often the clearest way to visualize it.

1. Go to a new worksheet (Sheet 1) and name it "Recruitment Funnel."
2. Drag your Candidate Stage field to the "Columns" shelf.
3. Drag the Candidate ID field to the "Rows" shelf. By default, Tableau will likely set this as SUM(Candidate ID), which isn't what we want.
4. Click the dropdown arrow on the "Candidate ID" pill in the "Rows" shelf, go to "Measure," and select Count (Distinct). This ensures you're counting each candidate once.
5. Sort the stages in the correct funnel order. You can drag and drop the stage names on the axis to reorder them manually (e.g., Application > Screening > Interview > Offer > Hired).

You now have a basic funnel chart showing how many unique candidates are in each stage.

Step 3: Calculate Time to Fill

Next, let’s calculate one of your most important efficiency metrics. This requires creating a "Calculated Field."

1. In the top menu, click Analysis > Create Calculated Field.
2. Name the field "Time to Fill."
3. Enter the following formula. This calculates the number of days between the application date and the offer acceptance date.

DATEDIFF('day', [Application Date], [Offer Accepted Date])

Now you can create a chart showing the average time to fill by department.

1. Create a new worksheet named "Avg Time to Fill."
2. Drag Department to the "Columns" shelf.
3. Drag your new Time to Fill calculated field to the "Rows" shelf.
4. Right-click the "Time to Fill" pill in the "Rows" shelf and change the measure from "Sum" to Average.

Step 4: Visualize Source of Hire

Find out where your best candidates are coming from with a simple bar chart. A pie chart can also work here if you have only a few sources.

1. Create a new worksheet named "Source of Hire."
2. Drag Application Source to the "Rows" shelf.
3. Drag the Count (Distinct) of Candidate ID to the "Columns" shelf.
4. Sort the bars from highest to lowest to quickly see your top-performing channels.

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 5: Assemble and Add Interactivity

Now, let's bring it all together into a cohesive dashboard.

1. Create a new Dashboard by clicking the icon at the bottom of the screen (the one showing four squares).
2. Drag your worksheets (Recruitment Funnel, Avg Time to Fill, and Source of Hire) from the left pane onto the dashboard canvas. Arrange them how you see fit.
3. Add Filters. This is what makes a dashboard truly useful. On any of the worksheets you've added, click the dropdown arrow and select Filters, then choose the field you want to filter by, like Department or Job Title. Then, on the filter card that appears on the right, click its dropdown and select Apply to Worksheets > All Using This Data Source. Now, when you filter by one department, all the charts on your dashboard will update simultaneously.
4. Finally, you can click on any chart and find the "Use as Filter" icon (it looks like a funnel). Activating this will allow you to click on a bar - for example, the "Referral" bar in your "Source of Hire" chart - and the rest of the dashboard will automatically filter to show data just for "Referral" hires.

Tips for an Effective Dashboard

Building the charts is only half the battle. Presenting them effectively is what drives action.

• Know Your Audience: Executives might just want high-level numbers like overall Time-to-Fill and Cost-per-Hire. Recruiters, on the other hand, will want to drill down into the performance of individual roles. You might need different versions of the dashboard for different stakeholders.
• Keep it Clean: Avoid cramming too much into one view. A cluttered dashboard is an ignored dashboard. Focus on 4-6 key visuals that tell the most important story.
• Use Color Strategically: Use colors to draw attention. For example, in your "Time to Fill by Department" chart, you could create a calculation that colors any department with an average above 45 days in red.
• Tell a Story: Organize your visuals in a logical flow. Start with your overall recruiting funnel, then move to efficiency metrics, and finally, look at source quality. This guides the user through a logical analysis of the hiring process.

Final Thoughts

Building a recruitment dashboard in Tableau puts the power of data directly in your hands. It helps you move from gut feelings to data-driven strategies, allowing you to optimize your hiring process, allocate resources effectively, and ultimately find better candidates faster.

While powerful tools like Tableau offer deep customization, they also come with a significant learning curve involving data prep, calculated fields, and dashboard design. For teams that need answers quickly without spending a hundred hours learning a new BI tool, we built Graphed. You can connect your applicant tracking system or spreadsheet in seconds and simply ask questions like, "Show me a chart of time to hire by recruiter for last quarter" or "Create a dashboard showing our entire recruitment funnel." Graphed generates interactive, real-time dashboards for you instantly, freeing you up to make decisions instead of wrestling with software.