I built an e-commerce profitability dashboard in Power BI covering 5,873 orders and €640.42K in net sales. I defined the business questions and KPIs for finance, marketing, operations, and inventory stakeholders.
Across its four pages, I wrote DAX measures for net sales, contribution margin, average order value, return rate, on-time delivery, and lost sales. The analysis found a 46.3% margin for Beauty and a 2.8% margin for Electronics.
In my marketing and customer acquisition project, I analyzed 2,200 customers across channels, campaigns, and customer value. I found that Organic Search returned €33.2K on about €1.5K in marketing cost, while Paid Social used 52% of the €29.9K spend.
During the PwC Job Simulation on the Forage Platform, I built call center and churn dashboards in Power BI. My work included analyzing customer satisfaction, churn risk, and retention KPIs.
