Mobile Sales Analysis Dashboard

Overview

Developed an interactive Mobile Sales Analysis Dashboard in Power BI to analyze sales performance across cities, products, payment methods, and customer behavior. Performed data cleaning and transformation using Power Query, built a structured data model, and created dynamic DAX measures to deliver actionable business insights through interactive visualizations.

Features

Interactive dashboard with Overall Performance, Sales Trends, Product, Geography, Payment, and Customer Analysis
Data cleaning and transformation using Power Query
Dynamic KPIs for Total Sales, Transactions, Quantity Sold, and Average Sales
Time-based analysis with monthly, daily, and weekday trends
City-wise sales visualization across India
Product performance and top-selling mobile model analysis
Payment method analysis (UPI, Card, and Cash)
Customer rating distribution and satisfaction insights
Interactive slicers for dynamic filtering and exploration

Technologies Used

Power BI
Power Query
DAX (Data Analysis Expressions)
Data Modeling
Microsoft Excel (Data Source)

Outcome

The dashboard transforms raw sales data into meaningful business insights, enabling users to monitor performance, identify sales trends, evaluate customer behavior, and make informed business decisions through an intuitive and interactive reporting interface.