Giter VIP home page Giter VIP logo

tuiqiao / cboard Goto Github PK

View Code? Open in Web Editor NEW
3.0K 275.0 1.2K 32.78 MB

An easy to use, self-service open BI reporting and BI dashboard platform.

Home Page: https://tuiqiao.github.io/CBoardDoc/#/

License: Apache License 2.0

Java 7.14% CSS 6.55% JavaScript 47.34% HTML 38.73% PHP 0.06% PLSQL 0.10% Dockerfile 0.03% Vim Snippet 0.01% SCSS 0.04%
olap dashboard business-intelligence big-data data-visualization superset metabase cboard

cboard's Introduction

CBoard

CBoard is not only a analysis platform that supports interactive multi-dimensional report design and data analysis for user, but also a BI product development platform for developer. Powered by Shanhai Chuguo Information and Technology Co., Ltd.

  • Normal User can analysis your data or design a report by simple drag and drop operation
  • Developer can extend any type of your data datasource that you can connect by Java program

Who is using CBoard

If you wish your company's logo show on our home page, please sign in here provide a logo pic with transparent background

Architecture

Light weight architecture, common technology stack, self designed multi-dimension engine, clear optimization rule, small application running on your big data stack!

Features

  • Simple and beautiful interface and layout
  • Interactive, drag-and-drop OLAP classisc report development experience
  • One dataset, multiple report widgets. Maximize reuse query result
  • Cube level data refresh / realtime chart for quick query
  • Role Based Access Control
  • More than 20 chart types and dashboard insight or email report
  • Multiple types data source connection
    • Support JDBC data connection (Almost all kinds database that has implemented JDBC protocal)
    • Support Native Elasticsearch connection for version 1.x, 2.x, 5.x
    • Support Native Kylin connection for version 1.6
  • Lightweight architecture and concise source code, the entire project does not rely on any third-party multi-dimensional analysis tools, if you are struggling in Mondrain, CBoard could be a nice alternative for you.
  • Easy to implement your own DataProvider to connect any data source. Even for expensive commercial BI suite, it's not possible to connect all the NOSQL and NewSQL data source in the era of big data. Due to the schema of NOSQL are various, such as hash tables, arrays, trees, maps, etc., different people using the same NoSQL products designed Schema may vary widely. The user who most familiar with their storage schema are the user themselves. And it's easy to find a Java programmers to code a Class to connect their own data source. So we leave this part of work to the end user with an easy extended data connection framework in CBoard

Community Edition V.S. Enterprise Edition

