Resolving Project Management Challenges in Higher Education

Industry

Education

Service

Project Management

Technologies We Use

Power BI, SSIS & SSRS

Client History

The client is a university that handles multiple academic, administrative, and infrastructure projects. Each department initiated and handled projects independently. These departments do so mostly using separate tools and reporting methods.

As the number of steps grew, leadership struggled to maintain visibility across the project portfolio. Without centralized reporting, decision making became reactive rather than strategic.

Challenges

The university faced several project and portfolio management issues.

  • No central source of truth for all active projects
  • Limited visibility into project duration, start and end dates, and timelines
  • No executive level dashboards for oversight
  • Difficulty prioritizing projects across departments
  • Inefficient allocation of resources
  • Some staff remained underutilized while others were assigned to lower priority initiatives
  • Leadership could not properly identify which projects required immediate attention without consolidated reporting.

Goals & Objective

The university aimed to:

  • Centralize project portfolio management
  • Improve coordination across departments
  • Provide executive dashboards for real time project visibility
  • Optimize resource allocation
  • Enable data driven prioritization of initiatives

The objective was to introduce structure and transparency into project governance.

Solutions

Acme One implemented a structured project portfolio management framework supported by Microsoft tools.

Microsoft Project Server Implementation

Microsoft Project Server was deployed as the central project and portfolio management system. Organization wide users were onboarded to ensure consistent project planning, tracking, and reporting.

This provided a unified platform where all projects could be recorded and monitored.

Data Consolidation and Warehouse Development

A data warehouse was developed to consolidate project data. This ensured reliable and structured reporting across departments.

Executive Dashboards and Business Intelligence

Interactive dashboards were developed using Power BI, SSIS, and SSRS. These dashboards provided leadership with:

  • Overview of active projects by department
  • Project timelines and milestones
  • Start and end dates
  • Resource allocation insights
  • Portfolio level summaries

The dashboards allowed management to review project performance in a clear and accessible format.

Portfolio management with excel

Implementation

The solution included:

  • Deployment and configuration of Microsoft Project Server
  • Organization wide user onboarding and training
  • Development of a centralized data warehouse
  • ETL processes using SSIS
  • Reporting through Power BI and SSRS

The outspread was carried out in phases to ensure smooth adoption and minimal disruption to ongoing projects.

Result

Portfolio Visibility

Department Tracking

Better Prioritization

Resource Allocation

Faster Decisions

Project Governance

Outcomes

Portfolio Visibility

Department Tracking

Better Prioritization

Resource Allocation

Faster Decisions

Project Governance

What Our Client Says

Don’t just take our word for it. Hear what our satisfied clients have to say about their experience partnering with ACME ONE

“The implementation of Project Server and the executive dashboards has modified how we handle projects. We have clarity into our portfolio and can assign resources effectively."

Client Team

Get In Touch With Us Today

We’re here to help! If you have any questions or would like to discuss.

Contact Info

We’re here to help! If you have any questions or would like to discuss how our IT services and technology solutions can benefit your business,

Our Location

Meydan – Nad Al Sheba – Dubai – United Arab Emirates

Phone Number

+971 50 952 6681

Email Address

info@acme-one.com

Working Hours

Monday - Friday: 9.00 - 6.00
Saturday & Sunday (Closed)

Get In Touch

We’re here to help! If you have any questions or would like to explore how our custom software, digital solutions, and IT expertise can support your business growth.