BI Tools for the AI era

BI Tools for the AI era

January 7, 2025

Business Intelligence and IoT (BIA & IoT)

How about real time data analytics?

Real-Time Analytics with ClickHouse

  • ClickHouse Use Cases
  • Superset: An open-source data exploration and visualization platform that supports ClickHouse as a data source.
  • Metabase: An open-source business intelligence tool with ClickHouse integration.
  • Tableau, Looker, Power BI: Commercial BI tools that may have connectors or integrations with ClickHouse.

Metabase

ℹ️

Metabase with MariaDB

https://www.metabase.com/data_sources/mariadb https://www.metabase.com/docs/latest/databases/connections/mariadb

services:
  metabase:
    image: metabase/metabase
    container_name: metabase
    ports:
      - "3000:3000"
    volumes:
      - metabase_data:/metabase-data
    restart: always
    depends_on:
      - mariadb
    environment:
      MB_DB_TYPE: mysql
      MB_DB_DBNAME: chinook
      MB_DB_USER: myuser
      MB_DB_PASS: mypassword
      MB_DB_HOST: mariadb-db

  mariadb:
    image: mariadb:10.5
    container_name: mariadb-db
    environment:
      - MYSQL_ROOT_PASSWORD=rootpassword
      - MYSQL_DATABASE=chinook
      - MYSQL_USER=myuser
      - MYSQL_PASSWORD=mypassword
    volumes:
      - mariadb_data:/var/lib/mysql
    ports:
      - "3399:3306"
      
volumes:
  metabase_data:
  mariadb_data:

Superset

https://github.com/JAlcocerT/Docker/tree/main/IoT/Superset

Superset with

Redash

https://github.com/JAlcocerT/Docker/tree/main/IoT/Redash

Redash with


Analytics Tools

Additional Databases and Tools

  • MongoDB
  • Elasticsearch (ES)
  • InfluxDB
  • Graphite
  • OPENFoam