Mobile Sales Analytics Dashboard | Power BI

Mobile sales businesses generate significant amounts of transactional data across different brands, mobile models, customers, payment methods, and geographical locations.

Analysing this information through raw datasets and conventional reports makes it difficult for business stakeholders to understand sales performance, identify customer purchasing patterns, evaluate product performance, and compare current results with historical periods.

The key challenges included:

- Sales Performance Monitoring: Difficulty tracking overall revenue, quantities sold, average selling prices, and transaction volumes

- Product Performance Analysis: Limited visibility into sales contributions from different mobile brands and individual mobile models.

- Customer Behavior Analysis: Difficulty understanding customer ratings, purchasing patterns, and payment preferences.

- Geographical Sales Analysis: Lack of a consolidated view of sales performance across different cities.

- Time-Based Analysis: Difficulty monitoring daily sales trends and Month-to-Date (MTD) performance.

- Historical Performance Comparison: Limited visibility into sales performance compared with the same period in the previous year.

- Reporting Efficiency: Dependence on manual data analysis and conventional reporting methods.

The primary objective was to develop an interactive Business Intelligence dashboard that consolidates sales information, simplifies performance monitoring, and enables data-driven business decisions.

Developed an interactive mobile sales analytics dashboard using Microsoft Power BI, incorporating data modeling, DAX calculations, custom calendar functionality, and interactive visualizations.

The solution is organized into three dedicated analytical report pages.

1. Main Dashboard – Overall Sales Analysis

Created a centralized dashboard featuring key performance indicators and interactive visualizations.

Key Performance Indicators:

- Total Sales
- Total Quantity Sold
- Average Selling Price
- Total Transactions

Visualizations and Analysis:

- Geographical Sales Distribution—Analyze sales across different cities using a map visualization.
- Daily Sales Trend – Monitor sales quantity trends over time.
- Customer Ratings Analysis – Understand customer satisfaction through ratings and rating status.
- Payment Method Analysis – Evaluate transaction distribution across different payment methods.
- Mobile Model Performance – Compare sales performance across different mobile models.
- Sales by Day—Analyze sales patterns across different days.
- Brand Performance—Compare total sales and transaction volumes across mobile brands.

Interactive Filters:

- Date
- Mobile Model
- Payment Method
- Brand

2. Month-to-Date (MTD) Report

Developed a dedicated MTD analysis page to monitor sales performance throughout the current month.

Key capabilities:

- Month-to-Date sales tracking.
- Daily MTD sales trend visualization.
- Date-based filtering and analysis.
- Mobile model and payment method filtering.
- KPI monitoring for sales, quantity, average price, and transactions.

3. Same Period Last Year Analysis

Created a historical comparison page to evaluate current sales performance against the corresponding period of the previous year.

Key capabilities:

- Current-period versus previous-year sales comparison.
- Same period last year calculations using DAX.
- Comparative sales trend visualizations.
- Date-based historical analysis.
- Performance comparison through tables and clustered column charts.

4. Data Modelling and DAX

Organized the data model using two primary tables:

- Sales Data: Contains transactional-level information, including transaction ID, date, brand, units sold, price per unit, customer details, city, payment method, customer ratings, mobile model, and rating status.

- Custom Calendar: Provides date-related attributes for time-based analysis and reporting.

Implemented DAX measures for:
- Total Sales
- Total Quantity
- Average Price
- Transactions
- Month-to-date (MTD)
- Same Period Last Year

5. Dashboard Architecture

The overall solution follows a structured BI reporting architecture:

Raw Sales Dataset → Data Preparation → Data Modelling → DAX Measures → Interactive Visualisations → Business Intelligence Reports

The architecture enables users to explore sales performance through centralized KPIs, historical comparisons, geographical insights, and dynamic report filters.

• Microsoft Power BI Desktop
• Power Query
• DAX
• Data Modeling
• Custom Calender Table
• KPI Cards
• Interactive Slicers
• Map Visualization
• Line Charts
• Area Charts
• Bar Charts
• Pie Charts
• Funnel Charts
• Data Visualization & Business Intelligence

The Power BI solution transformed transactional mobile sales data into a centralized and interactive analytical reporting platform.

The dashboard provides business stakeholders with the ability to monitor sales performance, evaluate product contributions, understand customer behavior, and compare performance across different time periods.

Key Outcomes:

- Centralized Sales Monitoring: Consolidated essential business KPIs into an interactive dashboard.
- Product Performance Insights: Enabled comparison of mobile brands and models based on sales performance.
- Customer Insights: Provided visibility into customer ratings and payment preferences.
- Geographical Analysis: Enabled city-wise sales distribution analysis.
- Time-Based Reporting: Simplified daily and month-to-date sales monitoring.
- Historical Comparison: Enabled current-period versus same-period-last-year sales analysis.
- Interactive Data Exploration: Allowed users to dynamically filter and investigate sales data.
- Improved Reporting Efficiency: Provided a structured and reusable reporting environment for business performance analysis.

Overall Impact:

Delivered a multi-page Power BI Business Intelligence solution that brings together sales performance monitoring, product analysis, customer insights, and historical comparisons in a single interactive reporting experience.