Case Study · Lenta
~80 concurrent users, live on ClickHouse
Lenta is one of the largest retail chains in Eastern Europe. Its e-commerce analytics team works with billions of rows of transaction data in ClickHouse — and its analysts work in Excel. Before XLTable, users hit serious limits when working with large data volumes in Excel: exports, extracts, and data duplication were the daily routine.
The solution
XLTable connected Excel directly to ClickHouse through one governed semantic layer — native PivotTables over XMLA, no data duplication, no change to the familiar interface. Excel became the front end; ClickHouse stayed the single source of truth.
The results
1 day
Deployment took a single working day — no lengthy training.
~80
Concurrent users exploring ClickHouse data in Excel PivotTables.
0 copies
Live queries against ClickHouse — no extra database or BI servers.
Lower TCO
Extra servers eliminated; simpler development process for analysts.
In their words
"Before adopting XLTable, our users faced serious limitations when working with large data volumes in Excel. XLTable let us connect Excel directly to ClickHouse without duplicating data and without losing the familiar PivotTable interface.
XLTable helped us lower total cost of ownership by eliminating extra servers and simplifying the development process for analysts.
Deployment took a single working day — no lengthy training, and integration with ClickHouse removes the need for extra database servers and delivers infrastructure savings.
A perpetual XLTable license gives us full control over resources in the long term."
Stanislav Vilkov
Head of the analytics tools team · Lenta
Running ClickHouse too?
See how XLTable gives ClickHouse a semantic layer — native Excel PivotTables and AI chat, live on your data.