Awesome Business Intelligence

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

1. Slack Integration
2. SQL Client
3. Data Visualization
4. Data Integration
5. Data Modeling
6. ETL Workflow Manager
7. Data Platforms
8. Storage
9. Knowledge Management
10. Data Model Visualization

• 1. Slack Integration

  • SaaS
    • Kiwi
    • PushMetrics
    • statsbot

• 2. SQL Client

  • SaaS

    • DataGrip by JetBrains
    • JackDB
    • Numeracy
    • POPSQL
    • Postico
    • RazorSQL
    • SQL Server Management Studio by Microsoft
    • Tableplus
    • TeamSQL

  • OSS

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

• 3. Data Visualization

  • SaaS

    • Model approach:

      • Looker
      • Numetric

    • SQL or other:

      • Birst
      • Bouquet
      • Chartio
      • Cluvio
      • Contiamo
      • Datapine
      • Data Studio by Google
      • Domo
      • Focuus
      • Holistics
      • iCharts
      • Meteorite
      • Mode Analytics
      • Pentaho
      • Periscope
      • PowerBI by Microsoft
      • Silota
      • Sisense
      • Slemma
      • SQL Server Reporting Services by Microsoft
      • Tableau
      • Quicksight by Amazon
      • QlikView
      • Viur
      • Vizbee

  • OSS

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

• 4. Data Integration

  • SaaS

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

  • OSS

    • singer by Stitch

• 5. Data Modeling

  • SaaS

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

  • OSS

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

• 6. ETL Workflow Manager

  • SaaS

    • Sinter by Fishtown Analytics

  • OSS

    • Airflow by Apache
    • Azkaban
    • Luigi by Spotify

• 7. Data Platforms

  • SaaS

    • Cloud Analytics by SAP
    • Fine BI - Chinese only
    • Pentaho now Hitachi Vantara
    • Quick BI by Alibaba

  • OSS

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

• 8. Storage

  • SaaS

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

  • OSS

    • Apache HAWQ
    • MySQL
    • PipelineDB
    • PostgreSQL

• 9. Knowledge Management

  • SaaS

    • Confluence by Atlassian

  • OSS

    • Knowledge Repo by Airbnb
    • openKB

• 10. Data Model Visualization

  • Free SaaS
    • dbdiagram by holistics.io