Skip to main content
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:
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: hello@gmail.com/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