Goal: build your first dashboard with Rocket.BI

Community Maintained

In this guide, you will install and build a simple dashboard using Rocket.BI . This is the dashboard:

Rocket BI dashboard showing sales metrics with charts and KPIs

You can checkout the Dashboard via this link.

Install

Start RocketBI with our pre-built docker images.

Get docker-compose.yml and configuration file:

wget https://raw.githubusercontent.com/datainsider-co/rocket-bi/main/docker/docker-compose.yml
wget https://raw.githubusercontent.com/datainsider-co/rocket-bi/main/docker/.clickhouse.env

Edit .clickhouse.env, add clickhouse server information.

Start RocketBI by run command: docker-compose up -d .

Open browser, go to localhost:5050, login with this account: [email protected]/123456

To build from source or advanced configuration you could check it here Rocket.BI Readme

Let's build the dashboard

In Dashboard, you will find your reportings, start visualization by clicking +New

You can build unlimited dashboards & draw unlimited charts in a dashboard.

Animation showing the process of creating a new chart in Rocket BI

See hi-res tutorial on Youtube: https://www.youtube.com/watch?v=TMkdMHHfvqY

Build the chart controls

Create a metrics control

In the Tab filter, select metric fields you want to use. Make sure to keep check on aggregation setting.

Rocket BI metrics control configuration panel showing selected fields and aggregation settings

Rename filters & Save Control to Dashboard

Metrics control with renamed filters ready to save to dashboard

Create a date type control

Choose a Date field as Main Date column:

Date field selection interface in Rocket BI showing available date columns

Add duplicate variants with different lookup ranges. For example, Year, Monthly, Daily date or Day of Week.

Date range configuration showing different time period options like year, month, and day

Rename filters & Save Control to Dashboard

Date range control with renamed filters ready to save to dashboard

Now, let build the Charts

Pie chart: sales metrics by regions

Choose Adding new chart, then Select Pie Chart

Chart type selection panel with pie chart option highlighted

First Drag & Drop the column "Region" from the Dataset to Legend Field

Drag and drop interface showing Region column being added to legend field

Then, change to Chart Control Tab

Chart control tab interface showing visualization configuration options

Drag & Drop the Metrics Control into Value Field

Metrics control being added to the value field of the pie chart

(you can also use Metrics Control as Sorting)

Navigate to Chart Setting for further customization

Chart settings panel showing customization options for the pie chart

For example, change Data label to Percentage

Data label settings being changed to show percentages on the pie chart

Save & Add the Chart to Dashboard

Dashboard view showing the newly added pie chart with other controls

Use date control in a time-series chart

Let Use a Stacked Column Chart

Stacked column chart creation interface with time-series data

In Chart Control, use Metrics Control as Y-axis & Date Range as X-axis

Chart control configuration showing metrics on Y-axis and date range on X-axis

Add Region column in to Breakdown

Region column being added as breakdown dimension in the stacked column chart

Adding Number Chart as KPIs & glare-up the Dashboard

Complete dashboard with KPI number charts, pie chart, and time-series visualization

Now, you had successfully build your 1st dashboard with rocket.BI

Install​

Let's build the dashboard​

Build the chart controls​

Create a metrics control​

Create a date type control​

Now, let build the Charts​

Pie chart: sales metrics by regions​

Use date control in a time-series chart​