PMO Dashboard: A Project Manager’s Tool

ROLEFull-stack Engineer
DURATIONSept 2025 - Sept 2026
TEAM1 Full-Stack Developer, 2 Project Manager
TECH STACKNext.js, Express, Flask, Pandas, SpiraPlan, PostgreSQL, TailwindCSS, Google Cloud Console, Bruno

Overview

Project managers often struggle with inconsistent data formats, messy presentations, and text formatting when using spreadsheets for meetings. The PMO Dashboard automates data extraction from these spreadsheets and transforms the collected information into clear visualizations, consistent reports, and organized Kanban boards for tracking projects and their versions.

Problem

Before the PMO Dashboard, figuring out how a project was doing wasn't that simple. A lot of time was spent going through spreadsheets and different tools just to get a clear picture of the project's progress.

  • Scattered Project Data: Each team (QA, BA, PMO, and DEV) had its own Google Sheets, Excel files, and Spira tickets. There was no single place to check how everything was progressing.
  • Messy and Inconsistent Data: Since most of the data was entered manually, there were plenty of issues, such as:
    • Inconsistent date formats, invalid dates, or dates missing the year.
    • Bulleted notes pasted into activity cells, messing up rows and date alignment.
    • Duplicate entries, shifting rows, empty values like "None," and test builds that cluttered the records.
  • Separated Testing and Incident Reports: Important information, such as bug counts, burndown progress, and release status, was stored in Spira instead of being easily accessible alongside the team's daily tasks.
  • Hard-to-Spot Blockers: When a team needed help or ran into a problem, it could easily get buried somewhere in a spreadsheet instead of being highlighted where project managers could quickly notice and address it.

Solution

The PMO Dashboard provides a centralized platform that automates spreadsheet data extraction and organizes project information into clear visualizations, standardized reports, and Kanban boards.

It reduces repetitive manual work, improves data consistency, and makes project information easier to understand and monitor. By integrating multiple data sources, it also helps project managers access updated information more efficiently and reduces the risk of errors caused by manual data handling.