Products Returns Analysis Dashboard (Power BI)

Products Returns Analysis Dashboard (Power BI)Products Returns Analysis Dashboard (Power BI)

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

Shreya Gola

• Nov 7

Products Returns Analysis Dashboard (Power BI)

Data Analysis Data Visualization Microsoft Excel Microsoft Power BI

Mahammadali Mammadov

• Nov 7

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

Data Analysis Data Visualization Statistics Matplotlib pandas Python

Eros C.

• Nov 7

Logging every cleaning action is the part I like most: when a number in the report looks strange, you can follow it back to the fix that changed it. With 585 issues, how did you decide which ones the script fixes alone and which ones it only reports?