What can DataBuddy do?
Live previews using the built-in sample dataset (150 employees · 24-month sales · 60 products). Click Try it to jump into the chat with the instruction pre-filled.
Charts & Analysis
6 demosSalary Distribution
Histogram · Descriptive Stats
Salary Distribution — 150 Employees
Salary Correlation Matrix
Pearson r · Heatmap
Salary Correlation Matrix
| salary | years_exp | perf_score | age | bonus_pct | |
|---|---|---|---|---|---|
| salary | +1.00 | +0.87 | +0.13 | +0.55 | +0.48 |
| years_exp | +0.87 | +1.00 | +0.00 | +0.69 | +0.43 |
| perf_score | +0.13 | +0.00 | +1.00 | -0.02 | +0.12 |
| age | +0.55 | +0.69 | -0.02 | +1.00 | +0.27 |
| bonus_pct | +0.48 | +0.43 | +0.12 | +0.27 | +1.00 |
Color: ■ positive ■ negative intensity = |r|
Monthly Revenue Trends
Area Chart · Time Series
Monthly Revenue by Region — 2023
Headcount by Level
Stacked Bar · Breakdown
Headcount by Department & Level
Multi-Method Outlier Detection
Z-score · IQR · MAD
Salary Outliers — Multi-Method Detection
| ID | Dept | Salary | Z-score | Flagged by |
|---|---|---|---|---|
| EMP-1023 | Engineering | $247,000 | +3.81 | zscoreiqrmad |
| EMP-1051 | Finance | $234,000 | +3.42 | zscoreiqrmad |
| EMP-1142 | HR | $45,000 | −3.21 | zscoreiqr |
| EMP-1089 | Sales | $228,000 | +3.11 | zscoreiqr |
| EMP-1037 | Marketing | $221,000 | +2.97 | iqr |
method="all" · 5 of 12 outliers shown · grouped by department
Price vs Rating
Scatter Plot · 60 Products
Product Price vs Customer Rating
ETL Pipeline
4 demosFull ETL Pipeline
Excel → SQL Database
Scan Excel files, infer schema, generate DDL, and load all sheets into a target database in one instruction.
“Load all Excel sheets into schema "demo" and show a summary …”
Schema Inference Only
Generate DDL · No Load
Inspect columns, infer SQL types (DATE, BIGINT, DECIMAL, NVARCHAR), and produce CREATE TABLE scripts — without touching a database.
“Infer schema and generate DDL scripts only — do not load to …”
Custom Schema & Table Names
Override Names · Schema Prefix
Rename sheets to custom table names, target a specific database schema, and load multiple files in one pipeline run.
“Load all sheets into schema "analytics". Rename the Employee…”
Ad-hoc SQL Analysis
Query · Aggregate · Explore
Run SQL queries directly against the loaded data — aggregations, joins, GROUP BY — without writing Python.
“After loading, run SQL to show: (1) avg salary by department…”