Awesome ClickHouseData Visualization and Analysis

datainsider-co/rocket-bi

⭐ 124 TypeScript repository created 2022-09-21

Rocket BI is a free, open-source, web-based self-service business intelligence (BI) tool specifically designed for analytical databases including ClickHouse, Google BigQuery, MySQL, PostgreSQL, and Vertica. It is the core product of the DataInsider stack and enables users to analyze, visualize, and collaborate on data easily. The platform supports multiple connectors, allowing users to connect to various data sources and create insightful dashboards and reports through an intuitive drag-and-drop interface. Rocket BI offers a rich set of features tailored for data exploration and visualization. Users can perform adhoc SQL queries with support for functions and autocompletion, enabling complex data analysis. The drag-and-drop chart builder allows users to create customizable charts and reports with flexible settings. Interactive dashboards help users visualize data dynamically, with the ability to drill down into metrics for deeper insights. Dashboard filters enable quick application of different data views without the need to create multiple dashboards. Additional features include the ability to add controls to charts for dynamic metric changes, no-code ETL data modeling for loading and transforming data without coding, and row-level security to restrict data access based on user roles. The platform also supports calculated and measurement fields for creating dynamic data views and the creation of relationships between data entities. Rocket BI can be run locally using Docker with pre-built images, including an optional sample ClickHouse instance for testing. The project provides detailed documentation and instructions for building from source, including server services and web UI components. It encourages community contributions and offers a demo version for users to try. Overall, Rocket BI is a comprehensive BI solution designed to empower business users and analysts to explore and visualize data from multiple analytical databases, with a strong emphasis on ease of use, collaboration, and security.

https://github.com/datainsider-co/rocket-bi

analyticsbigdatabigquerybusiness-intelligencebussiness-intelligenceclickhousedashboarddashboardsdatadata-analysisdata-collaborationdata-visualizationdrag-and-dropetlgoogle-bigqueryhacktoberfesthacktoberfest2023ingestionmysqlno-code-etlopen-sourcepostgresqlrocket-birow-level-securityself-service-bisql-queryverticaweb-based-bi

Also in Data Visualization and Analysis

akvorado/akvorado

Akvorado is a flow collector, enricher, and visualizer that processes network flow data, enriches it with interface and geolocation information, and stores it in ClickHouse for real-time analysis and visualization.

clickvisual/clickvisual

ClickVisual is a lightweight log analytics and data visualization platform built on ClickHouse, designed for efficient log querying, analysis, and monitoring.

mr-karan/logchef

Logchef is a lightweight, high-performance log analytics platform built on ClickHouse, offering schema-agnostic querying, team-based access control, and easy deployment as a single binary.

Altinity/clickhouse-grafana

Altinity/clickhouse-grafana is a Grafana datasource plugin that enables seamless integration and visualization of ClickHouse data within Grafana dashboards.

serenedb/serenedb

SereneDB is a distributed real-time search analytics database that unifies Elasticsearch-like search and ClickHouse-like analytics in a single, Postgres-compatible platform for high performance and ease of use.

iamtelescope/telescope

Telescope is a web-based log viewer UI that enables intuitive exploration and analysis of log data stored primarily in ClickHouse, with support for Docker logs and advanced querying features.

ClickHouse/metabase-clickhouse-driver

A ClickHouse database driver enabling integration with the Metabase business intelligence front-end for data visualization and querying.

ClickHouse/adsb.exposed

An interactive platform for visualizing and analyzing massive ADS-B air traffic data using ClickHouse with real-time querying and detailed visualizations.