Market Competition Intelligence Dashboard
This interactive Power BI dashboard provides a comprehensive overview of marketing channel performance, regional sales, and manufacturer competitiveness within a fictional consumer electronics industry. Designed for strategy teams and senior stakeholders, it consolidates high-level KPIs with drill-down capabilities for data exploration across geography, product lines, and satisfaction metrics.
Description (Link to Dashboard)
Regional Sales Analysis & Competitive Manufacturer Benchmarking
-
Uses treemaps and geo-visualizations to identify high-performing macro-regions (East, Southwest) and provinces in China.
-
Channel mix across locations is visualized with pie markers, offering insights into regional marketing effectiveness and customer reach.
-
Evaluates each manufacturer’s income share and market trend over multiple years.
-
Trend lines of market share and quantity sold reveal long-term performance patterns and emerging shifts in dominance.
YOY & Product Satisfaction Analysis
-
Combines monthly trend lines and income bars to show seasonality in revenue, with peaks in Q4 indicating strong year-end sales performance.
-
Satisfaction scores (avg. 69.61) by product type and manufacturer help evaluate brand perception and product strategy.
Tools & Techniques
-
Power BI: Interactive dashboards, DAX, drill-through filters, slicers
-
Data Modeling: Channel and product segmentation, time-based measures
-
KPI Reporting: Income trends, YoY analysis, satisfaction scoring
-
Geo-Mapping: Sales by province visualized with pie maps