Alpha Serve Blog
We publish articles on different topics related to project management, agile methodology and philosophy, software and application development.
How to Analyze Jira Apps Data with Microsoft Power BI
Published: December 15, 2021
Updated: April 23, 2024
Author: Anna Odrynska
Chief Strategy Officer in Alpha Serve
Being a combination of technological services that work together to turn separate data sources into consistent insights, Microsoft Power BI is well-known for enabling entrepreneurs to plan and spend their time and finances reasonably. Combining Jira and Power BI to analyze data from Jira third-party apps like Projectrak, Tempo or Time in Status can help improve business processes even more. Thus, in this article, we'll dive deeper into why you need to analyze your Jira add-ons data and show you a specific way to connect and export Jira apps data to Power BI.
Here’s what we’ll cover in this blog post:
Why Should You Analyze Your Jira Apps Data?
Which Jira Apps Data Can Be Exported To Power BI And How?
Why Should You Analyze Your Jira Apps Data?
Which Jira Apps Data Can Be Exported To Power BI And How?
- Cost Tracker for Tempo Timesheets
- Tempo Planner – Resource Planning
- Tempo Timesheets – Time Tracking & Reports
- Insight – Asset Management
- Projectrak – Project Tracking for Jira
- Time in Status
- Advanced Roadmaps for Jira Software
Here’s what we’ll cover:
It is a table of contents. Click on the needed subheading and switch between parts of the article.
Why should you Analyze your Jira Apps Data?
Often, the Jira apps data can be fairly important. They contain information essential for comprehensive business analysis and realizing what steps to add to your business strategy. For example, by analyzing the data from your common use Jira apps in BI systems like Microsoft Power BI, you’d better understand the time spent, project's cost and revenue, thus gaining greater control, and making your business decisions based on actual insights.
This should not be overlooked, and a company should not be limited exclusively to the analysis of underlying Jira data. Now, on the Atlassian Marketplace, there are a lot of plugins that extend and enrich the functionality of Jira. And there is hardly a successful company that doesn’t use 3rd-party applications to improve their processes and organize efficient work. The value of the data that can be extracted from popular Jira apps is hard to underestimate, so why not get the most out of it?
This should not be overlooked, and a company should not be limited exclusively to the analysis of underlying Jira data. Now, on the Atlassian Marketplace, there are a lot of plugins that extend and enrich the functionality of Jira. And there is hardly a successful company that doesn’t use 3rd-party applications to improve their processes and organize efficient work. The value of the data that can be extracted from popular Jira apps is hard to underestimate, so why not get the most out of it?
Which Jira Apps Data Can be Exported to Power BI and How?
The data of the following apps can be precisely sent to Power BI:
How is it possible? The smoothest way is to start operating our Power BI Connector for Jira, an Enterprise Grade app that provides you with the ability to build complex models in Power BI Desktop, with proven scalability. This app is Cloud Fortified, which means it offers additional security, reliability, and support. Read more about the Atlassian Cloud Fortified apps program here.
First, it’s necessary to install our connector. Read next to understand how to do this.
Step 1
- Tempo Timesheets - Time Tracking & Reports
- Tempo Planner - Resource Planning
- Cost Tracker for Tempo Timesheets
- Time in Status
- Insight - Asset Management
- Projectrak - Project Tracking for Jira
- Advanced Roadmaps
How is it possible? The smoothest way is to start operating our Power BI Connector for Jira, an Enterprise Grade app that provides you with the ability to build complex models in Power BI Desktop, with proven scalability. This app is Cloud Fortified, which means it offers additional security, reliability, and support. Read more about the Atlassian Cloud Fortified apps program here.
From December 2021, Power BI Connector for Jira is FREE for instances with 10 or fewer users.
First, it’s necessary to install our connector. Read next to understand how to do this.
Step 1
- Go to the Jira Cloud Apps → Find new apps section.
- Type “Power BI Connector for Jira Alpha Serve” phrase. Press Enter.
- Click on Power BI Connector for Jira in the search results.
Find Power BI Connector for Jira on the Atlassian Marketplace
Step 2
Click Try it free to get a 30-day free trial license.
Click Try it free to get a 30-day free trial license.
Install Power BI Connector for Jira
Step 3
In this new window, click the button Start free trial. You'll be informed about the installation process started. Whether the installation is successful, you’ll get a notification, too.
In this new window, click the button Start free trial. You'll be informed about the installation process started. Whether the installation is successful, you’ll get a notification, too.
Start your free trial of Power BI Connector for Jira
Now let’s talk in detail about each application, the data of which can be transferred to your Power BI space by Power BI Connector for Jira.
Tempo Timesheets – Time Tracking & Reports
Tempo Timesheets is an easy instrument, letting an individual track the time spent on issues in Jira and even plan some future time. What’s important, with this app, managers can review and approve their team's timesheets, in bulk or individually. Thus, the Tempo Timesheets’ data is another source to get valuable insights on how to help teams work more efficiently or make employees more productive and happier at work.
Tempo fields are located in a separate tab. To take a look at and export the data, Tempo token is required. How to add Tempo Client ID? Just follow these few next steps.
Tempo fields are located in a separate tab. To take a look at and export the data, Tempo token is required. How to add Tempo Client ID? Just follow these few next steps.
Step 1. Go to the Apps in the main navigation menu and select the Tempo plugin from the list.
Step 2. Select Settings → OAuth 2.0 Applications → + New Application
Step 3. Fill the form as follows:
- Name: any name you’d like to provide
- Redirect URIs: https://powerbi-cloud-prod.alphaservesp.com/api/tempo/oauth
- Client type: Public
- Authorization grant type: Authorization code
Step 4. Copy the credentials: Client ID and Client secret
Step 5. Go to the Power BI Connector plugin → Tokens, select Tempo tab, enter Client ID and Client Secret. Click Validate&Save.
Step 6. Authorize Access at the next step.
From now on, all users who were granted permission to work with your Power BI Connector for Jira can select Tempo fields for export.
Cost Tracker for Tempo Timesheets
Cost Tracker for Tempo Timesheets is a simple and effective project cost and revenue tracking tool, with clear cost supervision for projects and budgets. The app tracks estimates, milestones, labor costs, fixed recurring expenses, billable and non-billable time, and revenue in real-time. Its data surely helps to deal with money completely and control your business’ financial part.
Cost Tracker fields are located in a separate tab. Don’t forget that Tempo token is required to view and export the data. To do this, follow these steps.
Cost Tracker fields are located in a separate tab. Don’t forget that Tempo token is required to view and export the data. To do this, follow these steps.
Tempo Planner – Resource Planning
Tempo Planner is a great resource planning instrument to guarantee competent resource deployment. The app enables users to schedule and report on resources and projects. It allows delegating managers or teams on projects and checking if workflows are realistic. With this app, you can make reports on your company's human resources and, after transferring Jira data to Power BI, understand your team’s professional needs better.
While using Power BI Connector for Jira, you’ll see that Tempo Planner fields are located in tab Tempo:
While using Power BI Connector for Jira, you’ll see that Tempo Planner fields are located in tab Tempo:
Insight – Asset Management
Insight - Asset Management app discovers and tracks assets to aid planning, audits, and compliance activities. With this, it’s also possible to link company assets and configuration items directly to issues to close requests faster. Any assets your company owns can influence the way you develop your business strategy, that’s why the Insight data is so important to complete your Microsoft Power BI reports.
Remember that in our Power BI Connector for Jira Insight fields can be found on a separate tab:
Remember that in our Power BI Connector for Jira Insight fields can be found on a separate tab:
To get access to the Insight fields, Jira API Token should be added. How to do this? Learn below in our short guidance.
Step 1. Go to Account settings.
Step 1. Go to Account settings.
Step 2. Click a Create and manage API tokens link in the Security tab.
Step 3. Click Create API token button.
Step 4. Enter an API token name and click Create.
Step 5. Copy your new API token. You won’t be able to see the token again.
Step 6. Enter the token into Power BI Connector for Jira > Tokens > Jira API token, click Validate & Save.
To use the Jira API token for data export:
In the Power BI Desktop, click Get Data → select OData feed, insert the copied Data Source link and click Ok.
In the Power BI Desktop, click Get Data → select OData feed, insert the copied Data Source link and click Ok.
At the next step
- Select Basic authentication.
- Enter your account email as a user name.
- Enter the API token into a Password field.
Projectrak – Project Tracking for Jira
The Projectrak - Project Tracking for Jira (formerly Profields) app helps track projects, gain control, and make decisions based on visual insights. With this application, you can create new properties for projects, such as their status, delivery date, or priority, to better track them. With many projects of various goals, the Projectrack data should be analyzed by the company’s owners or managers in Power BI, so it’ll help to keep your work consistent and clear.
Apparently, the fields are located in the Projectrak tab:
Please note: to select the fields for transfer, Jira Administration should add a Projectrak API key. The following steps will let you know how to do this.
Step 1. Go to Projectrak Settings > API Integrations.
Step 1. Go to Projectrak Settings > API Integrations.
Step 2. Click on the Create API key button.
Step 3. Enter any API key name and click Save.
Step 4. Copy the API key ID and API key and enter them into Power BI Connector > Administration > Projectrak, click Save.
Well done! From now on, all users who were granted permission to work with Power BI Connector for Jira can select Projectrak fields for export.
Time in Status
Time in Status enables you to easily create reviews that show how much time each issue spent on each status, assignee, or group. This is an easy tool to understand more about time-spending and, after transferring those Jira data to Power BI, to create full reasonable insights allowing you to make some specific changes in project planning.
To get access to the Time in Status fields, Time in Status token should be added. Follow these steps:
Step 1. Create a Token using this instruction: https://dev.obss.com.tr/confluence/display/MD/TiS+Cloud+-+API+Settings
Set Power BI Connector for Jira as a user.
Step 2. Copy the token.
Step 1. Create a Token using this instruction: https://dev.obss.com.tr/confluence/display/MD/TiS+Cloud+-+API+Settings
Set Power BI Connector for Jira as a user.
Step 2. Copy the token.
Step 3. Go to the Power BI Connector plugin → Administration, select Time In Status tab, enter the Token. Click Save.
From now on all users who were granted permission to work with the Power BI Connector for Jira can select Time in Status fields for export.
Advanced Roadmaps for Jira Software
Advanced Roadmaps (formerly Portfolio) is an agile roadmapping app, built for Jira Software. It allows users to coordinate and track work strategically across various teams and projects. You can plan based on capacity, track dependencies, manage competing priorities, and explore alternative scenarios. The data from Advanced Roadmaps is super-important for deliberate business planning and seeing ahead.
Advanced Roadmaps is available as part of Jira Software Premium.
While transferring the data with the help of Power BI Connector for Jira, please note that Advanced Roadmaps fields are located in the table Issue Custom Fields.
Advanced Roadmaps is available as part of Jira Software Premium.
While transferring the data with the help of Power BI Connector for Jira, please note that Advanced Roadmaps fields are located in the table Issue Custom Fields.
Final Words
In the progression of any corporate activity, there are many tools generating tons of useful data and information. To extract and investigate their data is a great benefit. Hence, by analyzing data of the applications listed above, company owners may make more mature choices and deliberate decisions, leading them to even bigger success. So, let that happen!
Related Topics
Related Topics