Context
OSNO-VA is KT.Team's AI product for management accounting and AI-powered bookkeeping. Its BI layer is built on Apache Superset: management dashboards and P&L run on open-source BI deployable on the company's own perimeter.
OSNO-VA publishes benchmarks for its perimeter: $50M+ revenue per accountant, −70% manual routine from accounting, and 59s from invoice photo to 1C GL entry. These are product-wide metrics, not BI-stage metrics alone — here we describe the analytics engineering layer.
Challenge
Management accounting needs a BI layer that solves three problems at once: keeps data on the customer's own perimeter, delivers P&L and detail with appropriate permissions to business roles, and remains part of a working product rather than becoming endless dashboard consulting.
As familiar proprietary BI tools withdraw, many companies need a self-hosted path without sanctions risk. Apache Superset fills this gap: open-source, data stays on your perimeter, you control access.
- P&L, cash flow statement, and cash flow forecast, plus management accounting detail, are available to business users with role-based access.
- Data and dashboards stay internal: self-hosted deployment in cloud or customer's on-premise.
- Reporting is reproducible, and BI lives as an embedded product layer, not a separate dashboard portal.
Review a similar project with an architect
Solution
We worked backward from business questions to data: what metrics should a management report user see, which data marts feed them, and how should access be segmented.
- Management accounting data marts and P&L are prepared at the SQL layer, and Superset reads curated datasets rather than raw tables — making figures reproducible.
- SQL Lab and Superset datasets give analysts transparent access to sources without exporting to external files.
- Roles and RLS scope data to each business user: everyone sees their own, access is managed, not handed out via exports.
- Self-hosted deployment mirrors OSNO-VA's on-premise scenario: data, data marts, and dashboards stay within the company's perimeter.
- Dashboards are embedded in the product, so management analytics is part of OSNO-VA, not a separate BI tool.
Results
The management layer became more transparent to business and easier to maintain for the team.
- Business roles now have P&L and management reporting they trust for decisions, replacing manual Excel reconciliations.
- Role-based access replaced manual exports: users open their own data slice themselves.
- Data stays on the customer's own perimeter — a self-hosted path with no dependency on proprietary BI.
- The BI layer lives as part of OSNO-VA, not as a one-off dashboard project.
Summary
Most contractors sell Apache Superset as dashboard consulting. KT.Team runs its own product on it — OSNO-VA management accounting — so it selects and maintains the BI engine as part of an ai-native perimeter, not as a one-off reporting delivery.
