This is the 15th day of my participation in the August More Text Challenge

The open source data visualization platform has done a function research, we can try to use according to need.

Superset (recommended)

  • Github.com/apache/incu…
  • Superset’s Airbnb open source data visualization tool, currently part of the Apache Incubator project, is mainly used for data analysts to perform data visualization work
  • Quickly create interactive, visual data sets
  • There are rich visualization methods to analyze data, and flexible scalability
  • Rich online SQL editor, and a simple workflow to create visualizations of any result set
  • Has an extensible, high-granularity security model that can control access with complex rules
  • With simple syntax, you can control how data is presented in the UI
  • Support for most SQL databases
  • Deep integration with Druid to quickly analyze big data
  • Configure caching to load dashboards quickly

Redash (recommended)

  • Github.com/getredash/r…
  • Support ClickHouse
  • The aesthetics are not as elegant as Superset
  • Simple alarm rules are supported
  • You can share the Dashboard
  • Limited types of charts are supported

Grafana (recommended)

  • Github.com/grafana/gra…
  • Grafana is an open source data visualization tool developed in the Go language
  • Display mode: fast and flexible client charts, panel plug-ins have many different ways of visualization indicators and logs, the official library has a wealth of dashboard plug-ins, such as heat maps, line charts, charts and other display modes
  • Official support for the following data sources: Graphite, InfluxDB, OpenTSDB, Prometheus, Elasticsearch, CloudWatch, KairosDB
  • Notifications notifications: Visually define alert rules for the most important metrics, and Grafana will continuously calculate and send notifications, via Slack, PagerDuty, and so on, when the data reaches a threshold

DataEase (can be tried)

  • Github.com/dataease/da…
  • New product, very vitality
  • Homegrown, team other open source works JumpServer
  • Chart display: support PC terminal, mobile terminal and large screen;
  • Chart making: support rich chart types (based on Apache ECharts implementation), support drag and drop way to quickly create dashboards;
  • Data engine: Supports direct connection mode and local mode (based on Apache Doris/Kettle).
  • Data connection: Supports relational databases, files such as Excel, big data platforms such as Hadoop, and data sources such as NoSQL.

Davinci (can wait for new works)

  • Github.com/edp963/davi…
  • domestic
  • The Da Vinci developed by Creditease is also Java
  • The function still is more comprehensive, just return to use without big range in home
  • It’s no longer iterative, and the r&d team is preparing for a product launch that’s said to be better than this

Metabase (can be tried)

  • Github.com/metabase/me…
  • ClickHouse is not currently supported
  • Let members of the team ask questions without knowing SQL
  • Rich and beautiful dashboard with auto refresh and full screen mode
  • Exclusive SQL schema for analysts and data experts
  • Create specification subdivisions and metrics for your team to use
  • Humanize data for your team by renaming, commenting, and hiding fields

Kibana

  • Github.com/elastic/kib…
  • Kibana is an open source analysis and visualization platform for Elasticsearch

Zeppelin

  • Github.com/apache/zepp…
  • From the Apache project
  • Support ClickHouse
  • Zeppelin is more like a Notebook than a BI tool