How to Create a Project Management Dashboard in Looker

Juggling project tasks, timelines, and budgets often feels like trying to conduct an orchestra where every musician is playing from a different sheet of music. Your task data is in Asana, your budget is in a spreadsheet, and your team updates are in Slack channels. This article shows you how to bring all that data together by creating a project management dashboard in Looker, giving you a single, reliable view of everything that's happening.

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 Looker for Project Management?

While many project management tools have their own built-in reports, they often show you only a piece of the puzzle. Using a dedicated business intelligence tool like Looker lets you connect multiple data sources to get a complete picture. Instead of a static report, you get a live, interactive dashboard that your whole team can use to track progress, identify bottlenecks, and make data-informed decisions.

The core benefits include:

• A Single Source of Truth: Combine data from your project management app (like Jira or Trello), your financial software, and your time-tracking tool into one trusted dashboard.
• Deep-Dive Analysis: Empower your team to click into any chart or metric to explore the underlying data. Why is a project delayed? Click on the "Overdue" slice of a pie chart to see the exact tasks holding things up.
• Real-Time Updates: Looker connects directly to your database, so your dashboard is always showing the most current information. No more asking colleagues if they're looking at the right version of a spreadsheet.
• Easy Sharing and Collaboration: You can schedule dashboards to be sent to stakeholders via email or Slack automatically, keeping everyone aligned without extra effort.

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

Getting Started: Gathering Your Project Data

Before you can build anything in Looker, you need to get your project data into a database or data warehouse that Looker can connect to (like BigQuery, Snowflake, or Redshift). This is often the most challenging part of the process, but getting it right makes everything else dramatically easier.

Your primary data sources will likely be:

• Project Management Tools: Data from tools like Asana, Jira, Trello, Monday.com, or Basecamp. This includes details like task names, assignments, statuses, due dates, project names, and creation dates.
• Spreadsheets: Many teams track crucial information like budgets, resource allocation, and key milestones in Google Sheets or Excel.
• Time-Tracking Software: Data from tools like Harvest or Toggl can provide information on hours logged against specific tasks and projects.

You'll typically use an ETL (Extract, Transform, Load) tool like Fivetran or Stitch to pipe this data from your source apps into your data warehouse automatically. Once it’s there, your data team can model it using LookML (Looker’s modeling language) to define your key metrics and business logic. Ensuring you have a field for task status, assignee, due date, and completion date is the foundation for a great dashboard.

Defining the Key Metrics for Your Dashboard

A great dashboard tells a clear story. It should answer the most critical questions about your project's health at a glance. Avoid cluttering it with every metric possible, instead, focus on the ones that drive action. Here are the essential metrics every project management dashboard should have.

1. Task Status Overview

This is your at-a-glance view of the project's overall progress. It answers the question, "Where do things stand right now?"

• What it is: A count of tasks broken down by their current status (e.g., Not Started, In Progress, In Review, Blocked, Completed).
• Why it matters: It quickly shows if work is flowing smoothly or if there are a high number of blocked or stalled tasks.
• Best Visualization: A Pie or Donut Chart offers an intuitive way to see the proportion of tasks in each category.

2. Team Workload Distribution

This metric helps you ensure work is distributed fairly and identifies who might be overloaded or underutilized. It answers, "How is the work spread across my team?"

• What it is: A count of open or assigned tasks per team member. You can filter this for just "In Progress" tasks to see current capacity.
• Why it matters: Preventing team member burnout is crucial. This helps you reallocate tasks before someone becomes a bottleneck.
• Best Visualization: A Bar Chart makes it easy to compare workloads between team members.

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

3. On-Time Completion Rate

This metric measures your team's ability to meet deadlines and provides insight into planning efficiency. It answers, "Are we finishing our work on time?"

• What it is: The percentage of tasks completed on or before their due date. This is typically calculated as (Number of Tasks Completed on Time / Total Number of Tasks Completed) * 100.
• Why it matters: A consistently low rate might indicate unrealistic deadlines, resource shortages, or hidden roadblocks in your process.
• Best Visualization: A Single Value visualization (sometimes called a Scorecard or KPI card) is perfect for highlighting this key number. You can even show a comparison to the previous period.

4. Active & Upcoming Projects

