The Mobile Sales Dashboard is an interactive Power BI project built to analyze mobile phone sales data and transform raw transactional data into meaningful business insights. The dashboard enables users to monitor sales performance, identify top-performing brands, understand customer behavior, and analyze sales trends across different cities and time periods.
This project demonstrates practical data analysis skills including data cleaning, data modeling, DAX calculations, and dashboard design using Power BI.
- Analyze overall mobile sales performance.
- Track monthly and yearly sales trends.
- Compare sales across different mobile brands.
- Understand customer purchasing behavior.
- Analyze payment method preferences.
- Monitor customer satisfaction through ratings.
- Build an interactive dashboard for business decision-making.
- Microsoft Power BI
- Microsoft Excel
- Power Query
- DAX (Data Analysis Expressions)
The dataset contains mobile sales transactions with information such as:
- Transaction ID
- Date
- Brand
- Mobile Model
- Units Sold
- Price Per Unit
- Total Sales
- Customer Name
- Customer Age
- City
- Payment Method
- Customer Ratings
Data preparation was performed using Power Query before creating the dashboard.
- Removed duplicate records
- Checked for missing values
- Corrected data types
- Renamed columns
- Verified numerical fields
- Cleaned inconsistent values
- Prepared the data for analysis
The dashboard includes:
- Total Sales
- Total Quantity Sold
- Average Customer Rating
- Total Transactions
- Monthly Sales Trend
- Brand-wise Sales Comparison
- City-wise Sales Analysis
- Payment Method Distribution
- Customer Analysis
- Time-based Sales Analysis
- Month
- Brand
- City
- Payment Method
Users can interact with the dashboard to explore data dynamically.
Some of the DAX measures created include:
- Total Sales
- Total Quantity
- Average Rating
- Total Transactions
These measures provide dynamic calculations based on user-selected filters.
The dashboard helps answer questions such as:
- Which mobile brand generates the highest sales?
- Which month records the highest revenue?
- Which cities contribute the most to sales?
- Which payment method is most preferred?
- How satisfied are customers based on ratings?
- What are the overall sales trends?
This dashboard helps businesses:
- Monitor sales performance
- Identify high-performing products
- Understand customer preferences
- Improve marketing strategies
- Support data-driven decision-making
- Data Cleaning
- Data Transformation
- Data Modeling
- DAX Calculations
- Data Visualization
- Dashboard Design
- Business Intelligence
- Analytical Thinking
- Profit Analysis Dashboard
- Sales Forecasting
- Customer Segmentation
- Drill-through Reports
- Mobile Brand Performance Comparison
- Inventory Analysis
Dipanjan Pramanik
Aspiring Data Analyst passionate about transforming raw data into meaningful insights through Excel, SQL, Power BI, Python, and Tableau.
- LinkedIn: (Add your LinkedIn profile link)
- GitHub: (Add your GitHub profile link)