Business Intelligence and Forecasting Platform
Sales Analytics System
A full-stack business intelligence pipeline that automates data ingestion, ETL cleaning, warehouse storage, forecasting, anomaly detection, and dashboard reporting.
Challenge
Design a single system that could take raw sales data, clean and structure it, run useful statistical analysis, and present the results through both a dashboard and API.
Solution
Built an end-to-end Python pipeline with ETL preprocessing, star-schema storage in SQLite, ARIMA forecasting, RFM segmentation, anomaly detection, a Streamlit dashboard, and a Flask API for reusable access.