Instead of a complex Gantt chart, you can create a simple list view of all ongoing projects and their critical upcoming dates. This answers, "What projects are we focused on and what’s next?"

• What it is: A table that lists each project, its owner, its overall status, and its next major milestone or deadline.
• Why it matters: It gives leadership a high-level overview without getting lost in individual task details.
• Best Visualization: A Table is best. You can use conditional formatting to color-code project statuses (e.g., green for On Track, yellow for At Risk, red for Off Track).

Building Your Dashboard in Looker: A Step-by-Step Guide

Once your data is modeled, building the dashboard is the fun part. Let’s walk through the creation of a few key components.

1. Create a New Dashboard

Start by creating a blank canvas. From your Looker homepage or a folder, navigate to New > Dashboard. Give it a descriptive name, like "Marketing Team - Q4 Project Health."

2. Build Your First Tile: Tasks by Status Pie Chart

Let's add our first report, or "Tile."

• In Edit Mode on your new dashboard, click Add Tile.
• Choose the relevant Explore where your task data lives (e.g., "Asana Tasks").
• From the left-hand field panel, click on your dimension for Task Status.
• Then, click on your measure for Task Count.
• Looker will automatically generate a visualization. Click the Visualization tab and select the Pie Chart icon.
• Customize it! Go to the Edit menu to change colors, labels, and the chart's title. Give it a clear title like "Current Task Statuses."
• Once you're happy, click Save, and the tile will appear on your dashboard. You can drag and resize it as you see fit.

3. Build Your Second Tile: Team Workload Bar Chart

Let's add another tile to see who’s working on what.

• Back in your Explore, clear the previous fields.
• Select the dimension for Assignee Name.
• Select the measure for Task Count.
• This time, add a filter. Find your Task Status dimension, click the "filter" icon next to it, and set the condition to "is not" > "Completed." This ensures you're only looking at active tasks.
• Under the Visualization tab, select the Bar Chart icon.
• Title it "Active Tasks per Team Member" and save it to your dashboard.

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

4. Add Interactive Filters to Your Dashboard

A static dashboard is useful, but an interactive one is truly powerful. Adding filters lets your team slice the data however they want.

• While in Edit Mode, click Filters at the top of the dashboard.
• Click Add Filter. Let’s add a filter for Project Name.
• Give the filter a clear title. In the "Model" and "Explore" fields, choose where your project name data lives.
• Now, the crucial step: linking it. On the Tiles to Update tab, find each tile you've created. For each one, select the field that the filter should apply to (in this case, the Project Name field in your data).
• Click Save. Now you'll have a Project Name dropdown at the top of your dashboard, and when you select a project, all your charts will update instantly. You can repeat this process for dates, assignees, or any other important dimension.

Best Practices for an Effective Dashboard

Creating the charts is one thing, designing a truly useful dashboard is another. Follow these tips to make your dashboard as effective as possible.

• Start with the Big Picture: Place your high-level KPIs, like On-Time Completion Rate, in the top-left corner. We read dashboards like a book, so the most important information should be front and center.
• Keep it Clean and Simple: Resist the urge to add too many charts. A crowded dashboard is confusing. Focus only on the metrics that prompt questions or decisions. You can always create more detailed reports for deep dives.
• Use Consistent Colors: If "In Progress" is blue on your pie chart, make sure it's blue on every other chart. Use colors intentionally to draw attention - for example, make "Blocked" a bright, concerning red.
• Add Context with Text Tiles: Use Looker's text tiles to add a dashboard title, a short description of what the charts mean, or a summary of key insights. This helps everyone understand the story your data is telling.

Final Thoughts

Building a project management dashboard in Looker turns scattered data into a powerful tool for clarity, alignment, and better decision-making. By centralizing key metrics in one live dashboard, you empower your team to proactively manage projects, tackle roadblocks, and consistently hit their goals.

Navigating the complexities of data prep and BI tools like Looker can still be a significant investment of time and resources. That’s why we created Graphed, which lets you bypass the steep learning curve. We make it easy to connect your sources like Jira, Asana, and Google Sheets, and then build the same live, interactive dashboard just by asking. You could simply say, "Show me a dashboard of my marketing projects, including tasks by status and on-time completion rate," and watch it get built in seconds. If you're looking for a faster way to get from data to decision, check out Graphed.