Home → Projects → ← Back → Project Online Reporting Site – Executive Project Dashboards

Project Online Reporting Site – Executive Project Dashboards

Technical Program Manager

💼 Completed
🔧 Agile
Skip to main content

Project Overview

I led the setup of a reporting site that integrated directly with Microsoft Project Online. The system automatically pulled project data, transformed it, and pushed it into an internal portal designed for executives. The goal was to replace manual reporting with an automated, near real-time view of program health.

The reporting site enabled leadership to track project progress, compare planned versus actual timelines, and visualize resource allocations and milestones. This improved executive visibility and reduced reporting turnaround time from days to minutes.

Challenges & Solutions

Challenges

Project data in Microsoft Project Online was not easily consumable for executives.
Manual reporting processes were slow and error-prone.
The reporting environment required stable infrastructure (servers, IIS, DB) before automation could run.
Limited ability to compare planned vs. actual data across multiple projects.

Solutions

Designed and implemented a structured server setup (staging and production) to host the reporting portal.
Built automated data pipelines from Microsoft Project Online into the internal reporting site.
Established work breakdown structures for setup tasks (server build, IIS configuration, DB setup, patching).
Delivered reports with planned vs. actual timelines, task breakdowns, and project variance metrics for executives.

Lessons Learned

Automating reporting pipelines significantly reduces turnaround time and ensures accuracy.
Having a dedicated reporting environment gives executives confidence in the consistency of data.
Tracking effort and actuals during infrastructure setup provides valuable insight into resource requirements for future deployments.