This project provides a comprehensive analysis of Shopify sales, customer distributions, and product performance. By processing raw transactional data, the analysis uncovers purchasing patterns, geographical revenue drivers, and product category trends to optimize inventory management and marketing strategies.
Microsoft Excel: Initial data exploration and structural verification.
Power BI: Interactive dashboard creation and data visualization.
-
Total Revenue & Volume: Generated $4.18M in total sales across 6,987 total orders, maintaining an average order value of $598.
-
Top Performing Category: Running Shoes dominated sales, contributing $1.47M (35% of total revenue) with 2,460 units sold.
-
Geographical Hotspots: The United States represents the primary market, with Texas leading state-level revenue at $488K, closely followed by California at $444K.
-
Preferred Payment Gateways: Shopify Payments is the preferred choice for customers, capturing $1.52M in transactions, while Bogus (test/other) gateways accounted for $1.37M.
Insight: Running Shoes and Walking Shoes generate over 60% of total revenue.
- Action: Allocate higher inventory budgets to these two categories to prevent stockouts during peak demand cycles.
Insight: Texas, California, and Florida contribute disproportionately to overall sales.
- Action: Launch localized digital ad campaigns and exclusive regional promotions in these high-performing states to maximize ROI.
Insight: Shopify Payments is the top legitimate revenue driver, but manual and alternative payment methods still hold significant share.
- Action: Streamline the Shopify Payments checkout experience and offer targeted incentives (e.g., minor discounts or faster shipping) to migrate manual payment users to automated gateways.