Power BI-grade BI system with an AI agent, DuckDB and ClickHouse

A business intelligence system on par with Microsoft Power BI, built at Colvir Software Solutions: dashboards, data models, formulas and reports over large datasets. Full-stack developer role, 2026.

The first task was the core: the client and server sides had grown into one tangled state. Splitting them — data on one side, configuration on the other — delivered a noticeable performance boost and made the rest of the roadmap possible.

Analytics moved closer to the user: DuckDB runs in the browser, so filtering, aggregation and pivoting over loaded data happen without a round-trip, while ClickHouse on the backend handles large volumes and heavy queries. A tokenization-based formula editor gives analysts a Power BI-like expression language with validation and autocompletion.

The AI agent is what sets the system apart from classic BI: a harness with tools, subagents and a memory system that manages the application and its data — builds reports, changes models and answers questions about the data in natural language. Backend on NestJS with Prisma, frontend on React, TypeScript throughout.