README.md

Awesome Business Intelligence

A curated list of awesome tools to interact with data. ToC split by SaaS and OSS (Open Source Software):

1. Monitoring & Alerting
2. SQL Client
3. Data Visualization
4. Data Integration
5. Data Modeling
6. ETL Orchestration
7. Data Platforms
8. Storage
9. Knowledge Management
10. Database Modeler
11. Data Discovery

• 1. Monitoring and Alerting

  • SaaS
    • intermix
    • Kiwi
    • PushMetrics
    • Revere

• 2. SQL Client

  • SaaS

    • DataGrip by JetBrains
    • DataRow for AWS Redshift
    • DbVisualizer
    • JackDB
    • POPSQL
    • Postico
    • RazorSQL
    • Superquery for Google BigQuery
    • SQL Server Management Studio by Microsoft
    • Tableplus

  • OSS

    • Beekeeper Studio
    • DBeaver
    • Franchise
    • OmniDB
    • Sqlelectron
    • SQL Tabs
    • SQuirreL SQL

• 3. Data Visualization

  • SaaS

    • Model approach:

      • Count
      • Holistics
      • Looker
      • Numetric

    • SQL or other:

      • Birst
      • Chartio
      • Cluvio
      • Contiamo
      • Datapine
      • Data Studio by Google
      • Domo
      • Focuus
      • Mode Analytics
      • Pentaho
      • Periscope
      • PowerBI by Microsoft
      • Saiku Analytics
      • SeekTable
      • ShareInsights by accelerite
      • Silota
      • Sisense
      • Slemma
      • SQL Server Reporting Services by Microsoft
      • Tableau
      • Quicksight by Amazon
      • QlikView
      • Viur

  • OSS

    • blazer by Instacart
    • Insights
    • just-dashboard
    • Metabase
    • poli
    • Redash
    • Smashing
    • Superset
    • Zeppelin

• 4. Data Integration

  • SaaS

    • Alooma
    • Blendo
    • Celigo Integrator
    • Datacoral
    • Etleap
    • Fivetran
    • Hevo
    • Snaplogic
    • Stitch
    • Xplenty

  • OSS

    • singer by Stitch

• 5. Data Modeling

  • SaaS

    • Dataflow by Google Cloud
    • Dataform
    • Glue by AWS
    • Matillion
    • Trifacta
    • rockset

  • OSS

    • Beam by Apache
    • dbt (data build tool) by Fishtown Analytics
    • embulk
    • Mara by Project A
    • Talend Open Studio

• 6. ETL Orchestration

  • SaaS

    • Astronomer
    • dbt Cloud by Fishtown Analytics

  • OSS

    • Airflow by Apache
    • Azkaban
    • Luigi by Spotify
    • Pinball by Pinterest
    • Pipelinewise by TransferWise
    • Prefect

• 7. Data Platforms

  • SaaS

    • Ascend
    • Cloud Analytics by SAP
    • Datos Intelligence
    • Fine BI - Chinese only
    • Keboola
    • Pentaho now Hitachi Vantara
    • statsbot
    • Qubole
    • Quick BI by Alibaba

  • OSS

    • Ananas Analytics
    • Bouquet
    • ELK Stack
      • Elasticsearch
      • Logstash
      • Kibana
    • Meltano by GitLab
    • Metatron
    • Pentaho Community Projects
      • Mondrian OLAP
      • Kettle ETL
      • Pentaho Reporting
      • Weka

• 8. Storage

  • SaaS

    • BigQuery by Google
    • ClickHouse by Yandex
    • Data Virtuality
    • Exasol
    • MemSQL
    • Panoply
    • Redshift
    • Snowflake
    • Treasure Data

  • OSS

    • Apache HAWQ
    • MySQL
    • PipelineDB
    • PostgreSQL

  • SaaS on-prem

    • Yellowbrick

• 9. Knowledge Management

  • SaaS

    • Confluence by Atlassian
    • dbdocs.io by Holistics.io
    • Guru by Guru
    • Notion

  • OSS

    • Knowledge Repo by Airbnb
    • openKB

• 10. Database Modeler

  • Free SaaS

    • dbdiagram by holistics.io
    • Gleek.io

  • SaaS

    • SqlDBM

• 11. Data Discovery and Metadata

  • SaaS

    • Alation
    • Collibra
    • Data Catalog by Google

  • OSS

    • Amundsen by Lyft
    • Marquez by The We Company
    • Metacat by Netflix