Distribution / Histogram
Or click any column in the Schema tab.
Correlation Matrix
Pearson correlations between numeric columns.
Forecast
Aggregate by date and project a linear trend N periods forward.
Outlier Detection (IQR)
Flag rows where the column is outside Q1−1.5·IQR or Q3+1.5·IQR.
Period-over-Period
Bucket a metric by time period and compute lift between periods.
Group-by Builder
Quick aggregation without writing SQL.
Two-Sample T-Test
Compare means of a numeric column between two groups in a categorical column.
Join Tables
Visual join builder. Preview, then save the result as a new table.
Cohort Retention
Group users by signup period and track retention over time.
Linear Regression
OLS fit. Returns coefficients, R², and a scatter + fit line chart.
Pareto / 80-20
Sort categories by metric and find the top contributors driving 80% of total.
A/B Test Sample Size
Required sample size per variant for a two-proportion z-test.
Funnel Analysis
Conversion through ordered steps. Each step is a value in the event column.
Window Functions
Generate window function SQL without writing it.
Quantile Bucketing
Bin a numeric column into N equal-frequency buckets and add the result as a new column.
Normalize Column
Add a standardized version of a numeric column.
Geographic Map
Plot points from a table with latitude/longitude columns.
Sankey Flow Diagram
Visualize flows between source and target categories.
Survival Curve (Kaplan-Meier)
Estimate survival probability over time. Time = duration observed, Event = 1 if churned/died, 0 if censored.
Multi-variable Regression
OLS with multiple X columns. Returns coefficients and R².
Chi-Squared Test
Test independence between two categorical columns.
Data Dictionary
Auto-generated documentation of every column. Inline notes are saved to localStorage.
Data Engineering
Date Dimensions
Explode a date column into year, quarter, month, week, day-of-week, day-of-month, day-of-year, is_weekend.
Sessionization
Group events into sessions by user. New session when the gap between events exceeds N minutes.
Rolling Window
Add a rolling-window aggregate column (e.g. 7-day moving average).
K-means Clustering
Cluster rows into K groups based on selected numeric columns. Adds cluster_id column. Features are z-scored.
Quality
Data Assertions
Each line: description | SQL that should return 0 rows. Saved to localStorage. Run any time to validate the data.
Visualization
Treemap
Hierarchical area chart. Each rectangle's size is proportional to the metric.