Author(s) :

Saniya Shafi Ahmed Shaikh.

Volume/Issue :

Abstract :

Small organizations often rely on messy, inconsistent spreadsheets that limit analytics quality. This paper presents a Mini Lakehouse architecture built using DuckDB, Parquet, and Python, with Looker Studio dashboards. The workflow ingests Excel data, performs structured cleaning, builds a star schema, enforces data quality checks, and stores curated data in Parquet/DuckDB. This fully local, low cost pipeline provides reproducible, auditable analytics without cloud infrastructure. The result is a governed, BI ready system suitable for small teams and academic environments.

No. of Downloads :

0