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. Analytics Clients
3. Data Visualization
4. Data Integration
5. Data Modeling
6. Data Discovery & Lineage
7. Data Observability
8. ETL Orchestration
9. Reverse-ETL
10. Data Platforms
11. Storage
12. Knowledge Management
13. Database Modeler
14. Customer Data Platforms
15. Workflow Automation
16. No Code Data Tools
17. CI/CD
18. Data Reliability

• 1. Monitoring and Alerting

  • SaaS
    • intermix
    • Kiwi
    • PushMetrics
    • Revere
  • OSS
    • Chaos Genius

• 2. Analytics Clients

  • SaaS

    • DataGrip by JetBrains
    • DataRow for AWS Redshift
    • DbVisualizer
    • Deep Channel
    • evidence
    • Hex
    • Husprey
    • hyperquery
    • JackDB
    • Lightdash
    • POPSQL
    • Postico
    • RazorSQL
    • Sigma Computing
    • Superquery for Google BigQuery
    • SQL Server Management Studio by Microsoft
    • Tableplus
    • Query Me

  • OSS

    • Beekeeper Studio
    • Cloudbeaver
    • DataStation
    • DBeaver
    • DbGate
    • Franchise
    • OmniDB
    • Sqlelectron
    • SQL Tabs
    • SQuirreL SQL
    • Sequel Ace
    • Querybook by Pinterest

• 3. Data Visualization

  • SaaS

    • Model approach:

      • Count
      • Holistics
      • Looker
      • Numetric
      • Knowi

    • SQL or other:

      • Birst
      • Chartio
      • Cluvio
      • Contiamo
      • Cumul.io
      • Datapine
      • Data Studio by Google
      • Domo
      • Focuus
      • Holistics
      • 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
    • Datart (CN only language support)
    • Insights
    • just-dashboard
    • Lightdash
    • Metabase
    • poli
    • Redash
    • Smashing
    • Superset
    • Zeppelin
    • Tellery

• 4. Data Integration

  • SaaS

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

  • OSS

    • Airbyte
    • Jitsu
    • Singer by Stitch

• 5. Data Modeling

  • SaaS

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

  • OSS

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

• 6. Data Discovery and Lineage

  • SaaS

    • Alation
    • Atlan
    • Castor
    • Collibra
    • Data Catalog by Google
    • Secoda
    • Selectstar
    • Sled for Snowflake
    • Stemma by Amundsen creators

  • OSS

    • Amundsen by Lyft
    • Datahub Project
    • elementary-lineage
    • Marquez by The We Company
    • Metacat by Netflix
    • Open Data Discovery
    • spline by Absa

• 7. Data Observability

  • SaaS

    • acceldata
    • Bigeye
    • databand
    • datafold
    • Metaplane
    • Monte Carlo
    • Sifflet
    • soda

  • OSS

    • Monosi

• 8. ETL Orchestration

  • SaaS

    • Amazon Managed Workflows for Apache Airflow
    • Astronomer
    • Azure Data Factory
    • dbt Cloud by Fishtown Analytics
    • Google Cloud Composer

  • OSS / Open Core

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

• 9. Reverse-ETL

  • SaaS
    • Castled
    • Census
    • Hevo
    • Hightouch
    • Omnata
    • Polytomic
    • prequel

• 10. Data Platforms

  • SaaS

    • Ascend
    • Cloud Analytics by SAP
    • Fine BI - Chinese only
    • GoodData
    • Keboola
    • MicroStrategy
    • Mozart Data
    • Pentaho now Hitachi Vantara
    • Pyramid Analytics
    • statsbot
    • Qubole
    • Quick BI by Alibaba
    • Weld
    • Whaly
    • y42

  • OSS

    • Ananas Analytics

    • DataCater for real-time ETL

    • Bouquet

    • ELK Stack

      • Elasticsearch
      • Logstash
      • Kibana

    • Meltano by GitLab

    • Metatron

    • Orchest

    • Pentaho Community Projects

      • Mondrian OLAP
      • Kettle ETL
      • Pentaho Reporting
      • Weka

• 11. Storage

  • SaaS

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

  • OSS

    • Apache HAWQ
    • MySQL
    • PipelineDB
    • PostgreSQL

  • SaaS on-prem

    • Yellowbrick

• 12. Knowledge Management

  • SaaS

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

  • OSS

    • Knowledge Repo by Airbnb
    • openKB

• 13. Database Modeler

  • Free SaaS

    • dbdiagram by holistics.io
    • Gleek.io

  • SaaS

    • SqlDBM

• 14. Customer Data Platforms

  • SaaS

    • mparticle
    • Segment

  • OSS

    • Rudderstack

• 15. Workflow Automation

  • SaaS

    • zapier

  • OSS

    • n8n

• 16. No Code Data Tools

  • SaaS

    • Airtable
    • Canvas
    • Equals
    • ninox
    • noloco
    • Patterns
    • retool
    • rilldata
    • superblocks
    • Xano

  • OSS

    • appsmith
    • nocodb
    • Orchest
    • ToolJet
    • Windmill

• 17. CI CD

  • SaaS
    • Spectacles for Looker

• 18. Data Reliability

  • SaaS
    • Bigeye
    • Datafold
    • Great Expectations by Superconductive
    • Soda