Pentaho

 View Only

 Open Source BI Tool-"Pentaho Community Edition"- Features

  • Pentaho
  • Kettle
  • Pentaho
  • Pentaho Data Integration PDI
Ramesh Singh's profile image
Ramesh Singh posted 08-27-2018 06:18

Hi Team,

We are looking for open source BI tools to implement for our customer’s project. We found about Open Source BI Tools- “Pentaho Community Edition”

 

We are looking following information about Open Source BI Tool-Pentaho Community Edition.

 

  1. What are features available with free versions BI? We can see below BI features available with free versions. Please correct, if we have wrong information.
    • Ad hoc Analysis
    • Ad hoc Query
    • Ad Hoc Reports
    • Benchmarking
    • Budgeting & Forecasting
    • Dashboard
    • Data Analysis
    • Data Visualization
    • Key Performance Indicators
    • OLAP
    • Performance Metrics
    • Predictive Analytics
    • Profitability Analysis
    • Strategic Planning
    • Trend / Problem Indicators

2. How many business users can access this free Version BI tools?

3. Can this Free BI tool integrate with Microsoft technologies- asp.net mvc, webapi and Oracle database?


#PentahoDataIntegrationPDI
#Kettle
#Pentaho
Data Conversion's profile image
Data Conversion posted 08-30-2018 05:48

1-Technically you can do everything with CE. But the question is how easy;

In my point of view Pentaho EE  has 3 killer tool that CE hasn't

Dashboard Designer,

Interctive Reports,

Analyzer

Without these tools you may need somewhat programmer skills like as JQuery, XML, Javascript , CSS , maybe xAction ...

Also you may have difficulty to provide some functionalities that business users claims.

You can check full EE-CE comparision from here: https://partners.pentaho.com/wp-content/uploads/Pentaho-CE-vs-EE-Comparison.pdf

Moreover, Pentaho CE documentation a bit problematic ( Some topics refers to EE not CE)

2-No limitation

3- Yes . In that case no difference between CE EE

Dan Keeley's profile image
Dan Keeley posted 08-30-2018 08:37

Just to be clear, CE version has no equivalent of dashboard designer (aimed at business users) but does have CDE which is aimed at developers building beautiful dashboards.  There may be a plugin from ivy that does something similar but i don't remember.

CE has Saiku which is near as damnit as good as analyzer.

CE also has WAQR plugin on the marketplace, which is equivalent /predecessor to PIR.

Virgilio Pierini's profile image
Virgilio Pierini posted 08-30-2018 09:04

Last PCM we had a presentation from SPEC INDIA of their Self Service BI plugin. This is not exactly a Dashboard composer -if I remember correctly it accesses datasources but does not integrate existing CDF reports- but I guess that many times the idea behind Dashboard Designer is to have a mashup with connected (POV) elements.https://github.com/SPECUSA/SelfServiceBI/raw/master/User_Guide-Self_Service_BI.pdf/

Maybe it has more features than needed but I see it's reported as mature release. Here is the link https://github.com/SPECUSA/SelfServiceBI/raw/master/User_Guide-Self_Service_BI.pdf/

Hope this helps

Virgilio

Data Conversion's profile image
Data Conversion posted 03-22-2019 15:06

Hi Dan,

I don't find WAQR in the marketplace. I do find WAQE. But it only gets a 2/4 rating. Not too eager to suggest this to my clients... Talking about my clients in this case: hey are really not technical and do need a self-service tool. They have Saiku and they already use the Mondrian cubes through xmla in MS Excel. But they want to make simple lists and interactive reports themselves. (And can't / don't want to write SQL on the database.)

Any other suggestions?

Thanks,

Sandra

Related Content