As a large, established automotive company, it is necessary to always keep track of varying prices for materials and goods per country and supplier. However, creating such sophisticated reports is time-consuming, so the manager hired an intern specifically to take care of this activity. As a result, data was cumbersomely transferred from Jira projects to Excel, merged, exported, and updated again.
As a large, established automotive company, it is necessary to always keep an overview of varying prices for raw materials and goods per country and supplier. The manual creation of such sophisticated reports is highly time-consuming, so the manager hired an intern specifically to handle this activity.
Weekly, the intern sat on a special management report. He ran a JQL in Jira, then exported it as a CSV. Then he added all the data into a special Excel sheet where different marcos were run. Often, master values had to be adjusted there, as the company dynamics were also reflected in Jira.
Screenshots were made of the charts created in Excel, which were transferred to a special PowerPoint file. Only after this step were the results to be presented to the next higher management level. Creating such a report took up to 6 hours a week.
Still, the risk of human error remained a constant factor. And what was to be done about last-minute changes? An Excel file doesn’t just automatically update several pieces of data at the click of a button.
That’s why the manager turned to Actonic. He had heard about our tool Report Builder: Timesheets and Data Analysis and asked if we could customize the add-on as an Atlassian Solution Partner.
And that’s exactly what we did. Working closely together, Actonic further developed the add-on to meet the customer’s requirements 100 percent. Now, reports on prices for different countries and suppliers are created and updated completely automatically. In individual training sessions, we demonstrated the handling of the new tool and remained in constant exchange to discuss further optimizations.
Fast delivery of error-free reports increases the efficiency and competitiveness of any company. However, what was particularly remarkable to everyone involved in this project was the highly positive user experience.
The earlier labor-intense reporting system, which was not up-to-date, prevented the company from achieving its maximum potential and the employees. In addition, a high investment of time, vulnerability to human error, and, last but not least, performance pressure due to constant updating characterized the reporting process.
“A whole new way of working and living,” is how the manager sums up his current situation thanks to Report Builder. Before implementing the tool, he could never be sure that the generated reports were up-to-date and error-free. Every change carried the risk of an error. Now, he confidently faces his manager to deliver high-quality reports on a regular basis.
The latter appreciates the immense optimization and has already spoken about the manager’s initiative in a board meeting.