Peak Season Retail Analysis – Power BI 4

Holiday and Black Friday (BF) campaigns drove the majority of volume and profit, with the Holiday campaign generating the highest profit at $4.16M, while the Web channel consistently outperformed Store and Marketplace channels. Returns created the largest profit drain at $5.23M - nearly half of total profit - driven mainly by “Wrong Size” returns, defective products, and high Grocery write-offs. Despite logistics costs of $608.8K, late deliveries peaked during the Giftable season, highlighting the need to improve carrier reliability, warehouse performance, and return prevention to protect profitability.