How to Create a Project Management Dashboard in Tableau

Trying to keep track of every moving part in a project can feel like a full-time job in itself. A well-designed Tableau dashboard brings all your project data into one clear, visual command center, helping you spot bottlenecks and track progress instantly. This guide will walk you through building a project management dashboard in Tableau, step by step.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Use a Tableau Dashboard for Project Management?

Ditching scattered spreadsheets or a flurry of status update emails for a centralized dashboard isn't just about looking organized, it's about making better decisions. A project management dashboard provides a single source of truth that helps you:

• See the big picture at a glance: Instantly check your project's health with KPIs for budget, schedule, and tasks.
• Identify bottlenecks early: Visualizations highlight overdue tasks or overloaded team members before they derail the entire project.
• Communicate progress effectively: Easily share a live, interactive view with stakeholders, keeping everyone on the same page without sending outdated reports.
• Track resources and budget: Monitor spending against your budget and see how team members are allocated across different tasks.

Step 1: Plan Your Dashboard Before You Build

Jumping straight into Tableau without a plan is a recipe for a confusing dashboard. Taking a few minutes to think through your strategy ensures you build something genuinely useful.

Define Your Audience and Their Questions

First, decide who this dashboard is for. Are you building it for your project team, executive stakeholders, or yourself? The audience determines the level of detail.

Next, define the key questions the dashboard must answer. This moves you from building random charts to creating a focused-decision making tool. Good questions include:

• Are we on schedule to meet our deadline?
• Are we staying within budget?
• Which tasks are currently blocked or overdue?
• Does any team member have too much work?
• What is the overall completion status of the project?

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Identify Your Key Metrics (KPIs)

Based on your questions, pick the specific metrics that will provide the answers. Common project management KPIs include:

• Task Status: The number or percentage of tasks that are 'Not Started', 'In Progress', 'Completed', or 'Blocked'.
• Schedule Variance: A comparison between planned and actual timelines. At its simplest, this can be the number of tasks completed on time versus tasks that are overdue.
• Budget vs. Actuals: The amount of money spent compared to the amount that was budgeted.
• Resource Allocation: The number of tasks or hours assigned to each team member.
• Project Timeline: Key milestones and dependencies visualized over time, often with a Gantt chart.

Gather and Structure Your Data

Your dashboard is only as good as the data feeding it. Your project data might live in tools like Jira, Asana, Monday.com, or a simple spreadsheet. Regardless of the source, your data should be clean and structured in a tabular format, like a spreadsheet.

Make sure you have clear columns for essential information. Here’s a basic example of what your data structure might look like in an Excel or Google Sheet:

Example Data Structure:

Step 2: Connect and Prepare Your Data in Tableau

With a solid plan and clean data, it’s time to get into Tableau.

1. Connect to Your Data: Open Tableau and on the Connect pane, select your data source type. For our example, you’d choose Microsoft Excel. Navigate to your file and open it.
2. Check Your Data: Tableau will display your data on the Data Source tab. Make sure it has correctly identified the data types for each column (e.g., dates as dates, numbers as numbers). If a date is showing as a string (Abc), click the icon and change it to the Date type.
3. Create Calculated Fields: Calculated fields let you create new data from your existing data. For project management, they are extremely helpful. Go to the "Analysis" menu and select "Create Calculated Field." Here are a few useful ones:

• Days Overdue: This helps identify tasks that are behind schedule.
• Task Duration: For creating Gantt charts.

Step 3: Build Your Dashboard Visualizations

Now for the fun part: building the individual charts (which Tableau calls "sheets" or "worksheets") that will become your dashboard. Let’s create a few key visuals.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Chart 1: Project Timeline Gantt Chart

A Gantt chart is the cornerstone of project management, showing tasks over time.

1. Create a new worksheet and name it "Project Timeline."
2. Drag your Task Name dimension to the Rows shelf.
3. Drag your Start Date dimension to the Columns shelf. Right-click it and choose the exact date format.
4. Go to the Marks card dropdown and change the chart type to Gantt Bar.
5. Drag your "Task Duration" calculated field to the Size button on the Marks card.
6. You can also drag the Assignee dimension to the Color button to see who is responsible for each task.

Chart 2: Task Status Overview

A pie or donut chart gives a quick snapshot of where tasks stand.

1. Create a new worksheet named "Task Status."
2. Drag the Status dimension to the Color button on the Marks card.
3. Drag the Task ID dimension to the Angle button. Right-click it and change its measure type to Count (Distinct). This will count how many tasks are in each status category.
4. To label the chart with percentages, drag another copy of Task ID (Count Distinct) to the Label button. Right-click it, select "Quick Table Calculation," and then "Percent of Total."

Chart 3: Key Performance Indicators (KPIs)

Key metrics like "Total Tasks" or "% Complete" are best shown as big numbers at the top of your dashboard for immediate visibility.

1. Create a new worksheet and name it "% Complete."
2. Create a new calculated field called "Percent Complete" with the formula:

COUNTD(IF [Status] = "Completed" THEN [Task ID] END) / COUNTD([Task ID])

This divides the count of completed tasks by the total count of tasks. 3. Drag this new calculated field to the Text button on the Marks card. 4. Click the Text button to edit the label. You can increase the font size and add text like "Complete" below the number. Remember to format the number as a percentage. 5. Repeat this process for other KPIs like "Overdue Tasks" using your "Days Overdue" field.

Chart 4: Team Workload Bar Chart

This chart helps you see if any team member is a potential bottleneck.

1. Create a new worksheet and name it "Team Workload."
2. Drag the Assignee dimension to the Columns shelf.
3. Drag the Task ID dimension to the Rows shelf and change its measure to Count.
4. This gives you a simple bar chart. To add more detail, drag the Status dimension to the Color button on the Marks card. Now you’ll have a stacked bar chart showing the status of each person's assigned tasks.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 4: Assemble Your Dashboard

Once you have your worksheets built, it's time to bring them all together into a final dashboard.

1. Click the New Dashboard icon at the bottom of the Tableau window.
2. In the Dashboard pane on the left, you'll see all the worksheets you created. Simply drag and drop them onto your dashboard canvas.
3. Arrange the charts logically. A common layout is to place the high-level KPIs at the top, followed by the main Gantt chart, with supporting charts for status and workload below or to the side.
4. Add Interactivity: Select your "Task Status" pie chart. In the top-right corner of its container, click the small funnel icon to "Use as Filter." Now, when you click on a slice of the pie chart (e.g., "In Progress"), the other charts on the dashboard will filter to show data only for in-progress tasks. This makes it easy to drill down into specific areas of the project.

Final Thoughts

Building a project management dashboard in Tableau transforms your messy project data into a powerful tool for clarity and control. By planning your visuals, preparing your data correctly, and combining charts into a cohesive view, you can stay on top of timelines, manage resources effectively, and keep all your stakeholders informed.

While tools like Tableau are incredibly powerful, they come with a significant learning curve. You still have to manage data connections, create calculated fields, and design each visualization manually. We built Graphed to automate that entire process. Instead of spending hours building charts, you can simply connect your data sources from platforms like Asana, Jira, or Google Sheets and ask in plain English: "Create a dashboard showing our project timeline, task status by assignee, and overdue tasks." Graphed generates a live, interactive dashboard for you in seconds, saving you time for the work that matters most - actually managing the project.