OLAP for Modern Data
Big Data meets Excel. Reinvented with XLTable.
Connect Excel to ClickHouse, BigQuery, and Snowflake through an XMLA-compatible OLAP server. Power PivotTables with large datasets — without SQL and without rewriting reports.
Architecture
Excel
PivotTables powered by MDX/XMLA.
XLTable OLAP Server
- • Translates MDX into SQL
- • Provides XMLA endpoint
- • Handles measures & dimensions
- • Aggregates big datasets
Model once in XLTable. Explore everywhere in Excel.
What is XLTable?
XLTable is an OLAP server that connects modern analytical databases to Excel. It exposes your data models through the XMLA protocol, so Excel sees them as OLAP cubes, similar to Microsoft Analysis Services — but with backends like ClickHouse, BigQuery, and Snowflake.
How XLTable works
XLTable sits between Excel and your analytical databases, translating MDX into SQL and returning aggregated results directly to PivotTables.
- 1. Define data sources. Connect ClickHouse, BigQuery, Snowflake or other SQL engines.
- 2. Model measures & dimensions. Use SQL to define cubes.
- 3. Connect Excel via XMLA. No plugins, no extensions — Excel connects natively.
- 4. Explore data in PivotTables. Users drag-and-drop; XLTable handles SQL.
Data Flow
Excel
XLTable
ClickHouse
Features & benefits
Excel-native analytics
Users stay in Excel. No retraining.
Big Data backends
ClickHouse, BigQuery, Snowflake and others.
No SQL for end-users
Model once; explore everywhere.
XMLA compatible
Works like Microsoft Analysis Services.
Flexible cube modeling
Define measures, hierarchies, and attributes.
Secure by design
Keep data inside your infrastructure.
Multiple measure groups, hierarchies, and dimensions
Combine multiple fact and reference tables into a unified analytical model.
LDAP / Active Directory integration
Manage authorization through enterprise AD groups with seamless role mapping.
Fine-grained access control
Restrict user access to specific measures, dimensions, or individual members.
Supported databases
Any SQL backend that supports aggregation can be used as a data source.
ClickHouse
BigQuery
Snowflake
Trino
Documentation
Full documentation is available on Read the Docs, including installation, configuration, cube modeling, and Excel integration.
- • Installation & deployment
- • Data source configuration
- • Cube modeling (measures & dimensions)
- • Excel + MDX
- • Security & permissions
Ready to bring Big Data into Excel?
Contact us for a demo, integration guidance, or support.