CODEWITHSUNDEEP
sqlreportingbirtbusiness-intelligencedashboard
Marcin
Marcin

Reputation: 133

BIRT alternatives for reporting and visualisation services

Recently we have been struggling with finding alternative to our current reporting service - BIRT, developed by Eclipse.

We did some research, but each time we seem to be unable to fully comprehend capabilities of different solutions provided by numerous companies. First of all, why we chose BIRT:

Why we don't want BIRT anymore? - it refreshes basically on-click, - UI does not allow to work on generated report, i.e. - if you want to see chart for each country, you have to either generate report for each country or insert chart for each country within report design

Can you please share solutions you used during your career, their pros and cons? We need reliable reporting service for growing company, that would easily handle queries that take up to several minutes, with parameters and visualised data.

Currently we are trying out Grafana, but unfortunately it doesn't come even close to our requirements.

Upvotes: 4

Views: 8135

Answers (3)

Marcin
Marcin

Reputation: 133

In case if someone was wondering - we've stick with Microsoft PowerBI. It still has some cons, like pricing or having hard time with parametrized queries, but overall is rather easy tool to create nice visualizations of data, especially if you're planning to use OLAP cubes (as we did).

Upvotes: 0

Kaylon
Kaylon

Reputation: 91

I actually can really recommend http://www.metabase.com. Comes packed into Docker if you want, you can demo it within minutes.

Upvotes: 2

Carlos487
Carlos487

Reputation: 1489

I did some research on Reporting Alternatives a few months ago, I find out the following (not sorted in any order):

Jasper Reports JasperSoft Community

Pros

  • Free and open source
  • Multiplatform
  • Wide range of features
  • Different modes embedding, server, etc.

Cons

  • Migration between versions
  • Reliability when integrated into applications

SQL SERVER REPORTING SERVICES Reporting Services

Pros

  • Realiable
  • Nice set of features
  • Can generate desktop and web reports
  • Works on premises
  • Free (on Express edition) comes bundled with SQL Server Pro and up

Cons

  • SQL Server only
  • Windows Only

Power BI Power Bi

I would recommend to explore this alternative if it posible. In my opinion the results it produces are way better than the others.

Pros

  • Intuitive and easy to use
  • Can create complex and interactive reports
  • Can create advanced dashboards with ease
  • Ever growing set of features and OLAP analysis
  • Can integrate well with Machine Learning and other Azure services

Cons

  • Cloud based
  • Monthy fee depending on the amount of data

Pentaho Pentaho Community

Pros

  • Free and open source
  • BI focused
  • Advanced set of features

Cons

  • Steep learning curve

Disclaimer: This features list are based on my own experience and researh I encourage you to check the alternatives out to find out the best that suits your needs. Hope it helps.

Upvotes: 6

Related Questions