Portfolio / ANALYTICS_LAB

ANALYTICS LAB

Full-stack relational analytics workspace — upload multiple CSVs as named SQL tables, auto-detect join keys, run JOIN queries, build smart visualizations, and export results. Everything runs locally in your browser.

ANALYSIS ENGINE v3.0 — ONLINE · 0 TABLES LOADED

• DATA INGESTION MODULE — MULTI-TABLE UPLOAD

📦

DROP MULTIPLE CSV FILES HERE

Each file becomes a named SQL table • click to browse

            sales.csv → sales •
            products.csv → products •
            stores.csv → stores
          

CSV Format Multi-Table JOIN Browser-Only — Private

• TABLE REGISTRY

• AUTO-DETECTED RELATIONSHIPS — potential JOIN keys

Upload multiple tables to discover relationships…

TABLE

—

ROWS

—

COLUMNS

—

FILE SIZE

—

NUMERIC

—

TEXT COLS

—

• DETECTED COLUMNS — PRIMARY TABLE

• KPI DASHBOARD

• DATA PROFILING

COLUMN	TYPE	UNIQUE	MISSING	MIN	MAX	SAMPLES

• SQL QUERY ENGINE — RELATIONAL MODE

NO DATA LOADED

KW: SELECT * WHERE GROUP BY ORDER BY HAVING LIMIT COUNT SUM AVG MAX MIN ROUND DISTINCT COALESCE

JOIN: JOIN INNER JOIN LEFT JOIN ON

123456

• SMART QUERY SUGGESTIONS — click to use:

• VISUALIZATION TYPE:

Ctrl+Enter to run

ROWS RETURNED

—

EXEC TIME

—

COLUMNS

—

JOIN TYPE

—

COMPLEXITY

—

• QUERY RESULTS

• VISUALIZATION

• AUTO ANALYSIS — PRIMARY TABLE

• SUMMARY STATISTICS

• HISTOGRAM

• SCATTER PLOT

• AUTOMATED ANALYSIS NOTES

// Analysis ready. Scroll up to review statistics and charts.
// Numeric columns detected and plotted automatically.
// Upload multiple tables, then use JOIN queries in the SQL engine above.

• HOW TO USE THE ANALYTICS LAB

Upload CSVs

Drag & drop multiple CSVs at once. Each file becomes a named SQL table • sales.csv → sales. Instant profiling & KPIs.

Detect Relationships

Auto-detected JOIN keys shown before you write a query. Matching column names scored HIGH / MEDIUM confidence.

Write SQL JOINs

INNER JOIN, LEFT JOIN with table aliases. Full GROUP BY, HAVING, ORDER BY, LIMIT — COUNT, SUM, AVG, MIN, MAX, ROUND, DISTINCT, COALESCE.

Visualize & Export

Intelligent chart auto-selection. 7 chart types. Export JOIN results as CSV or Excel in one click. All data stays in your browser.