Forma Active Ecommerce Pipeline End-to-End Ecommerce

Forma Active Ecommerce Pipeline End-to-End Ecommerce Analytics Pipeline (Shopify → PostgreSQL → dbt → Tableau) Built a full end-to-end analytics pipeline for an e-commerce dataset, simulating a real production data stack from extraction to visualization.

The project started with Shopify-style order data and progressed through a complete modern data engineering workflow.

Key work included:

Extracted and transformed Shopify-like order data using Python (json_normalize, explode for nested structures)

Built a relational PostgreSQL database (Neon) for structured storage

Modeled data using dbt with staging and mart layers

Implemented data quality tests (uniqueness, null checks, referential integrity)

Created analytics-ready models for revenue, customers, and product performance

Built a Tableau dashboard with multiple views:

Final output: a production-style analytics system from raw data ingestion to business-ready dashboards.

This project demonstrates full-stack analytics capability: data engineering, modeling, and visualization.