How to Create a Project Dashboard in Tableau

A static spreadsheet isn't enough to manage the moving parts of a modern project. To keep your team on track, on budget, and on time, you need a dynamic, visual way to see everything at once. This article walks you through how to build a powerful and interactive project management dashboard using Tableau, transforming your raw project data into actionable insights.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Use a Tableau Dashboard for Project Management?

While project management tools like Asana or Jira have their own reporting features, bringing your data into Tableau unlocks a new level of analysis and customization. It turns complex project data into a clear visual story that anyone can understand.

• See the Full Picture: Connect and combine data from multiple sources. Pull task data from Smartsheet, budget data from an Excel file, and resource data from a separate team spreadsheet - all into one unified dashboard.
• Get Answers Instantly: Instead of digging through spreadsheets, an interactive dashboard lets you slice and dice the data with a few clicks. You can filter by project phase, team member, or date range to get immediate answers.
• Communicate More Effectively: A visual dashboard is far more engaging and easier to digest than a tabular report. It makes it simple to share progress with stakeholders and highlight potential risks before they become major problems.

Planning & Preparing Your Data

Before you even open Tableau, a little planning goes a long way. A great dashboard starts with clear goals and clean data. Taking a few minutes to think through these steps will make the entire building process smoother.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 1: Define Your Audience and Key Metrics

First, ask yourself: who is this dashboard for, and what questions do they need answered? The metrics for a project team member will be different from those for an executive stakeholder.

• For Executives: They'll want a high-level overview. Focus on KPIs like Overall Project Timeline, Budget vs. Actual Spend, and Major Milestone Completion.
• For Project Managers: They need more detail to manage day-to-day operations. Track metrics like Task Completion Rate, Resource Allocation/Workload, and Upcoming Deadlines.
• For Team Members: They need to understand their own responsibilities. Focus on My Assigned Tasks, Task Status, and Individual Deadlines.

Step 2: Structure Your Data Source

Whether you’re using Excel, Google Sheets, or exporting a CSV from a tool like Monday.com, your data needs to be structured in a way Tableau understands. Aim for a simple, flat table format. Each row should represent a single task, and each column should represent a piece of information about that task.

A good structure looks like this:

• Task ID: A unique identifier for each task.
• Task Name: A short description of the task.
• Project Phase: The project stage this task belongs to (e.g., "Discovery," "Development," "Testing").
• Assignee: The person responsible for the task.
• Start Date: The planned start date.
• End Date: The planned completion date.
• Status: The current state of the task (e.g., "Not Started," "In Progress," "Completed," "Blocked").
• Budgeted Hours: The estimated hours for the task.
• Actual Hours: The actual hours spent on the task so far.

Keeping your data clean and organized like this will save you headaches once you're in Tableau.

Building Your Project Dashboard in Tableau: A Step-by-Step Guide

With our data ready, we can now start building the actual visuals. We'll create a few essential charts and then combine them into a single, cohesive dashboard.

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

Open Tableau and in the "Connect" pane on the left, choose your data source type. For this example, we’ll use "Microsoft Excel." Navigate to your project data file and click "Open." Tableau will display your data on the "Data Source" screen. If you have multiple tabs, you might need to drag the correct sheet onto the canvas. From here, you can click "Sheet 1" at the bottom to go to your first worksheet.

Step 2: Create a Gantt Chart for Your Project Timeline

A Gantt chart is the cornerstone of project management visuals, perfect for displaying your project's timeline and task dependencies.

1. Drag your Start Date dimension to the "Columns" shelf. Right-click it and make sure it's set to "Day" (as a continuous measure - the green pill).
2. Drag the Task Name dimension to the "Rows" shelf.
3. To sort the tasks chronologically, right-click "Task Name" in the Rows shelf, select "Sort," and sort by "Start Date" in ascending order.
4. In the "Marks" card dropdown menu, change the Mark type from "Automatic" to Gantt Bar.
5. We need to tell Tableau how long each bar should be. We'll create a calculated field to find the duration. Go to "Analysis" > "Create Calculated Field." Name it "Task Duration" and enter the following formula:
6. Drag your new Task Duration measure onto the "Size" property on the "Marks" card. Your Gantt chart bars will now extend from the start date for the correct duration.
7. For extra context, drag the Project Phase dimension to the "Color" property on the "Marks" card. This will color-code your tasks by their project stage.

Step 3: Track Overall Progress with a Donut Chart

A donut chart is a great way to show the percentage of tasks that are completed versus in progress at a glance.

1. Go to a new worksheet. In the "Rows" shelf, double-click and type AVG(0) and press Enter. Do this a second time so you have two copies of "AVG(0)" in a row.
2. In the "Marks" card, you'll now have sections for each "AVG(0)". Click on the second one.
3. Change its Mark type to a Pie chart.
4. Drag your Status dimension to the "Color" property.
5. Drag the Task ID measure to the "Angle" property. Right-click it and change it from "SUM" to "Measure" > "Count (Distinct)." Your pie chart is now sized by the number of tasks in each status.
6. Go back to the first "AVG(0)" section in the "Marks" card and change this to a Circle. Make it smaller than the pie and change its color to white to create the "hole" of the donut.
7. Finally, right-click the second AVG(0) pill in the "Rows" shelf and select Dual Axis. Synchronize the axes by right-clicking the axis and choosing "Synchronize Axis." You can also hide the headers to clean it up.
8. Drag Task ID (set to COUNTD) to the Label property of the circle to show the total task count in the center.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 4: Visualize Your Dashboard Worksheets and Filters

Now that we have created a few individual charts, we need to gather them and arrange them for optimal insights and storytelling.

1. Navigate to open a new dashboard and arrange our newly-created worksheets to start forming our dashboard. Now, let’s add the Gantt chart and our completion Donut chart that we just created.
2. Create a bar chart showing the breakdown of tasks by team member. Open a new Sheet and set Assignees on one axis, and use the count of Task IDs on the other, splitting the colored bars into the different Task Status to see your employee performance in detail.
3. Let's add another worksheet, where we measure the sum of Budgeted Hours versus Actual Hours. A dual timeline chart shows that perfectly. Create it by taking the Status Completion Date monthly on one axis, and the cumulative count of hours of our key fields for measurement on the other. Filter your tasks status so we only measure against Completed or In-review tickets which have an actual budget number assigned to them at that moment.
4. Finally, we will add two important key indicators every manager cares a lot about — our Overall budget vs actual spend, and the Average delay in days. This is great for a bird’s-eye view into team and progress performance. We are going to represent those with text value, a very simple sheet for a non-cluttered view for our stakeholders.
5. Arrange those elements on your new dashboard until the data story is flowing nicely, you can filter by team member and get their complete situation quickly!

Final Thoughts

Building a project dashboard in Tableau transforms your static project data into a dynamic, interactive tool for making smarter decisions. By clearly visualizing your timeline, progress, and resource allocation, you empower your entire team to stay aligned and proactively address challenges.

While powerful, building and maintaining custom dashboards in technical tools like Tableau can have a significant learning curve. To make this process feel less like a project in itself, we built Graphed. You can connect all your project management and marketing platforms, and then get real-time dashboards just by asking questions in plain English - no manual chart building required. It lets your team focus on the project insights, not the tool.