Superset和Metabase数据可视化-简易搭建

1. Superset简易搭建：　

1.安装Anaconda

 

 

 

安装Anaconda，这里使用虚拟环境。（勾选PATH）

2.Anaconda创建新的python环境

conda create -n python37 python=3.7

3.激活虚拟环境

(base) C:\Users\Administrator>conda activate python37

4.安装cryptography

(python37) C:\Users\Administrator>pip install cryptography

5.更新 setuptools和pip

(python37) C:\Users\Administrator>pip install --upgrade setuptools pip

6.安装superSet
此处可使用豆瓣，清华，阿里镜像

(python37) C:\Users\Administrator>pip install superset -i https://mirrors.aliyun.com/pypi/simple/

或(python37) C:\Users\Administrator>pip install -i https://pypi.tuna.tsinghua.edu.cn/simple --trusted-host pypi.tuna.tsinghua.edu.cn superset
7.创建管理员（安装依赖。。。）

报错：(python37) D:\Anaconda\bin>fabmanager create-admin --app superset
'fabmanager' 不是内部或外部命令，也不是可运行的程序（Python环境安装superset）

(python37) D:\Anaconda\envs\python37\Lib\site-packages\superset\bin>pip install requests

(python37) D:\Anaconda\envs\python37\Lib\site-packages\superset\bin>pip install flask-appbuilder

(python37) D:\Anaconda\envs\python37\Lib\site-packages\superset\bin>python superset fab create-admin

8.设置数据库

(python37) D:\Anaconda\envs\python37\Lib\site-packages\superset\bin>Python superset db upgrade

9.导入数据

(python37) D:\Anaconda\envs\python37\Lib\site-packages\superset\bin>python superset load-examples

 

10.用户权限

(python37) D:\Anaconda\envs\python37\Lib\site-packages\superset\bin>python superset init
(python37) D:\Anaconda\envs\python37\Lib\site-packages\superset\bin>set FLASK_APP=python37

 

11.启动

(python37) D:\Anaconda\envs\python37\Lib\site-packages\superset\bin>python superset run

 

 

 

2. metabase简易搭建：　

1.  官网下载jar包：

地址： https://www.metabase.com/docs/latest/operations-guide/running-the-metabase-jar-file.html

2. 安装Java JDK8

　　此处省略

3. 创建文件夹，移动jar包，运行

 

 

java -jar metabase.jar

 

 

参考文档：https://blog.csdn.net/ljwjojoyy/article/details/115006216