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.
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