Hi all, rookie questions, how good is Jira when it comes to reporting?

[SP]

I'm tasked with assessing Jira as a possible contender to bring our works on board and - surprise surprise - the team is sceptical. They love and rely heavily on advanced pivot tables they built in Excel, eg. hours spent on what, workload, resourcing, forecasting etc.

So, how powerful/flexible is Jira if we are to tailor dashboard gadgets and reports to meet the leaders' needs? I'm aware I'm not sharing what their needs are but a ballpark will do.

Any thoughts will be greatly appreciated.

Thanks, San

[Ste Wright]

Hi @SP 

Not a lot to work with here, so I'll provide a general answer...

---

General

Jira has multiple methods to visualise data...

• Dashboards, utilising gadgets
• Boards, to visualise the day-to-day movement of work items
• Multiple inbuilt reports you can utilise
• A powerful, inbuilt search feature
• The ability to export data to Excel/Google Sheets, either manually, or interlinked - see Excel here, and Google Sheets here

---

Atlassian Analytics

If your organisation is big enough (801+ users), you could also consider getting an Enterprise license, which comes with Atlassian Analytics - which provides a BI-style experience - including:

• Customisable data sets, using SQL
• Multiple options for visualising data
• Database connectors to incorporate non-Atlassian data
• Access to the Atlassian Datalake

See more information on this page

---

Other

If this isn't sufficient, Atlassian has thousands of Apps available in their Marketplace which can assist - for example...

• Custom Charts for Jira
• eazyBI Reports and Charts
• Power BI Jira Connector - provides a connector to channel data to Power BI

...or, check out lots of other options on the Marketplace

---

So there's lots of options here, depending on your needs.

You can allow Jira to do the heavy lifting for you, or you can utilise an App, or you can use Jira as a work management platform, and link to an offsite location - it's up to you :)

Ste