How to use Superset, a free BI tool for Github 30000 Star
Github 30000 Star's free BI tool Superset how to use, I believe that many inexperienced people do not know what to do, so this article summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.
BI tools are effective weapons for data analysis. At present, there are many BI software on the market, such as Tableau, PowerBI, Qlikview, sail soft, etc., most of which are fee-based software or some functional charges. These tools are versatile, and it is enough to make good use of one. The important thing is analytical thinking.
I always use Tableau, but it's too expensive, ten thousand a year. I previously came across a browser-based open source BI application called "Superset" at github, which was developed by the Airbnb team. I love messing around when I have nothing to do. I spent some time in the configuration phase of installing Superset, which is a little tiring, but it is very nice in practice.
First, take a look at the panel effect:
It can also be integrated with deck.gl to make a difficult map display:
The Superset backend is based on python development, so it is also a member of the python ecology. Its three major features are: open source, lightweight, rich charts. Compared with the integrated software, Superset has some barriers to use and is not so friendly to beginners, but it is free, free and fragrant.
The official introduction to Superset is:
A variety of visual charts are predefined through NVD3/D3 to meet most of the data display functions. ; an easy-to-use interface for browsing and visualizing data; creating and sharing dashboards; a lightweight semantic layer that allows you to define dimensions and metrics to control how data sources are exposed to users; an extensible, high-granularity security model that allows complex rules for who can access which product features and datasets. Integration with primary authentication backend (database, OpenID, LDAP, OAuth, REMOTE_USER, …) ; integrate with most RDBMS based on SQL language through SQLAlchemy; deeply integrate with Druid.io
One bright spot is that Superset supports sql queries, which is so convenient that Tableau doesn't seem to be able to. Use SQL Lab to query and visualize data:
You can import text files such as csv and connect to the database. Databases supported by Superset:
MySQL
Oracle
PostgreSQL
Presto
Snowflake
SQLite
SQL Server
Teradata
Vertica
Hana
Amazon Athena
Amazon Redshift
Apache Drill
Apache Druid
Apache Hive
Apache Impala
Apache Kylin
Apache Pinot
Apache Spark SQL
BigQuery
ClickHouse
CockroachDB
Dremio
Elasticsearch
Exasol
Google Sheets
Greenplum
IBM Db2
However, to connect to these databases, you need to install the appropriate connection package:
Choose a variety of chart types freely:
Richer cases:
There are many python dependent libraries in Superset, so it is recommended to install Anaconda first to avoid unnecessary trouble.
The specific installation and use steps are as follows:
# Install superset
Pip install apache-superset
# Initialize the database
Superset db upgrade
# Create an admin user (you will be prompted to set a username, first and last name before setting a password)
$export FLASK_APP=superset
Superset fab create-admin
# Load some data to play with
Superset load_examples
# Create default roles and permissions
Superset init
# To start a development web server on port 8088, use-p to bind to another port
Superset run-p 8088-with-threads-reload-debugger
You may encounter all kinds of troubles in the actual installation and use process, so ask Google, or stackoverflow.
After reading the above, have you mastered how to use Superset, the free BI tool of Github 30000 Star? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!
