XLTable Blog
Articles & Insights
Practical articles about Excel, OLAP, XMLA, and modern Big Data analytics.
A Semantic Layer That Reads as SQL
Why a cube definition should be an executable SQL query, not a YAML description of one — and why that matters for your database, your team, and AI assistants.
Excel Is Still the #1 Self-Service Analytics Tool. Here's Why That's Not a Problem Anymore.
Why business users keep defaulting to Excel despite BI investments — and how a modern semantic layer turns this behavior into an architectural advantage.
XLTable + Snowflake: From Zero to Pivot Table in 15 Minutes
A step-by-step guide to connecting Excel to Snowflake with XLTable using ready-made sample data — no custom setup required.
Snowflake to Excel: Pivot Tables Without BI Tools
Learn how to connect Snowflake to Excel Pivot Tables without CSV exports or BI tools using an OLAP semantic layer.
XLTable: OLAP Experience in Excel on Modern Data Warehouses
Learn how XLTable brings the classic OLAP Excel experience to modern data warehouses like Snowflake, BigQuery, and ClickHouse using XMLA and MDX.