Advanced Project Tracker: Integrating Automation and Analytics for Effective Project Management

Abstract

This project modernized a SharePoint-based Project Tracker tool to support improved task coordination and performance management within a water utility consulting context. Automation using Power Automate reduced delays in task status updates, while analytics through Power BI allowed data-driven insights into team workload and project distribution. A scoring model (PTS) was developed to measure task complexity and individual workload. Results showed increased reporting speed, improved balance in assignments, and reduced manual errors. The upgraded tool now enables faster decisions and better resource management.