E-commerce profitability audit

Analyzing cost structure and profit margins

Goal: Evaluate the real profitability of an e-commerce business by analyzing order revenue, logistics costs and refund activity.

What I Did: Cleaned and merged multiple operational datasets, then created new metrics such as total cost, net revenue and profit margin to reconstruct the financial performance of each order.

Outcome: Built a profitability analysis and dashboard highlighting how logistics costs and refunds impact overall margins.

Operational Data Tables

Overview of the operational datasets used for the analysis. The project relies on separate tables containing order revenue, logistics and shipping costs, and refund transactions, which will later be merged to perform profitability analysis.

All projects