Report submitted for the FP20 Analytics ZoomCharts Challenge, November 2024. The report was built using the Candy Market Share dataset and includes ZoomCharts custom Drill Down PRO visuals for Power BI.

Author's description:

Summary of Report

Data Preparation:

• Explored the provided dataset, performed data cleaning and transformation using Power Query.
• Calculated a custom month column to enhance visual clarity in the report.

Visualizations and Features:

• Used a combination of bar charts, pie charts, donut charts, line charts, slicers, and card visuals.
• Incorporated ZoomCharts Drill Down Visuals for intuitive exploration.
• Added bookmarks for user-friendly navigation and enhanced interactivity.

Key Insights:

• Top 10 Candy Items: Highlighted by sales volume (weight and revenue) for 2022 and 2023.
• Monthly Sales Trend: Observed spikes in November and December for both years and dips in February 2022 and September 2023.
• Top Manufacturers:
  • Most sales volume (EUR) in 2022: Others (41.23%) and Royal Blends Group (34.91%).
  • Fewest sales volume (EUR) in 2023: Elite Sweets (1.96%).
• Popular Packaging:
  • Bag (43.81%) and unpacked (23.55%) led in sales by weight.
• Top Candy Categories: Minty Morsel Almonds (€1.20M) and Pistachio Paradise Toffee (€1.17M).
• Leading Brands:
  • Most chips sold in 2022: Land Corp (€2.9M).
  • Most chocolate-related candies sold in 2023: Silver Snacks (€1.7M).
• Profitable Distribution Channel: Small and specialty stores accounted for the highest share (20.06%).