Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Data Visualization for HDP and HDF scenarios

Solved Go to solution
Highlighted

Data Visualization for HDP and HDF scenarios

Rising Star

Hello. I would like to validate alternatives for *open source* and preferrably free visualization and reporting tools. I am aware of commercial alternatives, but I would like to double check for the best alternatives in the open source universe, both for HDP and HDF. These are the broad scenarios I need to address:

1) Traditional reporting; some popular choices could be Pentaho or SpagoBI.

2) Multi dimensional analysis; in the RDBMS world this could be mapped to Mondrian (ROLAP), and different visualizaiton interfaces like jpivot.

3) Real time analytics. Our first choice was Banana Dashboard, but we needed to tweak it a lot in order to provide the expected results.

Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Data Visualization for HDP and HDF scenarios

@Fernando Lopez Bello

  1. Traditional reporting tools you seem to have pretty well covered. The usual suspects: Pentaho, JasperReports, SpagoBI.
  2. For multi-dimensional analysis, you may want to look into Apache Druid. AirBNB Superset is a pretty popular data exploration platform for Druid available under the Apache License. Apache Kylin is also an option. Kylin provides direct support for standard tools such as Tableau and Microsoft Excel/PowerBI.
  3. In addition to Banana, Kibana from Elastic is a pretty popular dashboard for real-time analytics available under the Apache License. Impetus also offers a free version of its StreamAnalytix product, but not through an Apache License.

Hope this helps!

5 REPLIES 5

Re: Data Visualization for HDP and HDF scenarios

@Fernando Lopez Bello

  1. Traditional reporting tools you seem to have pretty well covered. The usual suspects: Pentaho, JasperReports, SpagoBI.
  2. For multi-dimensional analysis, you may want to look into Apache Druid. AirBNB Superset is a pretty popular data exploration platform for Druid available under the Apache License. Apache Kylin is also an option. Kylin provides direct support for standard tools such as Tableau and Microsoft Excel/PowerBI.
  3. In addition to Banana, Kibana from Elastic is a pretty popular dashboard for real-time analytics available under the Apache License. Impetus also offers a free version of its StreamAnalytix product, but not through an Apache License.

Hope this helps!

Re: Data Visualization for HDP and HDF scenarios

@Fernando Lopez Bello Does this help? Is there more that I can help answer for you? If not, would you please accept my answer? Thanks. Tom

Re: Data Visualization for HDP and HDF scenarios

Rising Star

Thanks. How about Hue?

Re: Data Visualization for HDP and HDF scenarios

@Fernando Lopez Bello

If you are thinking Hue then I recommend to consider Ambari Views. Ambari Views are very powerful.

https://cwiki.apache.org/confluence/display/AMBARI/Views

Zeppelin is also an awesome visualization tool:

https://zeppelin.apache.org/

Re: Data Visualization for HDP and HDF scenarios

Thank you, Constantin!