Redash was built to allow fast and easy access to billions of records, that we process and collect using Amazon Redshift ("petabyte scale data warehouse" that "speaks" PostgreSQL). Today Redash has support for querying multiple databases, including: Redshift, Google BigQuery, PostgreSQL, MySQL, Graphite, Presto, Google Spreadsheets, Cloudera Impala, Hive and custom scripts.
Redash consists of two parts:
Query Editor: think of JS Fiddle for SQL queries. It's your way to share data in the organization in an open way, by sharing both the dataset and the query that generated it. This way everyone can peer review not only the resulting dataset but also the process that generated it. Also it's possible to fork it and generate new datasets and reach new insights.
Dashboards/Visualizations: once you have a dataset, you can create different visualizations out of it, and then combine several visualizations into a single dashboard. Currently it supports charts, pivot table and cohorts.
Rattle 是一个用于数据挖掘的R的图形交互界面(GUI),可用于快捷的处理常见的数据挖掘问题。从数据的整理到模型的评价,Rattle 给出了完整的解决方案。Rattle 和 R 平台良好的交互性,又为用户使用 R 语言解决复杂问题开启了方便之门。Rattle 易学易用,不要求很多的R语言基础,被广泛的应用于数据挖掘实践和教学之中,在澳大利亚,有至少 15 个政府部门采用 Rattle 作为标准的数据挖掘工具
Bizgres project creates and builds a PostgreSQL "distribution", including experimental core mods, for an optimized Business Intelligence version. Downloads and Docs are on homepage www.bizgres.org
SpagoBI is also part of the FIWARE community, being the reference implementation of the Data Visualization GE. Check the FIWARE Catalogue entry for SpagoBI.
Metabase is the easy, open source way for everyone in your company to ask questions and learn from data.
Dashing is a Sinatra based framework that lets you build beautiful dashboards. It looks especially great on TVs.
Blazer Explore your data with SQL. Easily create charts and dashboards, and share them with your team.
Open Mining Business Intelligence (BI) Application Server written in Python
Drata is a self-hosted application that can be installed in your local network. It integrates with MSSQL and MongoDB instances for data analysis. It is a light weight Node JS application, that runs on Linux or Windows environment
BIRT An open source technology platform used to create data visualizations and reports that can be embedded into rich client and web applications.