Sam AvanceñaBI & Analytics
Menu

Projects

Practical work, explained clearly.

Selected case studies covering analytics, data engineering, development, and practical systems work.

Illustrative Smart Audio MusicHub setup with a Raspberry Pi appliance, browser controller, network storage, and Bluetooth speaker

Systems and self-hosting project

In development

SAM — Smart Audio MusicHub

A self-hosted music and karaoke hub combining playlist management, YouTube search, Android TV playback, network audio, and browser-based control.

  • Linux
  • Raspberry Pi
  • MPD
  • Bluetooth
View case study
Illustrative synthetic executive KPI dashboard

BI / Analytics case study

Sanitized case study

Executive KPI Dashboard Pattern

A privacy-safe BI case study showing how an executive dashboard can turn competing definitions and dense reporting into a focused decision tool.

  • Tableau
  • SQL
  • Data Modeling
  • Dashboard Design
View case study
Illustrative Project Atlas data engineering pipeline and lakehouse layers

Data engineering lab

Project preview

Project Atlas

A hands-on data engineering environment for exploring modern processing, storage, catalog, and query technologies.

  • PySpark
  • Hive
  • Trino
  • Apache Iceberg
View case study
Illustrative synthetic data quality monitoring dashboard and investigation view

BI / Analytics case study

Synthetic case study

Data Quality Monitoring Pattern

A synthetic analytics case study for turning scattered data checks into prioritized, traceable, and operationally useful quality signals.

  • SQL
  • Data Quality
  • Data Warehousing
  • Tableau
View case study