The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
this project is a Pizza Sales Performance Analysis designed to help a pizza restaurant optimize its operations, marketing, and inventory management.By analyzing sales trends, peak hours, and product popularity, the project uncovers data-driven insights to maximize profitability
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
End-to-end retail analytics pipeline that turns raw, messy CSV exports into business decisions, built in Python and SQL and runnable with one command.
What it does:
Cleans and validates 6 relational tables, fixes 585 data-quality issues and logs every action
Loads a SQLite warehouse with keys, constraints and window-function SQL
Customer analytics: RFM segmentation, cohort retention, CAC / LTV by channel, product Pareto, market-basket analysis
Churn prediction model validated on future data (ROC-AUC 0.71, no data leakage)
6-month revenue forecast, best of 3 models by backtest (4.2% MAPE)
Auto-generated Excel report (live formulas, native charts) and an interactive Streamlit dashboard
18 automated tests
Membership & Returns Analytics Dashboard (Power BI)
Built a complete SQL Server (T-SQL) data warehouse for a fictional multi-channel, multi-currency retailer (synthetic dataset created for demonstration purposes). Delivered: staging layer loaded from 17 CSV files (~397K rows); one transactional, re-runnable ETL stored procedure that cleans duplicates, mixed date formats and inconsistent labels; a star schema with keys and constraints; reporting views with business rules defined once (net revenue in USD, contribution margin); automated data-quality tests; and 17 analytical queries (cohort retention, RFM segmentation, Pareto/ABC, constant-currency growth, carrier failure alert, inventory health, CAC vs platform claims, budget vs actual). Key insight: marketplace shows 51% gross margin but only 24.5% contribution margin after commission, shipping and refunds.
