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.
