A from-scratch beginner project that teaches the Python and SQL fundamentals an enterprise analytics platform is built on. You read and write typed Python that loads structured records, and you learn the SQL that turns raw rows into business answers. The anchor is a tiny "orders" dataset you grow step by step into a real, queryable analytics base you will later move into a warehouse.
- Python
- SQL
- Type Hints
- Dataclasses
- SQLite