Business Intelligence Time Tracking Report
2025 Jira Time Tracking Goal
Executive Summary
Report Purpose
This report shows the time spent on Non-Project tasks for the year 2025. The goal of the project was to reduce time spent on interruptions by doing the following.
Define interruptions.
Measure current time spent on interruptions using Jira.
Implement plan to reduce time spent on interruptions after consulting with team.
Measure time spent on interruptions after implementing the new solutions.
First, we defined an interruption as a task that is not connected with one of our current projects. In Jira we did this by creating Epics where we would place non-project related issues. To measure the time spent we began using the Time Spent field on issues in Jira. After discussion as a team, we implemented a simple plan to help reduce time spent on interruptions.
Estimate how long a task will take. If it will take more than 4 hours, it should be routed though the manager as a new project rather than a simple task.
Attempt to tackle all extra tasks during a scheduled time during the week.
Log all tasks assigned in Jira
Result and Conclusions
Based on the available data, we can see that we managed to both reduce time spent on interruptions and the number of interruptions we received. We must then conclude that the solution agreed on by the team has had a positive impact on the BI Team’s time spent on interruptions.
Analysis
The analysis is split into 3 parts:
Estimated Time: This uses the mean time spent on tasks with data to estimate time spent on tasks that do not have time spent data in Jira.
Exact Time: Represents only the raw time logged in Jira.
Number of Interruptions: This shows the total number of interruptions as defined as non-project tasks.
Data is sourced directly from Jira records that have been placed in the data warehouse (fact_jira_issues_new).
1. Estimated Time Spent
The following visualizations show the estimated hours spent on non-project work. This metric compensates for unlogged time by applying standard duration values to identified non-project tasks. It is clear that time spent on unplanned tasks is estimated to have decreased as the year progressed.
2. Exact Time Logged
This section displays only the raw timespent data recorded in Jira without any imputation for missing logs. This represents the confirmed billable/utilized hours. The same pattern of decreased hours spent as the year progressed is seen here.
3. Number of Interruptions
This section displays the number of interruptions throughout the year. Each Jira issue associated with the Task epics are counted here.
