Challenge brief

<p data-start="559" data-end="898">You’ve been provided with a dataset of global <strong data-start="605" data-end="632">e-commerce transactions</strong> covering multiple products, plans, and customer segments.<br data-start="690" data-end="693" />Your objective is to create an analytical report and visualization dashboard that identifies <strong data-start="786" data-end="805">loyal customers</strong>, evaluates <strong data-start="817" data-end="833">sales trends</strong>, and uncovers <strong data-start="848" data-end="867">revenue drivers</strong> to inform business strategy.</p> <p data-start="900" data-end="939"><strong data-start="900" data-end="937">Questions to guide your analysis:</strong></p> <ul data-start="940" data-end="1632"> <li data-start="940" data-end="979"> <p data-start="942" data-end="979">How do total sales change by month?</p> </li> <li data-start="980" data-end="1043"> <p data-start="982" data-end="1043">Which channels bring in the most sales and loyal customers?</p> </li> <li data-start="1044" data-end="1103"> <p data-start="1046" data-end="1103">What percent of monthly sales comes from repeat buyers?</p> </li> <li data-start="1104" data-end="1158"> <p data-start="1106" data-end="1158">Which products or plans generate the most revenue?</p> </li> <li data-start="1159" data-end="1217"> <p data-start="1161" data-end="1217">Which products are most popular among loyal customers?</p> </li> <li data-start="1218" data-end="1279"> <p data-start="1220" data-end="1279">How long do customers take to make their second purchase?</p> </li> <li data-start="1280" data-end="1348"> <p data-start="1282" data-end="1348">Which discount codes are used most, and do they improve loyalty?</p> </li> <li data-start="1349" data-end="1416"> <p data-start="1351" data-end="1416">What is the average selling price (ASP) by country or currency?</p> </li> <li data-start="1417" data-end="1479"> <p data-start="1419" data-end="1479">Where do refunds occur most often (by product or channel)?</p> </li> <li data-start="1480" data-end="1555"> <p data-start="1482" data-end="1555">Do annual plans deliver higher revenue per customer than monthly plans?</p> </li> <li data-start="1556" data-end="1632"> <p data-start="1558" data-end="1632">Which add-ons are most commonly bought with core products (attach rate)?</p> </li> </ul> <p data-start="1634" data-end="1854">Your challenge is to build a <strong data-start="1663" data-end="1710">clear, insightful data visualization report</strong> that reveals repeat-purchase behavior, pricing impact, and campaign effectiveness — helping stakeholders make smarter, data-driven decisions.</p>