This project features a comprehensive Power BI dashboard designed to track, analyze, and optimize mobile phone sales performance across various dimensions. By aggregating data on revenue, transaction volumes, and customer behavior, the dashboard empowers retail managers and stakeholders to monitor regional trends, evaluate brand performance, and optimize payment channel strategies.
Data Visualization: Microsoft Power BI
Platform : Microsoft Excel
Analysis: DAX (Data Analysis Expressions) for custom KPIs and time-series calculations
-
Sales Overview: Generated 769M in Total Sales across 19K Total Quantity sold, spanning 4K transactions with an Average Price of 40K per unit.
-
Geographic Clusters: Major sales volume is concentrated in key Indian metropolitan hubs and Tier-1 cities, with prominent performance visible in Lucknow, Delhi, Indore, and Mumbai.
-
Brand Standings: Apple leads the pack with 161.6M in sales, followed closely by OnePlus (153.7M), Samsung (160.0M), Vivo (150.1M), and Xiaomi (143.7M).
-
Payment Preferences: Transaction methods are remarkably balanced, with UPI leading at 25.8%, followed by Credit Card (25.5%), Cash (24.7%), and Debit Card (24.0%).
-
Customer Sentiment: Funnel distributions show top-tier customer ratings capturing the majority volume, with the highest rating band accounting for 575 records.
-
Temporal Patterns: Monthly sales quantities remain steady, hovering consistently between 1,400 to 1,700 units per month, showing stable year-round demand.
Insight: Payment methods are almost perfectly split between UPI, Cards, and Cash, showing no single dominant channel.
➔ Action: Maintain strong partnerships with all payment gateways and introduce exclusive bank or UPI-specific cashback offers to incentivize higher basket values.
Insight: Apple and Samsung lead total revenue generation, but volume margins remain highly competitive across all top 5 brands.
➔ Action: Allocate prime marketing display banners and regional inventory stock to premium models (like iPhone SE and OnePlus Nord) in high-performing cities like Lucknow and Delhi.
Insight: Sales volumes drop sharply toward the end of the week (Thursday to Saturday) based on weekly sales charts.
➔ Action: Launch targeted weekend promotional campaigns or "Flash Sales" starting Thursday evenings to capture weekend consumer traffic and level out weekly revenue dips.
Insight: Customer rating drops follow a steep funnel decline.
➔ Action: Implement an automated post-purchase follow-up system for customers providing mid-to-low ratings to address service gaps and preserve brand loyalty.