XLTable lets business users pivot Snowflake and BigQuery data right in Excel—no SQL required, finally freeing data teams from 'quick' ad-hoc hell

XLTable is a new technology that brings the OLAP experience back to Excel on modern data warehouses, allowing business users to work with large datasets using familiar Excel pivot tables. The company aims to bridge the gap between the user experience of traditional OLAP systems and the power of modern columnar data warehouses such as ClickHouse, BigQuery, Snowflake, and Redshift. XLTable acts as a semantic and protocol layer, delegating aggregations and grouping to the underlying database, and supports multiple measure groups, dimensions, and hierarchies. The technology is compatible with Excel and uses XMLA and MDX standards, making it easy for users to connect and work with data without learning SQL or Python. With XLTable, all data processing happens inside the database, and performance depends on database configuration, allowing for flexible caching strategies and fine-grained access control. This solution enables business users to work independently with data, reducing the need for data engineers and analysts, and increasing decision-making speed.