Bot for generating project activity reports
A bot for automating the preparation of weekly reports on tasks, progress, and employee effort for presentation to management.
Tasks
- Develop a Slack bot with support for a message template to trigger report generation
- Integrate with multiple Jira instances and synchronize sprints
- Extract tasks, time logs, and estimates for each employee
- Generate Excel files using `xlsxwriter` with pie and bar charts
- Support reports for multiple projects with aggregated statistics
- Automatically send the completed report to a Slack chat
About the Project
Previously, preparing weekly reports took team leads several hours: data was manually collected from Jira, compiled in Excel, formatted, and sent to management. We automated this process by implementing a Slack bot that generates a structured Excel document with visualizations of key metrics upon command.
The bot extracts task data from one or multiple Jira instances, synchronizes sprints, collects time logs, estimates, and task statuses, and creates charts for time, effort, and plan adherence.
The file is generated using xlsxwriter and sent directly to Slack as an attachment. It supports customizable parameters: dates, task ranges, and filters by projects and users.
Results
Challenges and Solutions
- Support for Multiple Jira Sources
- The bot’s interface allows specifying projects from different Jira instances, relevant for distributed teams. Sprints are synchronized, and data is aggregated automatically.
- Visualization Without Overhead
- Pie and bar charts clearly display effort distribution, task completion, and adherence to estimates, simplifying report comprehension for managers.
- Easy Activation
- The bot is triggered via a predefined message template in Slack.
Related Services
Outsourcing
Our team of skilled developers is ready to create websites and applications of any complexity. We build modern web solutions using cutting-edge technologies and architectural approaches.
Read MoreReady to discuss your project?
Describe your task, we will make a research and respond to you as soon as possible.