Phone Search Dashboard

Goal: To conduct a comprehensive market analysis of smartphone data, focusing on key performance indicators such as total sales volume, brand market share, price distribution,and average star ratings across different price levels Tools Used: Microsoft Excel Key Insights: Market Share: Samsung is the market leader in this dataset, accounting for the largest share of the total sales volume (36.77%). The combined market share of Samsung, iPhone, and Other brands accounts for over 75% of the total volume. Pricing & Distribution: The price distribution analysis reveals that the majority of products fall into the lowest price bins (e.g., $7.99 - $57.99), indicating a highly competitive or budget-focused market. Price Difference Trend: The chart showing the "Difference between original & price by brands" indicates significant pricing strategies and discounts being applied across various brands. Customer Satisfaction: Customer satisfaction is relatively consistent across all price levels (high, mid, and low), with average star ratings clustered between 3.7 and 4.0. This suggests that quality perception is stable despite price variations