SALES DASHBOARD USING POWER BI

OVERVIEW:

This project focuses on analyzing mobile sales performance using an interactive Power BI dashboard. The analysis covers key metrics such as total sales, total transactions, quantity sold, average transaction value, and brand-wise performance. The dashboard also highlights city-level sales distribution, customer ratings, top mobile models, and payment method trends.

Through this dashboard, I aimed to identify top-performing regions, best-selling mobile models, customer preferences, and patterns that can help improve sales strategy and customer satisfaction.

 TOOLS USED:

• Excel (source data)
  
  

• Power Query (cleaning & transformation)
  
  

• Power BI Desktop (dashboard & visuals)
  
  

• DAX Measures (Sales, Quantity, Avg Value)
  
  

• Visualization tools: Map, Bar, Pie, KPI Cards

DASHBOARD SUMMARY:

This Power BI dashboard provides a complete overview of mobile sales performance across different cities, brands, and payment methods. It highlights key KPIs such as total transactions, total sales, average transaction value, and total quantity sold. The visuals help identify high-performing mobile models, customer rating patterns, and preferred payment options, enabling better sales and marketing decisions. 

 SOME SNAPSHOTS OF THE INSIGHTS:

From the dashboard, I found that the mobile store recorded 4 million total transactions, generating 473 total sales with an average transaction value of 38K. The total quantity sold also stands at 473 units, indicating that most transactions involved individual mobile purchases with a consistent product movement pattern .

From the payment method distribution, I found that Debit Card is the most preferred option (36.36%), showing that customers rely heavily on direct and secure bank transactions. Credit Card (27.25%) is the second most popular choice, indicating a moderate use of card-based payments.

Cash payments (20.5%) are still used by a portion of customers, suggesting that offline or traditional payment habits remain.
UPI has the lowest share (15.9%), which shows that digital wallet or instant-pay adoption is comparatively lower in this dataset.

Overall, customers prefer simple, card-based payments, with Debit Card emerging as the dominant method.

The iPhone SE shows the highest sales, followed by the Vivo V20 and Galaxy S21. This indicates that customer preference is strongest for premium and mid-range models, while other models have lower market traction. 

From the rating distribution, I found that the majority of customers gave a BEST rating (58), which shows strong satisfaction with the mobile products and overall buying experience. AVERAGE ratings (23) indicate that some customers had a neutral or acceptable experience, while POOR ratings (15) highlight specific cases where the product or service did not meet expectations.

.

CONCLUSION:

Through this Power BI dashboard, I analyzed multiple aspects of mobile sales performance, including overall KPIs, payment method distribution, customer ratings, and model-wise sales trends. I also reviewed city-level variations to understand regional patterns, although only the most impactful visuals have been included here for clarity and focus.

From this analysis, I found that customer payments are dominated by debit cards, the iPhone SE leads in model-wise sales, and overall customer satisfaction remains strong with the highest number of BEST ratings. These insights provide a clear understanding of customer behavior, product demand, and areas where sales strategies can be improved for better performance.