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
ℹ️
IoT Project with Metabase+MongoDB+DHT Sensor
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