Mobile Sales Dashboard Development
Pragyan Dhakal
Like this project
Posted Apr 29, 2025
Developed a Power BI dashboard for mobile sales analysis.
Likes
0
Views
0
Timeline
Apr 20, 2025 - Apr 27, 2025
Mobile Sales Dashboard
Power BI Dashboard for Analyzing Mobile Sales Performance
Project Overview
This dashboard provides a comprehensive analysis of mobile sales data across multiple dimensions, including brands, cities, payment methods, and time periods. It is designed to help stakeholders track sales performance, identify trends, and make data-driven decisions. The dashboard comprises 3 pages:
Summary Overview: High-level metrics and trends.
Sales Performance Trends: MTD, QTD & YTD Analysis.
Same Period Last Year: Total Sale and same period last year.
Key Metrics
Total Sales: 769M
Quantity Sold: 19.2K units
Average Price per Unit: 40.11K
Total Transactions: 3.84K
MTD (Month-to-Date): Tracked against historical benchmarks (e.g., 0.8M/0.9M).
Key Components
1. Filters
Mobile Model: Drill down by specific models (e.g., iPhone SE, OnePlus Nord).
Payment Method: Analyze trends across UPI, Debit/Credit Cards, and Cash.
Brand: Compare performance of Apple, Samsung, Xiaomi, etc.
Year/Quarter/Month: Temporal filtering for trend analysis.
2. Visualizations
Total Sales by City: Top contributors include Kolkata, Hyderabad, and Chennai.
Monthly Sales Trends: Peak sales in January (11.5M), gradual decline through mid-year.
Day-wise Performance: Saturdays and Mondays drive highest sales.
Top Models:
iPhone SE (60M)
OnePlus Nord (58M)
Galaxy Note 20 (56M)
3. Comparative Analysis
YoY Comparison: Compare current performance with the same period last year.
MTD Progress: Track monthly goals (e.g., Jan 2022 vs. Jul 2024).
Key Findings
1. Top-Performing Models
iPhone SE leads with 60M in sales, followed by OnePlus Nord (58M).
Samsung’s Galaxy Note 20 and Galaxy 521 contribute significantly to mid-range sales.
2. Payment Method Trends
UPI dominates transactions (26.36% share, 1.01K transactions).
Cash and Debit Cards are less preferred (≈24.7% each).
3. Monthly Sales Patterns
Sales peak in January (11.5M) and dip to 10.7M by June.
Recovery observed in July (10.9M), indicating seasonal trends.
4. City-wise Contributions
Kolkata and Hyderabad are top revenue generators.
Emerging markets like Nanjari and Oyoto show growth potential.
5. Yearly Growth
2024 sales outperform previous years, reflecting market expansion.
How to Navigate the Dashboard
Apply Filters: Use dropdowns to segment data by brand, model, or time period.
Hover for Details: Interactive tooltips provide granular insights.
Compare MTD: Check progress against monthly/yearly targets.
Switch Pages: Explore geographical, product, and payment analyses across 3 pages.
Conclusion
This dashboard serves as a strategic tool for optimizing inventory, marketing, and regional focus. For feedback or contributions, please open an issue or pull request on GitHub.