getredash/redash
Redash
Redash is a self-hosted analytics platform and SQL data visualization tool. It provides a web-based SQL query editor for writing, executing, and scheduling database queries, and functions as a business intelligence dashboard for monitoring metrics via visual widgets.
The platform distinguishes itself through its data source connectors, which integrate with various SQL, NoSQL, and API-based stores to retrieve information for analysis. It enables self-service analytics by allowing users to run queries with dynamic parameters and supports shared data reporting via public links or embedded dashboards.
The system covers a broad range of capabilities, including a data visualization engine for creating charts and maps, automated data alerting for monitoring query thresholds, and role-based access control for managing user permissions. It also includes utilities for database schema browsing and exporting query results.
Administration is supported through a command-line interface for system tasks and database schema initialization.
Features
- Business Intelligence Dashboards - Provides a comprehensive business intelligence dashboard for monitoring company performance and trends via visual widgets.
- SQL-Driven Visualization - Transforms raw SQL query results directly into a variety of maps, charts, and tables.
- Self-Hosted Analytics Platforms - Provides a self-hosted, open-source system for transforming raw data into visual reports and monitoring alerts.
- Self-Service Business Intelligence - Empowers non-technical team members to run their own queries using dynamic parameters without writing code.
- Data Source Connections - Provides interfaces for establishing connections to a wide variety of external SQL, NoSQL, and API-based data sources.
- Data Visualization - Transforms structured query results into a variety of interactive charts, maps, tables, and funnels.
- Database Driver Abstractions - Implements a standardized abstraction layer to ensure uniform query execution across diverse SQL and NoSQL drivers.
- Remote Data Source Connectors - Integrates with various SQL, NoSQL, and API-based data stores to retrieve information for analysis.
- Visualization Platforms - Provides a visualization platform that transforms SQL data into interactive, shareable dashboards.
- SQL Query Interfaces - Offers a web-based interface for writing, executing, and scheduling database queries with dynamic parameters.
- Role-Based Access Control - Restricts data source and dashboard visibility by mapping user identities to specific permission groups and roles.
- Alerts and Notifications - Monitors query results and sends external notifications when specific data conditions are met.
- Query Output Caches - Stores query outputs in a cache layer to ensure fast dashboard loading and reduce load on remote data sources.
- Query Parameter Filters - Allows users to add dynamic inputs to queries to filter results by dates or text without modifying SQL code.
- Multi-Source Data Aggregation - Enables the retrieval and aggregation of information across various data store types for comprehensive analysis.
- Dynamic Parameter Injection - Injects dynamic user inputs into raw data queries at runtime to filter results without manual code modification.
- RESTful - Exposes backend data services and query management to the frontend through a standardized RESTful API gateway.
- Background Job Processing - Offloads intensive data tasks to background workers to maintain a responsive user interface.
- Identity Provider Integrations - Integrates with external identity providers to synchronize user identities and manage secure logins.
- User Access Management - Controls user permissions and group memberships to restrict access to specific queries and dashboards.
- Redis-Backed Queues - Uses a Redis-backed distributed task queue to manage asynchronous query execution and scheduled jobs.
- SQL Query Schedulers - Automates the periodic execution of database queries to keep data visualizations current.
- Automated Alerting Workflows - Monitors query results and triggers notifications when data hits predefined thresholds or conditions.
- Dashboard Sharing - Generates public links and embeds to share interactive data visualizations with external stakeholders.
- Grid Layouts - Provides a grid layout system for arranging multiple visualizations into a single monitoring view.
- Visualization and Analysis - Visualization framework for querying and displaying big datasets.
- Analytics - Data visualization and dashboarding platform for multiple data sources.
- Analytics and Search - Platform for data visualization and dashboarding.
- Analytics Platforms - Dashboarding and visualization tool for various data sources.
- Analytics Tools - Listed in the “Analytics Tools” section of the Awesome Selfhosted awesome list.
- Business Intelligence - Platform for querying and visualizing data sources.
- Dashboards and BI - Tool for visualizing and sharing data insights.
- Data Management Systems - Dashboard construction and data visualization for business intelligence.
- Data Processing - Query, share, and visualize database datasets.
- Data Visualization - Data visualization and dashboarding tool.
- Databases & Data - Data visualization and analytics.
- Database GUI Clients - Platform for connecting, visualizing, and sharing database data.
- Open Source Projects - Data visualization and dashboarding platform.
Star history
How this analysis was created: This summary and feature list are AI-generated from collected project material and can contain mistakes. Stars, license and language are imported from GitHub. Inclusion does not mean that we have tested or audited this project. Check the source documentation for any feature you depend on. Learn more on our About page.
