This repository contains an advanced PostgreSQL analytics engine for a food delivery marketplace. It models platform health, optimizes logistics workflows, segments customers, tracks restaurant growth, and handles data anomalies. The database architecture includes five interconnected tables.
From the README
Zomatoadvanceanalysis Food Delivery Marketplace Operations Analytics (PostgreSQL) 📌 Project Overview This project features an end-to-end relational database analytics suite designed for a multi-tier food delivery platform. Operating on transactional data, the system models marketplace health, tracks logistics bottlenecks, segments customers based on financial baselines, and evaluates rider efficiency. The core engine handles complex real-world data anomalies, such as midnight-crossing logistics intervals and conditional cancellation metrics. 🗂️ Database Architecture The relational schema comprises 5 interconnected tables built to enforce data integrity via primary and foreign key...
Skills
- business-intelligence
- data-analytics
- feature-engineering
- postgresql
- sql
