_Navigating Success with KPIs in Jira

Project Background

For an esteemed luxury brand renowned for its expertise in high-end watches, jewelry, fashion, and accessories, operating globally across Europe, Asia-Pacific, North and South America, and the Middle East, TT PSC collaborated to enhance their operational efficiency. The luxury brand, boasting nearly 34,000 employees worldwide and generating an impressive 19.95 billion euros in revenue as of March 2023, sought a solution for automating the calculation of Service Level Metrics from Jira issue information.

TT PSC developed a custom report plugin, enabling automatic calculation and persistent tracking of various metrics throughout the fiscal year. This solution streamlined the process, providing a user-friendly interface within Jira and effortlessly generating Excel summaries.

Business Challenges

1. Framework for dynamically adding SLA metrics without complex development, addressing evolving calculations with various JQL results and custom functions, is a must.
2. A solution is required for the automatic generation and secure storage of SLA metrics at each month-end, ensuring timely and accurate historical data.
3. Visualizing metrics data for the entire fiscal year with dynamic filter parameters should be available, adding complexity to data representation. Additionally, there was a requirement to save this information conveniently in custom Excel sheets for comprehensive analysis and reporting.

Solutions

Introducing a groundbreaking Jira report plugin, TT PSC harnessed Atlassian SDK, Java, and Apache Velocity to implement the following features:

• Graphical reports – users can now effortlessly showcase graphical representations of their reports.
• New metrics integration – the solution seamlessly integrates new metrics by configuring the database with simplicity.
• Automated calculations and export – the plugin autonomously performs intricate metric calculations and supports custom Excel sheet exports.

Additionally, a specialized REST API empowers users to conveniently generate reports on a tailored schedule, amplifying Jira’s reporting functionalities and adaptability.

Results

The custom Jira plugin provides a tailored reporting engine, seamlessly managing intricate calculations and automating tasks for timely reporting. It excels in automating SLA metric generation, ensuring precise historical data storage for an efficient and credible reporting system.

Addressing data complexity, the plugin effortlessly visualizes metrics data for the entire fiscal year with dynamic filter parameters. This dynamic representation adds depth to data analysis, offering insights into trends and patterns.

In essence, the custom Jira plugin is a robust solution that simplifies processes, automates tasks, and enhances data visualization, aligning seamlessly with the company’s reporting needs.