Data EngProduction

Marketing Analytics ETL

Marketing analytics dashboard with real-time KPIs, campaign tracking, and cross-platform attribution.

View Code Live Demo
Live
Public Demo
ECharts
Visualizations
DuckDB
Analytics Engine
Real-time
KPI Dashboard
Marketing Analytics ETL — demo

Professional marketing analytics ETL pipeline with a live Streamlit dashboard. Ingests TheCocktailDB data as a proxy for marketing events, transforms via DuckDB, and renders KPIs, campaign performance, and cross-platform attribution in an ECharts-powered UI.

The only project in this portfolio with a public live demo. Click the button.

Tech Stack

PythonStreamlitEChartsPandasDuckDBETL

Features

Live Demo

Publicly deployed on Streamlit Cloud. See the full dashboard without any setup.

ECharts Viz

Apache ECharts for interactive charts — funnel, bar, line, scatter, all responsive.

DuckDB Analytics

In-process analytics engine. Sub-second aggregations over marketing event tables.

Attribution Model

First-touch, last-touch, and linear attribution models computed in DuckDB SQL.

How It Works

01
Extract
TheCocktailDB API → pandas raw DataFrames
→
02
Transform
DuckDB SQL → KPI aggregations, attribution calculations
→
03
Load
In-memory DuckDB → Streamlit session state
→
04
Visualize
ECharts components render live, interactive marketing dashboard