analytics-engineering

DuckDB is an embedded analytical database — SQLite for analytics. Query Parquet, CSV, and Arrow with SQL, no ETL needed.

Data engineering vs data science: what each role does, the skills and tools they need, how the work differs, and how to choose or switch between them.

dbt (data build tool) explained for data analysts: SQL-based transformations, models, tests, documentation. The modern way to build data pipelines.