Power BI dashboard: Analyzing Retail Camera Sales / Revenue / Profit
This Power BI dashboard involved analyzing sales, revenue, and units sold data for an electronics retail store across 4 countries, with a focus on uncovering trends and actionable insights to optimize operational efficiency and decision-making.
Key Insights:
- Highest Performing Country:France recorded the highest Revenue of $24K, with Spain , China and Kenya rounding up the top 4.
- Highest Performing Product:Instant Camera's were sold the most with a revenue of $12K with CCTV Camera's DSLR Cameras and Point & Shoot Cameras rounding up the top 4.
- Best Customer Type:Returning customers purchased the most number of cameras, 6000, across all countries compared to new customers
Project Impact:
- This analysis provided actionable insights for management to improve profitability, streamline operations, and enhance customer satisfaction. By leveraging data-driven strategies, the electronics camera retail store could make informed decisions to optimize resource allocation, adjust pricing strategies, and enhance overall performance across all locations