Advanced Project Tracker: Integrating Automation and Analytics for Effective Project Management
| dc.contributor.advisor | Cruzado Vélez, Héctor J. | |
| dc.contributor.author | Rodriguez Cruz, Edwin R. | |
| dc.date.accessioned | 2025-08-07T18:39:45Z | |
| dc.date.issued | 2025 | |
| dc.description | Design Project Article for the Graduate Programs at Polytechnic University of Puerto Rico | |
| dc.description.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. | |
| dc.identifier.citation | Rodriguez Cruz, E. R. (2025). Advanced Project Tracker: Integrating Automation and Analytics for Effective Project Management [Unpublished manuscript]. Graduate School, Polytechnic University of Puerto Rico. | |
| dc.identifier.uri | https://hdl.handle.net/20.500.12475/3123 | |
| dc.language.iso | en | |
| dc.publisher | Polytechnic University of Puerto Rico | |
| dc.relation.haspart | San Juan | |
| dc.relation.ispartof | Engineering Management Program | |
| dc.relation.ispartofseries | Spring-2025 | |
| dc.rights.holder | Polytechnic University of Puerto Rico, Graduate School | |
| dc.rights.license | All rights reserved | |
| dc.subject.lcsh | Polytechnic University of Puerto Rico--Graduate students--Research | |
| dc.subject.lcsh | Polytechnic University of Puerto Rico--Graduate students--Posters | |
| dc.subject.lcsh | Polytechnic University of Puerto Rico--Subject headings--Unassigned | |
| dc.title | Advanced Project Tracker: Integrating Automation and Analytics for Effective Project Management | |
| dc.type | Poster |