Chartbrew

Chartbrew is a self-hosted business intelligence platform and data visualization engine designed to transform raw data from SQL databases and external API endpoints into interactive charts and dashboards. It serves as a tool for building analytics dashboards that monitor business metrics and KPIs through a privately hosted environment.

The platform distinguishes itself with an embedded analytics workflow, allowing users to generate secure, time-limited shared links and iframes to display private charts on external websites. It also provides programmatic chart generation via API and integrates with services such as Google Analytics and OpenAI.

The system covers a broad range of capabilities, including multi-tenant resource isolation, automated dataset refreshing via job queues, and result caching. It includes security features such as symmetric data encryption, token-based authentication, and role-based access control for team management. Additionally, the platform supports automated data monitoring with webhook alerts based on chart thresholds.

The application is packaged for consistent deployment using Docker containerization and supports one-click installation via cloud marketplace images.

Features

Business Intelligence Platforms - Provides a centralized platform for connecting data sources, creating visual analytics, and sharing interactive business intelligence dashboards.
Dashboard Charting Tools - Provides a web interface for building custom interactive charts and analytics dashboards.
Data Formatting - Transforms raw API and database responses into structured formats required by the charting engine.
Self-Hosted Analytics Platforms - Provides a privately hosted analytics platform to maintain full control over data and infrastructure.
Team Creation - Provides the ability to establish new team workspaces and assign ownership via authentication tokens.
Analytics Dashboards - Provides a web-based interface for visualizing and exploring analytical data through custom datasets and automated refreshes.
External API Connectors - Integrates with external API connectors to authenticate and retrieve data for visualizations.
Chart-to-Dataset Bindings - Connects raw datasets to visual charts via specific parameters to determine how metrics are displayed.
Custom Data Visualizations - Transforms raw data from SQL databases and APIs into interactive charts with custom axes and filters.
Secure Embeddable Engines - Generates secure shared links and iframes to display private data charts on external websites.
Visualization Configuration APIs - Allows defining axes, date filters, and logical conditions to transform raw datasets into visual chart representations via API.
Data Source Connections - Implements interfaces for establishing secure links to external databases and API endpoints using credentials and SSL.
Chart Axis Mappings - Maps dataset fields to visual chart parameters to define how trends and metrics are plotted.
Cross-Source Querying - Executes queries against external SQL databases and API endpoints to retrieve data for visualization.
Data Request Execution - Triggers specific data queries to retrieve results from a dataset using filters or cached data.
Data Source Connectivity Tools - Provides utilities to set up and manage external data source connections for chart data fetching.
Data Source Definitions - Allows defining how to fetch data from external sources by specifying endpoints, methods, headers, and pagination.
Data Visualization Dashboards - Allows grouping multiple independent charts into a unified dashboard for comprehensive data insights.
Dataset Configuration Updating - Modifies the properties of a data source, including its query, name, and join configurations.
External Data Integrations - Connects to third-party APIs and SQL database endpoints to centralize external information for analysis.
Chart Configuration Updates - Enables modification of axes, date formatting, filter conditions, and visual styles for chart data sources.
Multi-Tenant Resource Isolation - Implements resource isolation around team entities to prevent cross-tenant data leakage.
Shared Dataset Definitions - Defines reusable data sources and formatting logic to prepare raw data for visual charts.
SQL Charting - Includes a system for connecting to SQL databases and visualizing query results through interactive charts and dashboards.
Team Management - Includes tools for creating and updating organizational teams to group users and shared resources.
API - Provides programmatic interfaces to generate charts and their associated dataset configurations in a single request.
Dashboard Generation APIs - Generates complete dashboards with custom titles, descriptions, visual themes, and update schedules via API.
Bearer Token Authentication - Uses Bearer tokens to authenticate API requests and enforce multi-tenant resource access.
Data Encryption - Secures sensitive database credentials and configuration settings using AES-256 symmetric encryption.
Role-Based Access Controls - Restricts system access based on user roles to ensure isolation and security within a multi-tenant environment.
AES Implementations - Secures sensitive database credentials using AES-256 symmetric encryption before persistence.
Metric Dashboards - Creates centralized dashboards for monitoring business KPIs and metrics from connected data sources.
Data Query Execution APIs - Retrieves data for specific charts using filters to control parsing, source inclusion, and cache usage.
Embedded Analytics - Enables the integration of private data charts and dashboards into external websites via secure iframes.
OpenAI API Clients - Implements an OpenAI API client to extend application capabilities using specified models and keys.
Signed URL and Cookie Access - Provides time-limited and authenticated access to private charts via cryptographically signed URLs.
Data Refresh Scheduling - Schedules automated updates of data sources to keep visualizations current.
Visualization Dataset Generators - Streamlines setup by generating a reusable dataset and its associated data requests in a single operation.
Chart Data Retrieval - Provides an API to fetch chart data optimized for external sharing using security tokens and custom themes.
Programmatic Chart Configuration - Provides API endpoints to automate the creation and updating of data visualizations and dashboard configurations.
Dynamic Variables - Implements reusable placeholders and variables that can be referenced across multiple network requests.
Google API Integrations - Connects to Google API services to fetch and visualize web traffic and user behavior data.
Share Link Tokens - Generates signed JWT tokens to provide secure, time-limited external access to dashboards.
Embedded Content Policies - Creates security policies for embedded charts using signed URLs and controlled parameter passing.
Signed Sharing Tokens - Creates signed JWT tokens to embed charts with specific permissions and expiration dates.
Query Parameter Bindings - Allows dynamic injection of parameters into data requests to enable flexible filtering and context-aware queries.
Alert Thresholds - Defines numerical limits and rules that trigger webhook notifications when chart metrics exceed specified thresholds.
Metric Threshold Alerting - Implements automated webhook alerts that trigger when chart data reaches defined thresholds or anomalies.
Dashboard Sharing Controls - Offers configuration tools for dashboard sharing rules, including token expiration and custom parameters.
Sharing Policies - Enforces secure sharing policies for dashboards using signed URLs with mandatory expiration dates.
Ticket-Based Sharing - Generates signed JWT tokens to provide time-limited, parameter-controlled access to dashboards and charts.
Iframe Chart Embedding - Configures server headers and secure tokens to permit the embedding of private charts in external iframes.
Database Management - Tool for creating charts from database and API data.
Dashboards and Portals - Builds live dashboards from database and API data.

