Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Which is the best tool for Jira enhanced reporting and BI (Dataplane? EazyBI?)

Fabian A. Lopez (Community Leader - Argentina, Florida, California)
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 3, 2018

I was recently asked for our management in how to extract the data residing in JIRA into excel and go over 1,000 rows. They would like to do Pivot Tables in excel and analyze the data differently as currently available with "out of the box" reports and gadget.

I shared some links (one of them with comment from Nic about how obsolete the data will be just before opening excel.)

So, I started some research and we will evaluate Arsenale DataPlane and EazyBI. Based on their marketplace descriptions they look very promising. And, I have to admit, I opened my mouth too early by saying... it looks good they have pivot table functionality, blah blah...

So the first disappointment was that Pivot Table functionality on DataPlan is not more than the already available two dimensions gadget in Jira (far from the concept of Pivot Table that we know from Excel). I probably missed something there.

Second disappointment, the need of additional resources to run EazyBI... I know, probably my mistake as well ;)

 

Now, we will start a formal evaluation of both alternatives and here is the question to start this discussion...

What BI tools do you use to analyze Jira data? Pros and Cons will help a lot as well.

Any other tool/approach we should consider?

Thanks! (BTW - we have Jira Server, Portfolio, JSD and Confluence)

7 comments

Comment

Log in or Sign up to comment
Tanya Gordon
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 15, 2018

Hello All!

I'll go first, hopefully more will follow so we can learn from our experience....

We use eazyBI extensively! It's super powerful but not that easy. For some basic xustoc reporting its pretty intuitive, but for anything a little more complicated you really need to know ypur way around it. 

EazyBI uses MDX syntax and is highly customizable. I guess for BI people it's pretty straight forward, but usually this falls into the local Jira admin's hands and there it has the pottpotential to become messy.

So, in summary, EazyBI is a really powerful amd customizable reporting tool for Jira. As far as the disadvantages go, I would say it's not that easy and also lacks some basic options like nested folders.

I'm looking forward to read about your experience with EazyBI and other alternatives for Jira reporting.

Like Yulia Fatkulina likes this
_Fabian A. Lopez
Contributor
September 15, 2018

Thanks @Tanya Gordon I am getting the same feedback from other users. Dataplane is more user friendly but it lacks some key functionalities and on the other hand EazyBI is powerful but requires an agressive learning curve. And what you mentioned is right.... the Admin team ends building reports for users and that is not a good thing to add on top of their other responsibilities.

We are evaluating the training of a core team that could support BI requirements from end users. We don't have a definition yet. I will let you know

Muhammad Ramzan(Atlassian Certified Master)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 5, 2018

Any success of BI tool evaluation for the JIRA, please need your advise too

Pablo Beltran
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 25, 2019

We sell SQL+JQL Driver the 2nd most popular reporting solution for the Server and Data Center according to the active instances.

 

The major difference with rest of the apps is that the SQL+JQL Driver brings full support for standard SQL for reporting on Jira and native JQL to search for issues in SQL queries.

So organizations can access Jira data safely respecting Jira permissions and avoiding all the drawbacks of accessing to the Jira native database without renouncing to the power of the JQL language.

 

From that you might like more or less the rest of the built-in features compared to other apps to build reports at the GUI level.

Like Sergey Aminov likes this
iofjuupasli
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 16, 2019

I compared several tools and found vizydrop very promising. It seems it was added recently to the marketplace, as there are no reviews.

Daniel Eads
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
December 10, 2019

Hey @iofjuupasli , welcome to the Atlassian Community. 

As part of our marketplace vendor and solution partner guidelines, we kindly ask that users call out if they work for a vendor/partner they are endorsing:

Identify yourself as a partner: Make sure the user is aware you are affiliated with a partner company; for example, by placing the name of your company in your user name in {curly brackets} or -dashes- (note that regular brackets no longer work and have been automatically converted to dashes). If you are mentioning your own products or services, make sure you include wording to make it clear that you are affiliated with the company providing those products or services.

By requesting vendor or partner access, you will also receive a badge on your profile that will identify you as a partner or vendor.

Since you appear to be affiliated with Targetprocess, I'd just like to ask that you call this out in future posts promoting vizydrop. Thanks!

Cheers,
Daniel | Atlassian Support

Like # people like this
Sami Linnanvuo {Screenful}
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
April 30, 2020

I suggest taking a look at our Analytics and Reports module by Screenful. It brings several new chart types such as line charts, dual axis line charts, scatter plot, stacked bar charts, and multi-bar charts. Feature include: 

- Mix & match data across Classic and Next-gen projects
- New List view chart for creating reports of issues
Export or share with a public link
- Compare multiple metrics in one chart (e.g. estimate vs actual)
- Advanced charts including multi-bar charts and dual axis line charts
- Track any of your custom fields, including the new Next-gen fields
- Easy to use editor, no coding or complex query language needed


custom1.png

Chris Cooke Old Street Apps
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
June 25, 2020

Hi Fabian,

It's been wonderful to demo Custom Charts for Jira Reports to most of the people commenting in this thread.

We made it easy to use, and with the powerful realtime 1 and 2-dimensional reporting features that people need in Jira dashboards and Confluence pages.

We're working hard to match all the powerful features of EAZY BI, but in the meantime, I'd argue we're already the best option for the reporting needs of most Jira users.

There's a playground to try it out for yourself in the link above.

Custom Jira Charts Dashboard June.png

Chris Cooke Old Street Apps
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
June 25, 2020

.

Jacek Debiec _Custom Charts_
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 25, 2020

.

TAGS
AUG Leaders

Atlassian Community Events