Metabase

Centralized administration panel for managing users, permissions, and system settings.

Create user accounts, assign roles, and manage permissions across the platform.

Perform count, sum, average, min, max, and other aggregations on data.

Group data by dimensions for comparative analysis and cross-tabs.

Reorganize data into pivot tables for cross-tabulation analysis.

Click through visualizations to dive deeper into underlying data details.

Apply filters dynamically to dashboards and questions for real-time data exploration.

Sort results and limit returned rows for focused analysis.

Track data dependencies and relationships between tables and queries.

Add descriptions, notes, and custom metadata to tables and columns for better discoverability.

Save and reuse queries as questions that can be shared across the organization.

Define business metrics once and reuse them across multiple questions and dashboards.

Define and visualize relationships between data models for better query building.

Create saved models from complex queries to serve as reusable data sources.

Create reusable filtered views of data for consistent business logic across queries.

Filter data using equality, inequality, range, and pattern matching operators.

Perform inner, left, and right joins between tables visually without SQL.

SQL editor for advanced users to write complex custom queries.

Create questions with variable parameters for flexible reusable analysis.

Visual query builder allowing non-technical users to explore data without writing SQL.

Create custom calculated columns using built-in functions and operators.

Managed cloud deployment with automatic updates, backups, and scaling.

Pre-built Docker containers for easy deployment and containerized environments.

Fully open source codebase available on GitHub for customization and self-hosting.

Search across all saved questions, dashboards, and data with full-text indexing.

Schedule automated reports to be sent to users via email on a recurring basis.

RESTful API for programmatic access to queries, dashboards, and data.

Connect to PostgreSQL, MySQL, MongoDB, Snowflake, Redshift, and 30+ other databases.

Embed dashboards and questions directly into external applications.

Connect to and query from multiple databases simultaneously within a single instance.

iOS and Android apps for accessing dashboards and questions on the go.

Set up automated alerts when data meets specific conditions and get notified via email.

Organize questions and dashboards into collections with hierarchical folder structure.

Organize related visualizations into tabs within a single dashboard.

Improve performance by caching frequently accessed query results.

Monitor query execution times and identify slow queries for optimization.

Manage user permissions and restrict data access at database, table, and row levels.

Track all user actions and database queries for compliance and security monitoring.

Integrate with Single Sign-On and LDAP for enterprise authentication.

User interface available in dark theme for reduced eye strain.