The project aimed to automate project metrics within Jira by consolidating multiple projects into a centralized system, significantly enhancing the visibility and accessibility of key performance indicators. By streamlining data ingestion, unification, and modeling processes, we established a robust framework that allowed for the creation of customizable metrics tailored to the unique needs of various teams.
Furthermore, the integration of AI through Google Cloud's Vertex AI platform enabled predictive analytics, equipping project managers with tools for improved decision-making, resource allocation, and proactive issue resolution. By leveraging these advanced capabilities, the project set the stage for more efficient workflows and optimized performance across all projects.
Before Implementation
Despite having a wealth of operational information, the client struggled to organize it effectively to middle management.
Lack of centralized insights into project status, resource utilization, and progress tracking.
Inefficient communication and collaboration, impacting project outcomes.
Key Improvements
Middle management now accesses operational metrics, boosting their ability to monitor performance and satisfaction.
Enhanced decision-making through predictive analytics and real-time insights.
Optimized resource allocation and proactive issue resolution.
Project Overview
1.
Data Consolidation
Centralize data from multiple projects within Jira by migrating and unifying various data sources. This creates a single, accurate system of record for all project information, improving visibility and access for stakeholders.
2.
Metric Automation
Automate the creation of real-time, customizable project metrics. By developing automated data pipelines, the system can track key metrics such as project status and resource utilization, reducing manual effort and improving reporting accuracy.
3.
AI Integration
Integrate Google Cloud's Vertex AI to build predictive models that analyze historical data. These models forecast potential issues, resource needs, and trends, enhancing decision-making and optimizing resource allocation.
4.
Monitoring
Continuously monitor system performance and project progress to ensure efficiency. Make ongoing adjustments based on real-time data, improving the system's adaptability and overall effectiveness in managing projects.
Fivetran
BigQuery
VertexAI
DBT
Technologies used
David Weil
Owner - Phoenix Calibration
