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)