Interactive Market Share Dashboard for FMCG Sector

Analysis Workflow

Project Overview

This project demonstrates comprehensive market intelligence capabilities through the development of an interactive Power BI dashboard analyzing the Fast-Moving Consumer Goods (FMCG) sector. The dashboard provides real-time insights into market share dynamics, competitive positioning, and sales performance across multiple dimensions.

Methodology

  • Data Collection: Aggregated market data from industry reports covering 6 months of sales performance across 3 product categories (Beverages, Snacks, Dairy) and 3 regions
  • Data Modeling: Cleaned and transformed data using Power Query, creating a robust star schema data model optimized for analytical queries
  • Dashboard Development: Designed interactive visualizations in Power BI featuring market share trends, competitive benchmarking, and regional performance analysis
  • Insights Generation: Developed automated KPI tracking and alert systems for significant market changes

Key Visualizations

Key Business Insights

  • BrandA demonstrated strongest market share growth in Beverages category, increasing from 22.5% to 27.3% over 6 months
  • Food & Beverage category shows highest market growth rate (6.1%) indicating strong consumer demand
  • Regional analysis reveals North region as highest revenue generator with €108M total sales
  • Competitive intensity remains stable across categories, suggesting mature market conditions
  • Seasonal trends identified in Q2 showing 15-20% sales uplift across all categories

Technical Implementation

Tools & Technologies:

Business Impact

This dashboard enables market intelligence analysts and business leaders to make data-driven decisions by providing immediate visibility into market dynamics. Key applications include real-time competitive monitoring, strategic planning for market expansion, performance tracking against market growth rates, and regional strategy optimization.