Retail Intelligence Platform

Retail Intelligence Platform is an end-to-end data warehouse, business intelligence, and data mining project for retail analytics.

It transforms raw grocery retail data into a structured and validated Azure PostgreSQL data warehouse.

The project includes ETL pipelines, data cleaning, dimensional modeling, and data quality validation.

Interactive Power BI dashboards were developed for sales, products, customers, campaigns, coupons, and holiday analysis.

Customer segmentation was implemented using RFM analysis with K-Means, DBSCAN, and Hierarchical Clustering.

Market Basket Analysis was performed using Apriori, FP-Growth, and ECLAT algorithms.

The project compares algorithms based on recommendation quality, runtime, and memory efficiency.

A recommendation prototype was developed to suggest products based on association rules.

Python, SQL, Azure PostgreSQL, Power BI, Scikit-learn, and Streamlit were used throughout the project.

The platform provides actionable retail insights for customer targeting, sales analysis, campaign optimization, and product recommendations.