This table is the basis for interaction between teams

[nusaiba129]

The path that the data takes

1. First, workflow data is collected in the JIRA task tracker. There, the service is divided into subtasks, and specialists note (log) the time spent on each stage of the work.

2. Data from JIRA goes into the team's Google spreadsheet. It collects data on all clients, working hours, acts, budgets. Expenses for contractors are also entered there.

3. Data from all Kompleto project teams is collected in a pivot table on Google Sheets. , departments, and the executive director who manages all processes.

4. The highest level is reporting for agency india consumer email list managers. The table shows revenue, expenses and profit (planned and actual) by quarter. This is what the management is primarily interested in:

208_5.png

Each team also has a tab in Power BI. This tool visualizes the results of work. It receives data from the pivot table. Based on this, Power BI calculates the efficiency and bonuses of employees.

Below is a detailed description of how information is collected at each stage.