How to Create a Project Portfolio Dashboard

A project portfolio dashboard gives you a high-level, bird's-eye view of all your company's projects in one place. Instead of getting lost in individual task lists and status updates, you see the bigger picture: which projects are on track, which are falling behind, and where your resources are actually going. This guide will walk you through exactly how to define your key metrics, gather your data, and build a powerful dashboard from scratch.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What is a Project Portfolio Dashboard (and Why Do You Need One)?

Think of it as the mission control center for your company's initiatives. A project portfolio dashboard consolidates an organization’s complete portfolio of projects into a single, interactive, and highly visual business intelligence tool. It tracks key performance indicators (KPIs) like budget, schedule, and resource allocation to give stakeholders a real-time snapshot of overall health and progress.

Without one, you're flying blind. Project managers are buried in details, and executives lack the visibility to make strategic decisions. This often leads to common problems:

• Resource conflicts: Your best developer gets assigned to three "high-priority" projects simultaneously.
• Budget overruns: Small overages on multiple projects add up to a major financial problem you only discover at the end of the quarter.
• Misaligned priorities: Teams spend weeks working on projects that are no longer aligned with the company's strategic goals.

A well-designed portfolio dashboard solves these issues by providing a single source of truth, helping you make informed decisions, identify risks early, and keep everyone aligned.

Key Metrics for Your Project Portfolio Dashboard

A dashboard is only as good as the data it displays. Clogging it with too much information can make it confusing and useless. Instead, focus on a handful of high-impact metrics that tell a clear story about project portfolio performance.

1. Project Health (Status)

This is the most universal metric, often visualized with a simple "Red, Amber, Green" (RAG) status. It provides an immediate, at-a-glance understanding of a project's condition.

• Green: On track, on budget, and progressing as planned. No major issues.
• Amber: Potential issues have arisen that may impact scope, schedule, or budget. Requires monitoring.
• Red: The project is significantly off track. It has major issues and requires immediate intervention.

Tracking the total number of projects in each category gives you a quick health check of the entire portfolio.

Graphed

Still Building Reports Manually?

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

Watch the Demo

2. Budget vs. Actual Spend

Are you spending money as planned? This metric compares the amount you budgeted for a project against what you've actually spent to date. Visualizing this with a bar chart for each project can quickly highlight where you’re over or under budget, allowing finance teams and project managers to adjust accordingly.

3. Timeline and Progress

It's vital to know if projects are on schedule. You can track this in several ways:

• Milestone Tracking: Shows the number of completed milestones versus planned milestones.
• Task Completion Rate: A simple percentage of tasks completed out of the total tasks (e.g., 75% complete).
• Estimated vs. Actual Timeline: A Gantt chart or timeline view that compares the original end date to the current forecasted end date.

4. Resource Allocation and Utilization

This metric helps prevent burnout and optimize team productivity. Resource utilization tracks how much of each team member’s available time is allocated to projects. A dashboard can highlight who is over-allocated (at 110% capacity, for instance) and who might have the bandwidth to help a project that's falling behind. This helps you balance workloads and plan future hiring.

5. Risks and Issues

Don't confuse project status with risks. A "Green" project can still have high-priority risks lurking. Your dashboard should include a section that lists the top open risks and unresolved issues across the portfolio, along with who is assigned to resolve them. This ensures critical blockers don't get overlooked.

Gathering Your Data: Creating a Single Source of Truth

The biggest challenge in building a portfolio dashboard is that your data is likely scattered everywhere - a project plan in Asana, a budget in a spreadsheet, timesheets in a different app, and bug reports in Jira. Before building anything, you need to consolidate this information.

The most straightforward way to start is by creating a "Project Master List" in a simple spreadsheet program like Google Sheets or Excel. This becomes your central database. Create a new sheet and set up columns for each key metric you want to track:

• Project Name
• Project Manager
• Project Status (Green, Amber, Red)
• Start Date
• End Date
• Planned Budget
• Actual Spend
• % Complete
• Key Risks

Your goal is to establish a routine where project managers update their entries in this central sheet on a regular basis (e.g., every Friday). Consistency is everything. If the data isn't reliable, the dashboard will be misleading.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Choosing the Right Tool for Your PMO Dashboard