Features Community Edition Enterprise Edition
Multiple kinds of data source plugins
Drag-and-drop self-service multidimensional analysis
More than 20 kinds of chart type ✅ + 明细表 + GIS**地图
Dashboard
Near-realtime data refresh
Dashboard Layout Layout by row and column, view and design are seperated Free layout and live preview
Dashboard parameter Common filter Add date range filter, checkbox, searchable dropdown selector filter, keyword input filter
Cockpit Dashboard
Chart link Design for developers, simple support based on raw data columns Design for data analyst, complete chart linkage mechanism to support linkage to datasets, billboards
Inline chart ❌ All charts must first be saved and managed in the Widget Config design area. Support insert inline chart in dashboard.
Send report email
Regroup dimension members
Cusomize sort dimension members
Chart tunning Simple supported More powerful and easy to use
Detail data table
GIS Map chart on detail data
Data Security Chart level Control ⭐⭐ Data cell level control and support role based data access control
Folder based resource managment system ❌ Only support virtual path based folder OS likly file system solution. ACL can be managed by folder
Advantage Cross Table ⭐⭐ Supports advanced calculations such as year-on-year, aspect ratio, percentage, totals, subtotals, cell conditional styles
Dashboard iframe integeration Iframe external system integration with parameter control
SDK integeration Support
Front-end Technology Stack AngularJS VueJS + ES6 + Webpack
Professional Technology Support ✅ Escort your production environment
Road Map ❌ Maintenance-oriented Customer-oriented Road map
功能 社区版 企业版
多种数据源接入
拖拽式自助多维分析
20多种图形展示 ✅ + 明细表 + GIS**地图
数据仪表盘
仪表盘图表定时刷新
看板布局 简单行列编辑,先保存再预览 所见即所得体检的自由布局
看板参数 通用按钮看板参数 日期范围过滤, 复选框, 可搜索下拉选择器与关键词搜索
全屏驾驶舱,监控大屏 完善自适应与高度可订制大屏设计
图表联动 面向开发人员,基于原始数据列的简单支持 完善的图表联动机制,支持联动到数据集、面向业务人员的简单配置
内联图表 ❌ 所有图表必须先在图表设计区设计保存管理 可以直接在数据看板设计图表单个图表、看板、外部系统
报表邮件发送
维度成员自定义分组
维度成员自定义排序
图表微调 支持简单的图表微调 增强
明细表
基于明细数据的GIS地图
数据权限控制 图表级 ⭐⭐ 单元格级别基于角色的权限控制
基于文件夹的资源管理方案 ❌ 虚拟目录无文件夹方案 类似操作系统的统一实体文件夹资源方案
高级交叉表 ⭐⭐ 支持同比、环比、占比、总计、小计等高级计算,单元格条件样式
IFrame外部系统集成 支持看板级别IFrame集成,可传参
SDK级别外部集成 ✅ 便于个性化集成
前端技术架构 AngularJS VueJS + ES6 + Webpack,优化首页加载速度,更适应于云端部署
专业权威技术支持 ✅ 为您的生产环境保驾护航
研发计划 ❌ 维护为主 贴近企业实际需求的长期产品研发计划

More enterprise features please access our homepage: 上海楚果信息技术有限公司

Issues

If you like our product, you can start from our community version. With the support of commercialization of products, we will do our best to maintain the stability of the community version. In future, without affecting the company's business, it will gradually open more basic development infrastructure. Any bugs or question please feel free to post at GithubIssue system

正在招聘

我们正在寻找在相关领域有技术有热情的前端开发小伙伴, 与产品销售小伙伴, 如果您看好公司发展前景, 请将您的简历发送到: [email protected], 如果你足够优秀有机会成为我们技术合伙人哦! 职位链接

More Document

Gitter交流

  • 交流群须知
    • 在讨论相关问题之前,请务必自己阅读官方文档, 相信大部分问题您都能在文档中找到答案
    • 用户交流群是为方便CBoard使用者之间进行沟通,请注意不是答疑群,请大家能够尽量互相帮助
    • 管理员会定义清理最近3个月不曾发言的僵尸用户
    • 在Issue系统里面搜索看看是否有类似问题
    • 确定是程序上的bug请再GitHub issue系统里面创建新的issue, 参照如何真确提问创建Issue主题
      • What steps will reproduce the problem?(该问题的重现步骤是什么?)
      • What is the expected output? What do you see instead?(你期待的结果是什么?实际看到的又是什么?)
      • What version of the product are you using? On what operating system?(你正在使用产品的哪个版本?在什么操作系统上?)
      • Please provide any additional information below.(如果有的话,请在下面提供更多信息。)

Gitter

cboard's People

Contributors

astralidea avatar bingdian-s avatar chenlingmin avatar cxzl25 avatar deanwong avatar february avatar godtrack avatar guozhanxian avatar hjtoday avatar janzhongi avatar jaykelin avatar jintianjiekong avatar junjiem avatar ljyf5593 avatar lordk911 avatar qiqi57 avatar roseluo avatar shawnliu04 avatar sileih avatar yalishizhude avatar yuanyifei avatar yzhang921 avatar zhaoxiangchun avatar zyongctrp avatar zz0412 avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

cboard's Issues

查询固化

新建图表的时候可选使用

  • 已经固化查询
  • 采用原有图表设计方案

Data format for table widge

When the chart type is cross table, allow user to set the format of each field, especially the thousands of decimal digits, percent sign, plus or minus style, left-right alignment, bold, italic, size, underline, etc. setting.

