Jira Dashboard Example with Bold BI

Jira Dashboard Example with Bold BI

Jira software is a great tool for software teams and organizations to plan, track, and deliver solutions effectively. With Jira data, projects and issues can be tracked and business decisions can be made. To identify the actionable trends, Jira data needs to be visualized. Bold BI lets you turn your data into useful information by showcasing key metrics, such as issues resolved and created over time and the current status of issues, in individual widgets organized as Jira dashboards for your agile teams. This blog post will walk through the steps to connect your Jira data to Bold BI. The sample data used throughout this post is focused on the issue tracking module in the Jira project management tool.

First of all, if you are new to Bold BI, you must register a site to get started. Log into the site to see the home page.

Home page view of Bold BI
Home page view of Bold BI

You can create a new dashboard through any of the following ways:

We’ll go through each in turn.

Start with a built-in Jira dashboard template and connect to your Jira data

To create a new dashboard with a Jira dashboard template, click the Add icon in the left navigation bar.

Add button
Add button

This opens the sliding panel you see in the following image with multiple options for creating dashboards. Click Start from Template.

 

Create Dashboard menu
Create Dashboard menu

As a result, the Dashboard Templates window displays like in the following image.

Dashboard Template listing
Dashboard Template listing

Select Jira in the Data Sources listing to the left. Doing so will list the available Jira dashboard templates on the right.

Dashboard Template listing
Dashboard Template listing

Choose your preferred Jira template from the listing. Currently, only one template is available in Jira. More templates may be available in the future.

To preview the dashboard template, select Load with sample data. The notification banner on the right shows the dashboard preparation progress with sample data.

Jira dashboard template with notification banner showing progress
Jira dashboard template with notification banner showing progress

As a result, the Jira dashboard loads with sample data.

Jira dashboard template with notification banner showing progress
Jira dashboard template with notification banner showing progress

Once previewed, if you would like to visualize your own data, simply select Connect Your Data at the top of the dashboard. A window prompt like the one in the following image asks you to input your Jira domain and account details. This step is mandatory to authorize the connection to your account from your dashboard.

Authorization page for Jira connection
Authorization page for Jira connection

Enter the requested details and select Continue. The notification banner at top-right will show the dashboard preparation progress with your own data.

Jira dashboard preparation with own data after authorization
Jira dashboard preparation with own data after authorization

Once the preparation process is complete, the current page renders the Jira Dashboard with your own data. To share this dashboard with others, enable access permission to it for concerned users, copy the URL from address bar, and share it.

Start with your Jira data connected to a blank dashboard

To connect your data, in the home page view, select Data Sources and then Create Data Source.

Create Data Source from Home Page
Create Data Source from Home Page
Supported data connections in home page
Supported data connections in home page

Choose the Jira icon. A Jira connection window will prompt like the following image.

Supported data connections in home page
Supported data connections in home page

Provide a unique name for the data source and a description (optional). Enter your Jira domain URL, JQL or Raw Query, custom fields (if you have any) and Add authentication key and value under the Header(s) section (if you have any). Define the refresh settings to refresh the dashboard with the latest data updates on a schedule.

Set the data format of the result returned by the query from the Jira service. Set the authentication type, username, and API token for your Jira account.

Create Data Source window for Jira connection with required fields filled
Create Data Source window for Jira connection with required fields filled

Select Preview & Connect. A window will open and display the data results, categorized into table columns.

Jira table schema preview
Jira table schema preview

Choose the desired columns and select Connect to create a data source with them. Drag and drop the table and save data source by selecting Continue to Dashboard in the top-right corner menu.

Query designer
Query designer

The designer page will load so you can proceed designing your new dashboard with this data source.

Starting with a blank dashboard and connecting to your Jira data

Navigate to the New Dashboard card on the home page and select the Add icon available in the left navigation bar.

Add button
Add button

This opens a sliding panel with the following options for creating a dashboard. Click Start from Scratch.

