Tutorials
Hands-on, step-by-step guides that walk you through real-world Tova projects. Each tutorial uses real data, produces working output, and builds skills progressively.
Data Analytics
A 9-part series covering everything data professionals need — from loading CSVs to building SQLite warehouses and generating charts.
| # | Tutorial | What You'll Learn |
|---|---|---|
| 1 | Getting Started with Tables | Load CSV, inspect, filter, sort, derive columns, write results |
| 2 | Grouping & Aggregation | GROUP BY, sum/mean/median/count, multi-level grouping, pivot |
| 3 | Joins & Combining Data | Inner, left, right, outer, anti, semi joins; union |
| 4 | Window Functions | Ranking, running totals, lag/lead, moving averages |
| 5 | Data Cleaning | Dedup, null handling, type casting, validation, Result types |
| 6 | Multi-Format I/O | Excel, Parquet, SQLite; format conversion pipelines |
| 7 | Lazy Pipelines | Deferred execution, query composition, lazy iteration |
| 8 | Visualization | Bar, line, scatter, histogram, pie, heatmap charts |
| 9 | Sampling & Reshaping | Random/stratified sampling, pivot/unpivot, explode |
Prerequisites
- Install Tova
- Basic familiarity with Tova syntax
Reference
While working through tutorials, keep these references handy:
- Tables API Reference — all table functions
- Tables & Data Guide — column expressions and operation overview
- Tova for Data Professionals — tiered guide from analyst to full-stack