Data Analytics Tools
Tools
Data
This document provides a structured list of modern dashboard, BI, and data-app tools.
Business Intelligence Platforms
- Microsoft Power BI: Business analytics suite for modeling, interactive reports, and enterprise dashboards.
- Microsoft Fabric: Unified SaaS analytics platform spanning ingestion, lakehouse/warehouse, real-time analytics, and Power BI.
- Looker: Governed BI with semantic modeling via LookML.
- Looker Studio (formerly Google Data Studio): Free interactive dashboards with broad connector support.
- Qlik: Associative-engine BI for self-service analytics and application embedding.
- ThoughtSpot (incl. Mode): Natural-language and AI-assisted analytics; Mode adds SQL/Python/R notebooks.
- Tableau: Visual analytics platform with robust interactivity and governance.
- Sigma: Spreadsheet-style BI on the warehouse with SQL and inline Python.
- Domo: Cloud BI with a marketplace of data apps and embedded analytics.
- Sisense: End-to-end BI and embedded analytics with semantic modeling.
- Clicdata: Cloud BI dashboards with automations and data refresh.
- Cyfe: All-in-one business dashboard for marketing, sales, and web analytics KPIs.
- Databox: Centralized KPIs with mobile-first scorecards.
- Metabase: Open-source BI with visual query builder and SQL editor.
- Preset (Managed Superset): Hosted Apache Superset with enterprise features and governance.
Open-Source BI & Dashboard Frameworks
- Apache Superset: Open-source BI platform for data exploration and visualization.
- Redash: SQL + visualization tool for querying and dashboarding.
- Rill: Real-time BI over DuckDB/Parquet with fast slice-and-dice dashboards.
- MotherDuck: Serverless DuckDB in the cloud for collaborative analytics.
- Cube (Semantic Layer): Headless BI semantic layer and APIs.
- dbt Semantic Layer: Centralized metric definitions exposed to BI tools.
Notebook-Native & Data-App Builders
- Posit (RStudio IDE, Shiny, Quarto): IDE and frameworks for R/Python dashboards and apps.
- Streamlit: Python framework for data apps; Snowflake-integrated version available.
- Plotly Dash: Python framework for production-grade analytic web apps.
- Panel (HoloViz): Python library for dashboards and apps from notebooks or scripts.
- Hex: Notebook-native workspace blending SQL, Python, and interactive apps.
- Deepnote: Collaborative, cloud notebooks with SQL blocks and scheduling.
- Noteable: Collaborative SQL/Python notebooks with comments and publishing.
- Observable Framework: Build fast, portable data apps/reports with Markdown + JS.
Lightweight & Specialized Dashboards
- Analytics Portfolio: Combines multiple Google Analytics accounts for side-by-side comparison.
- Happy Metrics: Marketing dashboard for tracking digital metrics.
- DataDeck: Consolidates data streams into a single dashboard.
- Metricio: Dashboard framework for system and API monitoring.
- Smashing: Sinatra-based framework for custom dashboards.
- Flowbite Admin Dashboard: Tailwind CSS + Flowbite admin dashboard template.
- Datawrapper: Browser-based charts, tables, and maps for quick publishing.
Observability & Log Dashboards
- Grafana: Open-source observability dashboards for metrics, logs, and traces.
- Kibana: Visualize and explore Elasticsearch data.
- OpenSearch Dashboards: Open-source alternative to Kibana.
No-/Low-Code Database & App Platforms
- Baserow: Open database/app builder; self-host via Pikapods.
- SeaTable: GDPR-friendly Airtable-style database/app builder.
- NocoDB: Open-source Airtable-style database builder on existing SQL.
- Teable: Spreadsheet-like interface for database apps.
- Heroku: PaaS for deploying apps; supports monitoring add-ons.