New dashboard tile in home page
New dashboard tile in home page

The Start from Scratch window opens.

View in create dashboard window
View in create dashboard window

Enter a name and select Add and Design. The Dashboard Designer page opens with a new blank dashboard.

Blank dashboard in editing view
Blank dashboard in editing view

To create a new data source with a Jira data connection, select the data source icon on the right. Doing so will expand the data source panel.

An empty data source panel
An empty data source panel

Create a data source through any one of the following ways:

Creating a new data source connection from scratch

To create a new data source connection from scratch, select CREATE NEW in the panel. The DATA SOURCES panel lists the data connectors as shown in the following screenshot.

Supported data connections
Supported data connections

To more easily discover the Jira connectors in this list, choose the category Project Management.

Supported data connections under Project Management category
Supported data connections under Project Management category

Choose the Jira connector. The Jira data connection window will be displayed.

Default view of Jira data source window
Default view of Jira data source window

Provide the required details as done earlier in the Jira connection window.

Create data source window for Jira connection with required fields filled
Create data source window for Jira connection with required fields filled

Select Preview & Connect to get a window listing the data results categorized into table columns.

Jira table schema preview
Jira table schema preview

Choose the needed columns and click Connect to create a data source with selected table and columns.

Editing view of data source
Editing view of data source

Drag and drop the table, perform data modeling operations like column type conversion, column renaming, and column hiding, and save the data source by selecting Save in the top-right corner menu.

The Data Sources panel lists the created data source in the dashboard design view as shown in the following screenshot.

Data Sources panel with Jira data source added
Data Sources panel with Jira data source added

Creating new data source from existing or shared data sources

Find existing or shared data sources:

With the URL, https://<your-site-name>>/bi/en-us/data-sources, you can access all shared or previously created data sources. You can also navigate to this page by selecting the Data Sources icon (highlighted below) in the left-side panel.

Managed view of data sources
Managed view of data sources

From this view, you can also create a new blank dashboard with a data source chosen through the menu option available.

Create dashboard from data source in managed view
Create dashboard from data source in managed view

Data sources listing

The data sources listing exists in the dashboard design page in the right-side panel. Select Use Existing at the bottom of this panel to navigate to the already-created or shared data sources.

Highlighted view of use existing option in Data Sources panel
Highlighted view of use existing option in Data Sources panel

The panel shows the existing data sources.

Existing and shared data sources view
Existing and shared data sources view

Above all, the search box helps to filter out specific items based on the owner or the data source name from a larger list.

Select the data source and select ADD at the bottom of the panel. As a result, the DATA SOURCES panel will now display the selected data source.

Built-in sample data sources

Built-in sample data sources are available for use by available widgets. This can help beginners understand the functionality of the widgets and learn how these widgets can display the information that is fed to them.

To explore sample data sources, select EXPLORE SAMPLES in the DATA SOURCES panel.

Data Sources panel with option to explore sample data sources
Data Sources panel with option to explore sample data sources

Choose a data source based on your needs and select ADD. The DATA SOURCES panel will display the selected data source.

Data Sources panel with sample data sources
Data Sources panel with sample data sources

You can build dashboards focusing on modules, such as Jira agile dashboards, to monitor activity streams, task assignments, milestones, sprint progress, and more. To further expand your dashboard, you can explore the following links.

Creating dashboards

Adding a widget to design view

Assigning data to widgets

Configuring properties for widgets

Sharing dashboards

Conclusion

We hope this walk-through helps you connect your Jira data to Bold BI dashboards, build Jira dashboards, and visualize your project and team metrics. For more information about the features available in Bold BI dashboards, please read our blog post on the subject. For any questions or feedback, please post them in the comments section available below. You can also contact us by submitting your comments here, or if you already have an account, please log in to submit your support query. We are happy to assist you! Design with a smile!

Start your free 15-day trial today

 

Leave a Reply

Live Chat Icon For mobile
Live Chat Icon