This issue recommends an open source data visualization analysis platform——DataGear。

DataGear is an open source data visualization analysis platform, you can freely make any data visualization Kanban you want, support access to SQL, CSV, Excel, HTTP interface, JSON and other data sources. The main functions of the system include: data management, SQL workbench, data import/export, data set management, chart management, Kanban management, etc.

functional characteristics

• Dynamic access to multiple data sources

Supports dynamic access to any database that provides the JDBC driver, including relational databases such as MySQL, Oracle, PostgreSQL, and SQL Server, and big data engines such as Elasticsearch, ClickHouse, and Hive.

• Supports data sets in multiple formats

You can create SQL, CSV, Excel, HTTP interface, and JSON data sets, define data sets as dynamic parameterized data sets, and add data set parameters such as text boxes, drop-down boxes, date boxes, and time boxes to support the construction of dynamic interactive charts.

• Rich and powerful chart function

Charts can aggregate multiple data sets in different formats, easily build year-on-year and quarter-on-month data charts, built-in line charts, bar charts, pie charts, maps, radar charts, funnel charts, scatter charts, K charts, Sankey charts and other 50+ out-of-the-box charts, and support custom chart configuration items, support to write and upload custom chart plug-ins.

• Freely editable data visualization page

The visual page uses the native HTML web page as a template, you can freely edit the page content, import any HTML web page, add extended attributes to the elements to bind and configure charts, the page built-in rich API, you can build chart linkage, data drilling, asynchronous loading, interactive forms and other personalized data visualization pages.

architecture diagram

install DataGear

1.Install the JRE

JRE 1.8 or later is required.

2. Download the latest software package

site：
https://gitee.com/datagear/datagear/attach_files/850057/download/datagear-2.9.0.zip

3. Unzip package

When extracted, a folder named datagear-[version] is generated

4. Start service

• Linux：execute datagear-[version]/startup.sh
• Windows：execute datagear-[version]/startup.bat

5. Open from browser

import：http://localhost:50401

6. Other notes:

• At first, the system has a built-in administrator account. The account name and password are admin
• All data of the system is stored in the [user home directory]/.datagear folder. Please back up this folder when necessary.
• The system database uses the built-in Derby database, stored in the [user home directory]/.datagEAR /derby folder.
• System default to allow anonymous users to access and use, in the config/application. The properties set disableAnonymous configuration items can disable this feature. Example:

disableAnonymous=true

• The default system allows the user to the independent registered in the config/application. The properties set disableRegister configuration items can disable this feature. Example:

disableRegister=true

• System default allow anonymous users to use all of its functions in the config/application. The properties set defaultRole. Anonymous configuration items can be adjusted this feature. The following configuration example gives anonymous users only permission to browse data, but no permission to create or edit data:

defaultRole.anonymous=ROLE_DATA_ANALYST

Get started

1. Creating a Data Source (optional)

Click the + button under the Data Source column in the upper left corner of the home page to create a new data source, such as MySQL:

2. Create a new SQL data set (optional, perform this operation when a new data source is created)

Click the Data Set entry under Data Analysis in the upper left corner of the home page to add a SQL dataset:

3. Create a new JSON data set (optional, perform this operation if no new data source is created)

Click on the Data set entry under Data Analysis in the upper left corner of the home page to add a JSON data set:

4.new chart

Click on the Chart entry under the Data Analysis column in the upper left corner of the home page and add two charts, a bar chart and a pie chart:

5. Presentation chart

Click the “Save and display” button on the above Add chart page to see the chart display effect:

6. New signage

Click on the “Kanban” entry under the “Data Analysis” column in the upper left corner of the main page, add a Kanban, and add two <div> elements inside the Kanban template content <body></body> element:

<html>
<head>
...
</head>
<body>
  <div class="dg-chart" dg-chart-widget="Above bar chart chart ID"></div> 
  <div class="dg-chart" dg-chart-widget="Above bar chart chart ID"></div>
</body>
</html>

Alternatively, click the “Insert Chart” button, select the above two charts, and automatically insert these two elements, as shown below:

7. Display board

Click the “Save and display” button on the page above to see the Kanban display effect:

Interface example

• large-size screen monitors

• Map linkage

• Filter by block

• Chart interaction

• Dark theme

• data administration

Large screen template

In addition, datagear also prefabricated a variety of static large screen HTML templates, which can be used as Kanban templates to import DataGear data visualization analysis platform and make large screen display data visualization Kanban.

Template address:
https://gitee.com/datagear/DataGearDashboardTemplate

Effect drawing:

You can read more on your own.