How to Create a Call Center Dashboard in Tableau

Tracking the performance of a call center without a proper dashboard is like trying to navigate a city without a map. A well-designed dashboard transforms confusing raw data into a clear, at-a-glance view of your team's performance, customer satisfaction, and operational efficiency. This guide will walk you through the key metrics to track and provide a step-by-step process for building an interactive call center dashboard in Tableau.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

First, Identify Your Key Performance Indicators (KPIs)

Before you even open Tableau, you need to decide what you want to measure. A dashboard is only as good as the metrics it displays. Overloading it with vanity metrics will only create noise, while focusing on a few actionable KPIs can drive real improvement. Here are the must-have metrics for any effective call center dashboard.

Operational Efficiency Metrics

These KPIs tell you how effectively your team is managing its workload and resources. They are the backbone of a well-run call center.

• Average Handle Time (AHT): The average duration of a single call, from the time an agent picks up to the moment they finish the post-call work. A high AHT might indicate complex issues or agents needing more training.
• Average Wait Time (AWT) or Average Speed of Answer (ASA): This is how long customers wait in the queue before connecting with an agent. Long wait times are a primary driver of customer frustration.
• First Call Resolution (FCR): The percentage of calls where the customer's issue is resolved on the first try, without needing a follow-up. A high FCR is a strong indicator of both customer satisfaction and agent competence.
• Call Abandonment Rate: The percentage of callers who hang up before ever speaking to an agent. A high rate often points to unacceptably long wait times or confusing IVR (Interactive Voice Response) systems.

Agent Performance Metrics

These metrics focus on the productivity and effectiveness of individual team members. They're essential for coaching, training, and recognizing top performers.

• Agent Utilization Rate: The percentage of an agent's logged-in time that is spent on call-related activities (talk time, hold time, wrap-up time). This helps you understand if your staffing levels are appropriate.
• Calls Handled Per Agent: The total number of calls each agent manages over a specific period. It's a straightforward productivity metric but should always be viewed alongside quality metrics like FCR and CSAT.
• Adherence to Schedule: How well agents stick to their assigned schedules, including start times, breaks, and end times. High adherence is critical for ensuring you have enough staff to handle call volume projections.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Customer Satisfaction Metrics

Ultimately, a call center exists to serve customers. These KPIs measure how well you're meeting their expectations.

• Customer Satisfaction (CSAT): Typically measured through post-call surveys ("On a scale of 1-5, how would you rate your experience?"), this is the most direct measure of customer happiness.
• Net Promoter Score (NPS): This measures customer loyalty by asking how likely they are to recommend your company to others. While not strictly a call center metric, call center interactions heavily influence it.

Gathering and Preparing Your Data

Tableau needs structured data to create visuals. Your call center data likely lives in several places: a CRM like Salesforce, a phone system like Aircall or Talkdesk, or a helpdesk platform like Zendesk. The goal is to bring this data together into a single, clean file.

Your ideal dataset should be a flat file (like an Excel or CSV file) where each row represents a single call and each column represents a specific attribute of that call. Your columns should include fields like:

• Call ID (a unique identifier for each call)
• Agent Name/ID
• Call Date and Time Stamp
• Call Duration (in seconds)
• Wait Time (in seconds)
• Issue Type or Category
• Resolved on First Call? (Yes/No or 1/0)
• Abandonment Status (Yes/No or 1/0)
• CSAT Score (1-5)

Make sure your data is clean. This means standardizing date formats, checking for empty cells, and ensuring consistent naming conventions (e.g., all agent names are spelled the same way). A little prep work here saves a lot of headaches inside Tableau.

Building Your Call Center Dashboard in Tableau: A Step-by-Step Guide

With your data prepped and your KPIs defined, it’s time to build the dashboard. We'll go through building a few essential components and then assembling them into a final layout.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Connect to Your Data Source

Open Tableau Desktop. In the "Connect" pane on the left, choose the file type that matches your dataset (e.g., Microsoft Excel, Text File for CSVs). Navigate to your saved file and click "Open." Tableau will display your data on the "Data Source" tab. Double-check that Tableau has correctly identified your data types (e.g., numbers, dates, strings). If something looks wrong, you can click the icon at the top of a column to change it.

Step 2: Create Calculated Fields for Your KPIs

