At my previous company we were looking for an open source Web Based Business Intelligence program that integrated with our datastore (MySQL). One night I poured through a bunch of different solutions and came up with a list of full solutions to partial solutions that may work. Metabase was a no-brainer since we needed to deploy via Docker and they already had an image available. Go Metabase!! After installing and evaluating it on Aptible we knew it was a solution that provided us with instant results. As you can tell I'm a fan of Metabase, but this blog post isn't about Metabase, but about the other solutions that may also work.
If I had to get a paid solution I would be looking at these two: Looker and Periscope.
Below is a list of my notes that I took while looking around at other BI programs:
# Business Intelligence
https://www.cloud9charts.com/
https://rstudio.github.io/shinydashboard/
http://shiny.rstudio.com/
https://plot.ly/
http://fnordmetric.io/ (abandoned?)
https://www.viurdata.com/
http://redash.io/
http://www.metabase.com/
https://github.com/uwdata/lyra
statsd + https://www.librato.com/
http://ankane.github.io/chartkick/
http://www.meteorite.bi/products/saiku
## ETL:
(workflow) https://github.com/spotify/luigi
http://dataducketl.com/ + https://github.com/DataDuckETL/DataDuck
Apache Nifi (ETL tool) + Metabase = http://community.pentaho.com/
(Ruby ETL process example): http://engineering.hoteltonight.com/ruby-etl-with-ironworker-and-redshift
## ETL DB?:
http://druid.io/
## Multi-datasource querier:
https://drill.apache.org/
http://calcite.apache.org/
https://prestodb.io/ (facebook)
## dashboard:
https://github.com/ejdraper/chameleon + http://geckoboard.com/
https://shopify.github.io/dashing/ + https://github.com/Shopify/dashing/wiki/How-to%3A-send-mysql-data-to-your-widgets