Rill

About

Rill is an open-source operational BI framework for effortlessly transforming data sets into powerful, opinionated dashboards using SQL.

Unlike most BI tools, Rill comes with its own embedded in-memory database. Data and compute are co-located, and queries return in milliseconds. So you can pivot, slice, and drill-down into your data instantly.

Details

Rill takes a modern approach to Business Intelligence (BI), which is starting to leverage software engineering principles by implementing the concept of BI as code.

This methodology allows for versioning and tracking, thus improving collaboration on BI projects using code, which is more efficient and scalable than traditional BI tools, also breaking down information and knowledge barriers.

Rill’s design principles

• Feels good to use – powered by Sveltekit & DuckDB = conversation-fast, not wait-ten-seconds-for-result-set fast

• Works with your local and remote datasets – imports and exports Parquet and CSV (s3, gcs, https, local)

• No more data analysis “side-quests” – helps you build intuition about your dataset through automatic profiling

• No “run query” button required – responds to each keystroke by re-profiling the resulting dataset

• Radically simple interactive dashboards – thoughtful, opinionated, interactive dashboard defaults to help you quickly derive insights from your data

• Dashboards as code – each step from data to dashboard has versioning, Git sharing, and easy project rehydration

Learn

Rill and CrateDB

Introducing Rill and BI as Code with CrateDB Cloud.

Introducing Rill and BI as Code with CrateDB Cloud