BI相关工具总结

发表于 | 更新于 | 分类于

BI相关工具总结

BI相关工具总结

数据可视化

superset

略

metabase

1
2
3

[root@controller fk]# wget https://downloads.metabase.com/v0.33.3/metabase.jar
[root@controller fk]# java -jar metabase.jar

redash

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62

[root@VM_38_115_centos redash]# vi docker-compose.production.yml
# This is an example configuration for Docker Compose. Make sure to atleast update
# the cookie secret & postgres database password.
#
# Some other recommendations:
# 1. To persist Postgres data, assign it a volume host location.
# 2. Split the worker service to adhoc workers and scheduled queries workers.
version: '2'
services:
  server:
    image: redash/redash:latest
    command: server
    depends_on:
      - postgres
      - redis
    ports:
      - "5000:5000"
    environment:
      PYTHONUNBUFFERED: 0
      REDASH_LOG_LEVEL: "INFO"
      REDASH_REDIS_URL: "redis://redis:6379/0"
      REDASH_DATABASE_URL: "postgresql://postgres@postgres/postgres"
      REDASH_COOKIE_SECRET: "Q422k6vaXUk8"
      REDASH_WEB_WORKERS: 4      
    restart: always
  worker:
    image: redash/redash:latest
    command: scheduler
    environment:
      PYTHONUNBUFFERED: 0
      REDASH_LOG_LEVEL: "INFO"
      REDASH_REDIS_URL: "redis://redis:6379/0"
      REDASH_DATABASE_URL: "postgresql://postgres@postgres/postgres"
      QUEUES: "queries,scheduled_queries,celery"
      WORKERS_COUNT: 2
    restart: always
  redis:
    image: redis:3.0-alpine
    ports:
    - "6379:6379"
    volumes: 
      - ./data/redis_data:/data
    restart: always
  postgres:
    image: postgres:9.5.6-alpine
    ports:
    - "5432:5432"
    volumes:
      - ./data/postgresql_data:/var/lib/postgresql/data
    restart: always
  nginx:
    image: redash/nginx:latest
    ports:
      - "88:80"
    depends_on:
      - server
    links:
      - server:redash
    restart: always
[root@VM_38_115_centos redash]# docker-compose -f docker-compose.production.yml run --rm server create_db
[root@VM_38_115_centos redash]# docker-compose -f docker-compose.production.yml up

zeppelin

大数据

sqlpad

略

cboard

国产的
https://peter_zhang921.gitee.io/cboard_docsify/#/

FineBI

finebi https://help.finebi.com/
finereport https://help.finereport.com/

试用码：dbe8992a-085c130cf-2278-d0857c2db051

web报表技术(java)

  • jfreechart
  • cewolf
  • jcharts
  • ireport
  • jasperreports
  • jfreereport
  • openreport
  • birt