Shulou(Shulou.com)06/01 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.