Rocket.BI - A Native BI Tool For ClickHouse
Updated: Dec 12, 2022
Rocket.BI is the core product of Data Insider and is natively integrated with ClickHouse. It is a powerful business intelligent tool for data discovery, exploration, and visualization.
1. What is Rocket.BI?
Rocket.BI is a free, open-source, web-based business intelligence solution specifically designed for analytical databases. It enables data analysts and business users alike to easily integrate different data sources, perform advanced data analysis, ad hoc, and more. With an easy-to-use editor, you can create personalized reports, build interactive business dashboards and generate actionable business insights. Rocket.BI also allows collaboration as working together with other people in the organization. You can see more about Rocket.BI here. In this article, we will cover some aspects of Rocket.BI to help you gain a better understanding of why this is an ideal BI for ClickHouse.
2. How Rocket.BI connects to ClickHouse
Run RocketBI locally:
The best way to try out Rocket BI on your machine is by using our pre-built Docker images.
1. Prepare your connection details:
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 with your ClickHouse server's host, port, username, password, and cluster name.
NOTE: If you're installing RocketBI on the same host with your ClickHouse-server, please use 172.17.0.1 as your CLICKHOUSE_HOST instead of localhost for docker to resolve hosts correctly.
2. Install sample ClickHouse:
If you don't have ClickHouse access at the moment, you can still try RocketBI by installing our sample ClickHouseinstance by running the following commands:
wget https://raw.githubusercontent.com/datainsider-co/rocket-bi/main/docker/sample_clickhouse_cluster.zip unzip sample_clickhouse_cluster.zip cd sample_clickhouse_cluster/ docker-compose up -d ./import_sample_data.sh cd -
If the commands run successfully, you will have access to an instance of the ClickHouse cluster locally with the following information:
CLICKHOUSE_HOST: "172.17.0.1" CLICKHOUSE_HTTP_PORT: 8123 CLICKHOUSE_TCP_PORT: 9000 CLICKHOUSE_USERNAME: default CLICKHOUSE_PASSWORD: "" CLICKHOUSE_CLUSTER_NAME: ""
3. Rocket.BI as a BI tool for ClickHouse
Rocket.BI interface is intuitive and user-friendly to create and customize the dashboards according to your requirements. It creates a welcoming workspace that encourages you to explore data, create attractive visualizations, and get insightful results. However, some hidden functions cause difficulties for newcomers.
Turn ClickHouse data into beautiful charts and dashboards
Pivot & visualize ClickHouse data with our advanced visualization tools
Build dashboards & reports of ClickHouse that auto-update with the latest data
Get fast ClickHouse reports performance with auto-scheduled refreshes
Intuitive drag-and-drop interface with fully customizable options
No scripting or programming knowledge needed
Wide selection of graphs and charts from 36 types of visualization to choose from
A wide range of connectivity
Unlimited drill-down & analysis of your Big Data from the dashboard with instant speed.
Share insights with colleagues and external partners
Powerful User Access Control limits a user's access to certain data, defines filters for each Attribute Value, and restricts data access to query and view at the row level.
Share & Collaboration: Share with the rest of your organization by granting access or providing links to them.
4. Build your visualization with Rocket.BI
1. To start doing BI with ClickHouse, select a visualization to start, then select the database retrieved from ClickHouse
2. Drag and drop properties from the dataset to see the visualization view
3. You can select the Type session to change the visualization to other available charts
Did you know? Data Insider Rocket.BI is providing free trials with unlimited features, integrations, and visualisation capabilities. Visit https://www.datainsider.co/register to sign up for a free trial and experience full accessibility.