Python • Flask • PostgreSQL • React

Full-Stack Business Data Pipeline

A two-repository full-stack project that combines automated ETL processing with a creator analytics dashboard. Raw business data is cleaned and loaded into a PostgreSQL warehouse, then surfaced through authenticated product views for real-time performance tracking and growth insights.

Project Overview

This project reflects the combination of two related repositories into one end-to-end business analytics system. The backend ETL layer handles data extraction, normalization, and warehouse loading, while the dashboard layer turns that curated data into a product experience for creators who need timely, actionable performance insights.

Core Contributions

2 Combined Repos
90% Manual Cleaning Reduced
JWT Secure Access
SQL Analytics Queries

System Architecture

ETL Repository

Dashboard Repository

Dashboard Features

Performance Tracking

Shows creators real-time views of business and content performance.

JWT Authentication

Protects dashboard access through authenticated sessions.

Warehouse-Backed Queries

Reads from curated warehouse data instead of raw source files.

Growth Insights

Transforms processed data into decisions creators can act on quickly.

End-to-End Workflow

Technologies Used

Python ETL Logic
Flask Backend
PostgreSQL Warehouse
React Frontend