XLTable + Snowflake: From Zero to Pivot Table in 15 Minutes

XLTable + Snowflake: From Zero to Pivot Table in 15 Minutes This guide shows how to connect Excel to Snowflake using XLTable — from creating sample tables to dragging measures into a Pivot Table. No custom data required. Everything runs on a free Snowflake trial account. What You Will Build By the end of this guide you will have: A Snowflake database with realistic sales and inventory data An OLAP cube named myOLAPcube registered in XLTable A live Excel Pivot Table connected to Snowflake — no CSV exports, no BI tools Data Model Overview The sample script creates 8 tables in the olap.public schema: Table Rows Description Times 731 Calendar: every day of 2023–2024 Regions 4 Sales regions: North, South, East, West Managers 5 Sales managers linked to regions (many-to-many) Stores 8 Retail stores, each assigned to a region Models 8 Product models (Alpha … Theta) Sales 3 000 Transactions: store, model, date, quantity, amount Stock 500 Inventory snapshots: store, model, quantity on hand olap_