Databases & Data Platforms

Data modeling, SQL, and lightweight platforms: mini data marts, KPI marts, ETL/ELT, integrity checks, and pragmatic use of SQLite/DuckDB workflows.

Back to Projects

Mini Data Mart (DuckDB)

A staged DuckDB + Python mini data mart built around a star schema (dimensions + fact table), with analytics queries and export utilities.

Stage 1: Build the mart with hardcoded seed data (clean, repeatable setup).
Stage 2: Load facts (and optionally dimensions) from CSV so new data updates the mart.

DuckDB SQL Pandas ETL Data Modeling

Live / Demo

Modeling: star schema with dim_customer, dim_product, dim_date, and fact_sales.
Stage 1: repeatable rebuild using seed data in Python (drops + recreates tables).
Stage 2: CSV-driven loads so editing fact_sales.csv reflects in DuckDB after rebuild.
Exports: helper scripts write tables to data/CSV-export and data/JSON-export.
Dataset: synthetic / generated data (no real customer or production data).

Support Ticket Analytics (Ops KPIs + NLP)

End-to-end analysis of support tickets: data prep, backlog/SLA proxy KPIs, lightweight text signals, and trend dashboards. Includes a synthetic generator + ETL build script.