Poli(魄力)

一款为 SQL 爱好者打造的易于使用的BI服务器。在 SQL 中进行强大的数据分析,并获得更快的业务洞察力。「An easy-to-use BI server built for SQL lovers. Power data analysis in SQL and gain faster business insights.」

Github stars Tracking Chart

Poli BI (魄力BI)

Version
license: MIT
Download
Docker Pulls
Build Status
codecov

Poli BI is an easy-to-use SQL reporting application built for SQL lovers!

Why Poli BI

:zap: Self-hosted & easy setup

Platform independent web application. Single JAR file + Single SQLite DB file. Get up and running in 5 minutes.

:muscle: Connect to any database supporting JDBC drivers

PostgreSQL, Oracle, SQL Server, MySQL, Elasticsearch... You name it.

:bulb: SQL editor & schema viewer

No ETLs, no generated SQL, polish your own SQL query to transform data.

:fire: Rich and flexible styling

Pixel-perfect positioning + Drag'n'Drop support to customize the reports and charts in your own way.

:bookmark_tabs: Interactive Adhoc report

Utilize the power of dynamic SQL with query variables to connect Filters and Charts.

:hourglass: Canned report

Capture the snapshot of historical data. Free up space in your own database.

:santa: User management

Three system level role configurations + Group based report access control.

:earth_americas: Internationalization

Custom the language pack and translations just for your audience.

:moneybag: MIT license

Open and free for all usages.

:gem: Is that all?

Auto refresh, drill through, fullscreen, embeds, color themes + more features in development.

What's New (latest)

poli v0.8.0

Slicer & Charts

poli v0.5.0

Move & Resize

poli component reposition

Color palette switch & export CSV

poli v0.6.0

Quick Installation

Windows/Linux

java -jar poli-0.11.0.jar

Docker

docker run -d -p 6688:6688 --name poli zhonglu/poli:0.11.0

Check installation guide for more details.

Download

Download the latest version of Poli via the github release page.

Documentation

Poli's documentation and other information can be found at here.

Run on GCP

Run on Google Cloud

License

MIT License

Copyright (c) Zhonglu Wang

Overview

Name With Ownershzlw/poli
Primary LanguageJava
Program languageJava (Language Count: 1)
PlatformDocker, Google Cloud Platform, Linux, Windows
License:MIT License
Release Count14
Last Release Namev0.12.2 (Posted on )
First Release Namev0.3.0 (Posted on )
Created At2018-11-27 03:56:44
Pushed At2023-01-06 21:00:47
Last Commit At2020-05-31 09:14:49
Stargazers Count2k
Watchers Count65
Fork Count333
Commits Count244
Has Issues Enabled
Issues Count71
Issue Open Count24
Pull Requests Count9
Pull Requests Open Count18
Pull Requests Close Count8
Has Wiki Enabled
Is Archived
Is Fork
Is Locked
Is Mirror
Is Private
To the top