Add paging for cross table

As of now when result data are too big, web page performance will be effectively infected. It's necessary to add a paging function for the big table.

表格样式调整

表格样式有问题,高度不能自适应,横向滚动条一直存在,不是按需存在
image
目前的表格插件不能展示交叉表的层级,理想情况希望能够实现类似下面这种能够合并行/列相同值单元格的效果
image

Cross table display issue

The combined cells of header should share sample ancestors.
Below is a error combine example, CNY below ES and FR shouldn't be combined
image

在Dashboard展示的地方添加Dashboard编辑链接

目前Dashboard布局设计的地方没有预览功能,每次设计好之后需要到看板展示的地方预览效果,来来回回调整不太方便
可以考虑

  • 增加Dashboard预览功能
  • 或看板展示的地方添加一个类似widge编辑的按钮,直接链接会看板设计

[ACL] Widget level access control

  • Add user and role management module
  • Add resource management module
  • Add board level ACL management module
  • Add ACL management of system System Menu/DateSource/DateSet/Widget
  • UI tuning
  • Add change password page

Logic bug

Dear developer:
image

I have used cboard to show kylin data, but the data seems exhibit with logic bug, as the pic shows, "199407-" before "199401-", while I have ordered by year-month, this really confused me, please tell me why? And I changed a sql, there still exists this logic bug.

Thank you for your help!

查询优化

Dashboard 展示性能优化

  1. 前端请求Board定义
  2. 前端获取后台Board定义,并分析Board提取QueryList
  3. 前端并发异步请求Query数据,返回query数据串行图形渲染

seq

Handler exception when dependency resource are lost

Datasource, DataSet, Widget are cascaded. As of now user can delete a datasource that depended on by data set and widget.
We should provide system level robust check and exception handler.

  • Show dataset/query of the widget at board designer
  • Prevent user delete resource that been depended on
  • Exception handler
  • Improve search function: search widget by dataset/datasource, search dataset by datasource

Add use cache option when widget design

For now, the load data process will go directly to query fresh data from data provider. Sometime, when query is heavy the load latency will be very high.
It would be better to have a "use cache" checkbox or switcher along with load data button. Let user choice whether execute new query or just get cache data to avoid duplicate query.

Improve aggregation performance of data service

Refactor sort and OLAP aggregation algorithm.

For now, if the size of header keys or column keys is more than 5W, performance of data service will be very low with high latency because of insert-sort algorithm.

table not exist...

table dashboard_role、dashboard_user、dashboard_user_role not exists...

filter not support chinese

Thanks for the awesome project!
widget designer,when filter select a chinese option,save and reopen,can't find the selectd option
q bndy y0 6 mit1wj_tk

login???

登录接口没有,如何进入主界面???

增加维度排序功能

增加对每个维度的排序功能,默认升序
排序之后可用于表头合并
下面截图USA被分开
image

Switch chart type smoothly

For now, all the drag and drop column for chart configurations will be reset when chart type changed.
It will be more user friendly keep the config to avoid repeat DAD.
But chart configuration are not the same.
e.g. : KIP chart should only have one value column, line/bar chart can have 2 value axis ..
In order to handle this diversity, optional chart configuration should like below:
According to current drop status, enable the supported chart type, disabled not supported chart type:

image

Above pic is only a reference, the final effect shall prevail.

数据没有刷新

_Dashboard_里面_Widget_数据缓存之后,第二次访问不能自动刷新

聚合表达式

图表设计里面,值轴上面的聚合表达式上面只能实现预先定义的集中聚合方式
image
显示中往往需要对集合之后的列进行数学运算,如:sum(a)/sum(b),类似于Mondrian里面定义的CalculatedMeasures
image

数据过滤

前提

由于列不区分维度和度量,不能够直接在所有列上面做可选过滤功能

限定

  • 设定一个阈值,读取数据的时候默认对每一列的数值存放在对应的set里面,每次放入Set之前检查Set Size是否超过阈值,超过阈值则不保存

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.