Skip to main content
Exploratory data analysis (EDA) is usually the first step in any data workflow. Sourcetable automates the tedious parts — profiling, distribution analysis, and correlation — so you can jump straight to insights.

​
Automated data profiling

Ask the AI to profile your dataset and it generates a comprehensive summary:
The AI examines every column and reports:
  • Data types — numeric, categorical, datetime, text, boolean
  • Missing values — count and percentage per column
  • Unique values — cardinality for each column
  • Basic statistics — mean, median, mode, std dev, min, max, quartiles
  • Distribution shape — skewness and kurtosis for numeric columns

​
Distribution analysis

The AI generates histograms, box plots, or violin plots depending on your data. It identifies:
  • Normal vs. skewed distributions
  • Outliers beyond 1.5x IQR
  • Bimodal or multimodal patterns
  • Log-normal distributions common in financial data

​
Correlation analysis

Sourcetable calculates Pearson, Spearman, or Kendall correlations and renders an interactive heatmap. It highlights:
  • Strong positive correlations (> 0.7)
  • Strong negative correlations (< -0.7)
  • Multicollinearity between features
  • Unexpected relationships

​
Automated insights

The AI scans your dataset and surfaces:
  • Columns with high missing value rates
  • Highly correlated feature pairs
  • Categorical columns with imbalanced classes
  • Temporal trends and seasonality
  • Potential data quality issues (duplicates, inconsistent formats)

​
Example prompts