Atlassian Analytics EAP Updates May 2022

[#1]

Our teams have been busy making some amazing updates based on your feedback thus far during our early access program! We’ve deployed lots of updates in the last two months and wanted to highlight some of the larger changes. Thank you for all of your feedback!

And for those that may have missed it, Atlassian Analytics was announced at the Team '22 conference! This blog post introduces the Atlassian Data Lake and Atlassian Analytics:

Thanks for being a part of the EAP and helping us shape the release of this new offering.

Recently Shipped

Project Selection for Atlassian Data Lake Connections

Thanks to the amazing feedback that you all have provided, we are excited to announce a new change in Atlassian Analytics! Project selection is now available when connecting Atlassian Analytics to the Atlassian Data Lake. This new feature gives organization admins the ability to include or exclude projects from each Jira instance when setting up a new connection to the Atlassian Data Lake.

Previously, organization admins could only select which product instances were included in an Atlassian Data Lake connection. This meant that all projects on that instance were automatically included. By popular demand, we've updated the Atlassian Data Lake connection process to include a step that allows users to select the projects that they want to be brought into Atlassian Analytics.

Starter dashboard improvements

You’ve all provided great feedback on our starter dashboards! We’re determined to make these dashboards as valuable as possible, so we’re introducing some improvements.

• Created two new dashboards

  • Jira Software - Simple Project Overview

  • Jira Software - Issues Overview

• Published starter dashboard documentation

To get the improved starter dashboards, create a new data source connection to the Atlassian Data Lake. We cannot push these changes to the existing starter dashboards in your workspace.

Data Lake Changes

• Primary keys have been added to most tables making getting a “count” of rows easier

• Foreign keys have been improved to allow easier use of Visual SQL

Coming Soon

Data Model Updates

Atlassian Data Lake is at the heart of Atlassian Analytics, containing cross-product, pre-modeled data that enables you to power your analytics and insights. Based on the feedback we have received, we have been updating our data models in order to make it easier for you to find the data you need and use it for your analysis with as little effort as possible. Some of the changes we have made will enable you to create dashboards such as flow analytics using just the no-code Visual SQL mode in Atlassian Analytics! Other improvements include:

• More comprehensive Jira Issue and Jira Issue Field tables

• New tables including Jira Issue Cycle Time, Jira Issue Status History, and other Jira Service Management specific tables

Additional Product Data

Finally, we are excited to announce that we are working on adding several products to the data lake. Opsgenie, Insight, and additional user data will be added to the lake in the coming weeks. We will post community updates when this data becomes available.

[Esther Strom]

Will sprint data be added to the available tables any time soon? The biggest request we get from users is more robust sprint reporting than what's built in at the project level, and at this point although we have this amazing product, we still have to tell them that we can't provide that info.

[Ben Jackson]

@Esther Strom we are working on that right now and expect to have the Sprint data in the Lake and tested likely in June.