Once your data is consolidated, you need to choose where to build your dashboard. You have a few main options, each with its own pros and cons.

1. Spreadsheets (Excel or Google Sheets)

Spreadsheet software is accessible, familiar to most people, and doesn’t add new costs. They are great for small teams or a simple portfolio.

• Pros: High flexibility, low cost, easy to start.
• Cons: Highly manual, prone to human error, dashboards are not truly real-time, and can become slow with large datasets.

2. Business Intelligence Tools (Power BI, Tableau, Looker)

BI tools are designed for data visualization. They can connect to multiple data sources (like your master spreadsheet) and create beautiful, interactive dashboards.

• Pros: Powerful and professional visualizations, ability to "drill down" into data, can be automated.
• Cons: Steep learning curve (can take hours to learn), and subscription costs can be high.

3. Dashboards in Project Management Platforms (Monday.com, Asana, Jira)

Most modern PM tools have built-in dashboarding features that pull directly from the project data within the tool.

• Pros: Data is always real-time, easy setup requires no integrations.
• Cons: Customization can be very limited, and you can’t easily pull in data from other sources (like financial data from a separate system).

Step-by-Step: Build a Basic Dashboard in Google Sheets

For this tutorial, we’ll use Google Sheets - it’s free and accessible. Let's create a simple dashboard based on our "Project Master List."

Step 1: Set Up Two Tabs

Create a new Google Sheet. Rename the first tab to "ProjectData" and the second tab to "Dashboard".

In the "ProjectData" tab, set up the columns we discussed earlier and fill them with sample project information. This is your raw data source.

Step 2: Create Summary Cards

In the "Dashboard" tab, we'll create high-level summary cards. Let's create a card for Project Status.

In a cell (e.g., A2), type "Green". In B2, use the COUNTIF formula to count how many projects are "Green":

=COUNTIF(ProjectData!C:C, "Green")

Repeat this for "Amber" and "Red". Now you have a live summary of overall portfolio health.

Next, let’s create a financial summary. In cell A5, type "Total Budget". In B5, use the SUM formula to total the planned budget column:

=SUM(ProjectData!F:F)

In cell A6, type "Total Actual Spend," and in B6, calculate the sum of actuals:

=SUM(ProjectData!G:G)

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Insert Visual Charts

Now, let's visualize our summary data.

For Project Health: Highlight your "Green," "Amber," and "Red" summary counts (cells A2 through B4). Go to Insert > Chart. Google Sheets will suggest a pie chart. Customize the colors to match the status for an intuitive visual.

For Budget vs. Actual: In your "ProjectData" tab, select the "Project Name," "Planned Budget," and "Actual Spend" columns. Go to Insert > Chart and choose a bar chart. This will create a powerful visual comparing planned vs. actual spend for every single project.

Move these charts to your "Dashboard" tab and arrange them neatly.

Step 4: Create a Project Timeline View

To get a simple Gantt-like view, go to your "ProjectData" tab and select the "Project Name," "Start Date," and "End Date" columns. Go to Insert > Chart and find the "Timeline chart" type. This will plot your projects against a calendar, showing durations and overlaps.

You now have a simple, functioning project portfolio dashboard that automatically updates as you change the data in the "ProjectData" tab!

Best Practices for an Effective Dashboard

• Know Your Audience: Executives need high-level summaries (like the pie chart and summary cards). Project managers may need more detail. Tailor the view to the user.
• Keep It Simple: Avoid clutter at all costs. Every chart and number should answer a specific, important question. If it doesn’t add value, remove it.
• Make it Visual: Use color, charts, and clear headings to make the information digestible. People should be able to understand the overall picture in less than a minute.
• Ensure Data Integrity: Your dashboard is useless if the data is old. Establish a clear process and owner for keeping the underlying data clean and up-to-date.

Final Thoughts

Building a project portfolio dashboard brings clarity and control to the chaos of managing multiple initiatives. It empowers you to move from a reactive state of fighting fires to proactively guiding your projects toward success, ensuring your team’s effort is always aligned with strategic goals.

The most tedious part of this process is often the manual work - pulling data from your CRM, project management tools, and financial software into one place. We actually built Graphed to remove this friction. Instead of juggling CSV exports, you can connect your systems directly, and then use simple, natural language to ask for a real-time portfolio dashboard that automatically updates itself.