Prabin B.

NovaMart E-Commerce Analytics

Processed and cleaned 99,000+ orders from 9 tables using Python and SQL, ensuring accurate data before starting analysis.– Found that slow delivery in the Northeast (24 days vs. 8 days in S˜ao Paulo) caused a 24% late rate that hurt sales.– Discovered only 3% of customers buy again; identified high shipping costs on cheap items as the main driver and recommended shipping discounts.– Proved that faster delivery directly improves customer reviews; used this to flag three big sellers with consistently poor ratings.– Built a 3-page interactive Power BI dashboard connected to MySQL to share these insights clearly with the team.