How It Works

Warehouse-Native Forecasting

StratTab runs in your cloud environment and writes predictions directly to your data warehouse. Customer × product × week granularity. No data leaves your infrastructure.

Core Technology

Synthetic Fact Table

StratTab generates a sparse synthetic fact table at customer × product × week granularity. Each row contains purchase probability and expected units — predictions in the same format as your historical transactions.

  • Mirrors your existing transaction table structure
  • Sparse representation (only plausible combinations)
  • Purchase probability + expected units
  • Query with standard SQL joins
Architecture

Warehouse-Native

Our container deploys in your cloud environment with read-only access to source tables. Predictions write to your analytics schema. Your data never leaves your infrastructure.

  • Customer-hosted container deployment
  • Read-only source table access
  • Write predictions to your warehouse
  • No data ever leaves your environment
The Process

From Data to Decisions

Three simple steps to transform your forecasting

1

Deploy In Your Environment

StratTab runs as a container in your cloud environment with read-only access to your data warehouse. Your data never leaves your infrastructure.

Note: Compatible with Snowflake, BigQuery, Databricks, and Postgres. Setup takes under an hour.

2

We Build Your Forecast Model

Our AI analyzes purchase patterns at the customer × product × week level, generating a sparse synthetic fact table with purchase probabilities.

Note: Hierarchical reconciliation ensures forecasts are consistent from the top line down to individual SKUs.

3

Get Predictions In Your Warehouse

Receive forecasts directly in your data warehouse. Query via SQL, power your email campaigns, and optimize inventory decisions.

Note: Predictions write to your analytics schema. Use any BI tool or downstream system you already have.

Integrations

Connect Your Stack

Seamless integrations with your existing e-commerce platform

S

Snowflake

Native connector for Snowflake data warehouses. Deploy as a container with read-only access to source tables.

  • Container deployment
  • Read-only source access
  • Write to analytics schema
  • No data export required
B

BigQuery

Full support for Google BigQuery. Deploy in your GCP project with secure service account authentication.

  • GCP-native deployment
  • Service account auth
  • Project-scoped access
  • BigQuery ML compatible
P

Postgres

On-premise or cloud Postgres support for smaller deployments and development environments.

  • Self-hosted option
  • Docker deployment
  • Connection pooling
  • AWS RDS compatible
Features

Everything You Need

Purpose-built capabilities for non-subscription e-commerce forecasting

Warehouse-Native Deployment

Runs in your cloud environment. Your data never leaves your infrastructure. No security review nightmares.

Customer × Product × Week Forecasting

Granular predictions at the individual customer and product level. Not aggregate SKU guesses.

Synthetic Fact Table Output

Predictions in the same format as your transaction tables. Query with SQL. No black boxes.

Hierarchical Reconciliation

Bottom-up forecasts that sum correctly to top-line targets. Consistent across all aggregation levels.

Intermittent Demand Handling

Purpose-built for sporadic, non-subscription purchase patterns that break traditional models.

SQL-Native Integration

Join predictions to your existing dimension tables. Works with any BI tool or downstream system.

Ready to See It In Action?

Get a personalized demo and see how StratTab can transform your demand forecasting.

Request a DemoView Pricing