Ecommerce Analysis

Summary

Report submitted for FP20 Analytics ZoomCharts Challenge 19 (September 2024). The report was built with the E-commerce KPI Analysis dataset and includes ZoomCharts custom Drill Down PRO visuals for Power BI. 

Author's description:
Key Actions and Recommendation
Optimize Marketing Spend: Reallocate marketing budget towards high-performing categories and peak months to maximize customer acquisition and sales.
Plan Promotional Campaigns: Develop and execute promotional campaigns for weekdays with lower sales to drive more consistent order volumes.
Adjust Inventory Levels: Based on category performance and customer demand trends, adjust inventory levels to avoid stockouts or overstocking.
Revenue Diversification: Explore opportunities to diversify revenue streams by introducing new products or services that align with customer needs. Retention Strategies: Implement loyalty programs, personalized offers, and excellent customer service to reduce churn and retain customers.
Purchase History: For high-value customers offer them exclusive discounts. Since repeat customers are a significant part of sales, implement loyalty programs or personalized marketing to enhance customer retention. This could include special discounts, early access to new products, or exclusive offers.