Tokopaedi Sales Dashboard — Looker Studio
Developed an interactive 2-page sales performance dashboard for the 2022 Tokopaedi dataset using Looker Studio. By transforming raw transactional data into visual insights, the study monitored monthly revenue trends, evaluated campaign effectiveness, and identified critical efficiency gaps to optimize profit margins and customer retention. Executed comprehensive data preparation in Excel (null/duplicate cleaning) and engineered calculated fields in Looker Studio including Net Profit and AOV to enable deep-dive analysis through interactive slicers. Visualized Rp 5.1B in gross sales and Rp 1.1B in net profit, representing 8,276 units sold across 3,168 unique customers throughout the 2022 fiscal year. Identified Aug–Sep as the peak performance period driven by a surge in AOV and highlighted a 70%+ reliance on cash payments, resulting in strategic recommendations to accelerate digital payment adoption and Q4 retention.
View ProjectTokopaedi 2022 transactional data was raw and unstructured; the business needed to monitor revenue trends, evaluate campaigns, and identify efficiency gaps to optimize profit margins and retention.
Transform raw transactional data into visual insights to monitor monthly revenue, evaluate campaign effectiveness, and identify critical efficiency gaps for profit and retention optimization.
Data preparation in Excel (null/duplicate cleaning); engineered calculated fields in Looker Studio (Net Profit, AOV); built interactive 2-page dashboard with slicers for deep-dive analysis.
Visualized Rp 5.1B gross sales and Rp 1.1B net profit (8,276 units, 3,168 customers). Identified Aug–Sep as peak period driven by AOV surge; highlighted 70%+ cash payment reliance. Strategic recommendations: accelerate digital payment adoption and Q4 retention.