Many of your core KPIs, like FCR or Abandonment Rate, don’t exist as a single field in your data. You’ll need to create them using Calculated Fields.

Go to your first worksheet. In the "Data" pane on the left, right-click and select "Create Calculated Field." Let's create First Call Resolution Rate.

Example: Building First Call Resolution (FCR) Rate

1. Name the field "FCR Rate".
2. In the formula box, you'll need a formula that sums the "Yes" responses and divides by the total number of calls. It might look something like this:

SUM(IF [Resolved on First Call?] = "Yes" THEN 1 ELSE 0 END) / COUNT([Call ID])

1. Click "OK." Tableau automatically formats this as a percentage, but if it doesn't, you can right-click the new "FCR Rate" field in the Data pane, go to Default Properties > Number Format and choose "Percentage."

Repeat this process for other key metrics, like Average Handle Time (AHT):

SUM([Call Duration in Seconds]) / COUNTD([Call ID])

And Abandonment Rate:

SUM(IF [Abandonment Status] = "Yes" THEN 1 ELSE 0 END) / COUNT([Call ID])

Step 3: Build Your Visualizations (Worksheets)

Each chart or scorecard on your dashboard will live in its own worksheet. Let’s build a few essentials.

KPI Scorecards (The "Big Numbers")

1. Create a new worksheet and name it "AHT Scorecard."
2. Drag your "Average Handle Time" calculated field onto the "Text" box in the Marks card.
3. You'll see a single, large number. Click the "Text" box in the Marks card to format it. You can make the font bigger, change the color, and add text like "seconds" or "avg. handle time."
4. Repeat this process on new worksheets for your other main KPIs like FCR Rate, Abandonment Rate, and Average Wait Time.

Call Volume Over Time (Line Chart)

1. Create a new worksheet named "Call Volume Trend."
2. Drag "Call Date" to the Columns shelf. Tableau will likely default to showing YEAR(Call Date). Right-click it and choose "Month" or "Week" to see a more granular trend. For even more detail, you can select "Hour."
3. Drag "Number of Records" (or "Call ID," and change the aggregation to Count) to the Rows shelf.
4. Voilà! You have a line chart showing how call volume changes over time. This is invaluable for spotting daily, weekly, or seasonal patterns to inform staffing.

Agent Leaderboard (Bar Chart)

1. Create a new worksheet named "Calls by Agent."
2. Drag the "Agent Name" dimension to the Rows shelf.
3. Drag "Number of Records" to the Columns shelf.
4. Tableau will create an automatic bar chart. You can sort it by clicking the sort icon on the axis to easily see your highest-performing agents by volume. You could do the same for FCR or CSAT by agent.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 4: Assemble Your Dashboard

Once you’ve built all your individual worksheets, it’s time to bring them together into a coherent story.

1. Click the "New Dashboard" icon at the bottom of the screen (the one with four squares).
2. On the left side, you'll see a list of all your worksheets. Simply drag and drop them onto the dashboard canvas.
3. Arrange your visualizations logically. A common layout is to place the high-level KPI scorecards at the top for an instant summary. Below that, place trend charts like Call Volume. Finally, add more detailed breakdowns, like the agent leaderboard, at the bottom.
4. Pro Tip: Add Filters. Drag a field like "Call Date" onto the "Filters" pane. Add it to the dashboard by clicking the dropdown on the filter and selecting 'Add to Dashboard'. You can now filter all your charts by a specific date range, giving users powerful, interactive control. Do the same for "Agent Name" or "Issue Type."

Final Thoughts

Building a call center dashboard in Tableau transforms your operational data from a static spreadsheet into an interactive, analytical tool. It empowers managers to monitor performance in real-time, identify coaching opportunities for agents, and ultimately deliver a better customer experience. Setting it up correctly allows you to move beyond simply reporting numbers to truly understanding the story behind them.

While mastering a tool like Tableau is an incredibly valuable skill, the process of connecting data, creating calculated fields, and designing dashboards still takes quite a bit of time - time that busy managers often don’t have. For teams that need insights quickly, we created an alternative. With Graphed, you can connect your data sources in a few clicks, and then simply ask for what you want in simple English. You can say things like, “Show me my first call resolution rate by agent as a bar chart,” or “Create a dashboard showing average handle time and customer satisfaction trends for the past month,” and the charts and dashboards are built for you in seconds.