To be able to analyse analyze Tempo apps data is necessary for the company owners to ensure making informed and timely decisions. That’s why it is important to integrate all Tempo plugins with business intelligence tools such as Power BISQL, and Power BI SQL Connector for Jira is the proper solution for such integration.
Exporting Tempo Timesheets data from Jira to Power BI SQL can help solving solve the following issues:
You can forecast project complete terms
It’s a common practice for the teams to underestimate the amount of time a project or certain tasks will take. With the data provided by time records in Tempo Timesheets, you can not only analyse analyze your previous experience , but also make assessments on how long it will take to finish the given task or project. You will have a basis for projections and can set more reasonable deadlines.
...
Analyse Tempo Timesheets data for billed hours by customers, projects, teams, assignees etc, as well as easily work with non-billed hours to minimise minimize the risks of underpayment or missed hours.
...
Tempo Timesheets fields are located in a separate tab:
...
Here is a full list of Tempo to
...
SQL fields available to export with
...
SQL Connector for Jira:
Field Name | Field ID | Field Type |
|---|---|---|
Tempo | ||
Tempo Account | <customfield> | String |
Tempo Iteration | <customfield> | String |
Tempo Team | <customfield> | String |
Tempo Team Role | <customfield> | String |
Teams | ||
Team Name | TEAM_NAME | String |
Team User Key | TEAM_USER_KEY | String |
Team User Name | TEAM_USER_NAME | String |
Team Role Id | TEAM_ROLE_ID | Int64 |
Team Role Name | TEAM_ROLE_NAME | String |
Tempo Work Attributes | ||
Work Attribute Name | WORK_ATTRIBUTE_NAME | String |
Work Attribute Type | WORK_ATTRIBUTE_TYPE | String |
Work Attribute Value | WORK_ATTRIBUTE_VALUE | String |
Work Attribute Required | WORK_ATTRIBUTE_REQUIRED | Boolean |
Worklog Id | WORK_ATTRIBUTE_WORKLOG_ID | Int64 |
...