dataease/dataease

23,420View on GitHub

DataEase is an open-source, self-hosted business intelligence platform designed for building interactive data visualizations and managing analytical reporting. It provides a centralized environment where users can construct dashboards through a drag-and-drop interface, connecting to diverse data sources including relational databases, data warehouses, and external APIs. The platform distinguishes itself through its focus on embedded analytics and enterprise-grade governance. It allows for the seamless integration of charts, dashboards, and management modules into third-party web applications

cube-js/cube

20,251View on GitHub

Cube is a semantic data layer that provides a unified framework for defining business metrics, dimensions, and relationships across diverse data sources. By acting as a headless business intelligence engine, it transforms raw data into a governed model that can be queried via SQL, REST, and GraphQL interfaces. This architecture ensures consistent data definitions and logic across all downstream analytical applications and reporting tools. The platform distinguishes itself through its integrated conversational AI capabilities, which allow users to explore data using natural language. It orches

prestodb/presto

16,711View on GitHub

Presto is a distributed SQL query engine designed for high-performance analytical processing across heterogeneous data sources. It functions as a data federation platform and massively parallel processing engine, allowing users to execute interactive queries against diverse storage systems without requiring data migration. By mapping remote metadata and structures to a unified relational namespace, it enables seamless cross-platform analysis through a standard SQL interface. The engine distinguishes itself through a pluggable connector architecture and a shared-nothing distributed processing

apache/pinot

6,098View on GitHub

Pinot is a distributed, columnar analytical database designed for high-concurrency, low-latency query processing. It functions as a real-time OLAP datastore, enabling interactive, user-facing analytics by ingesting and querying massive datasets from both streaming and batch sources. The system architecture relies on a centralized controller for cluster coordination and a distributed segment-based storage model to ensure horizontal scalability. The platform distinguishes itself through a hybrid ingestion pipeline that unifies real-time event streams and historical batch data into a single quer

chartbrewchartbrew

Features