Analyzing Mobile Sales Performance with Microsoft Power BI Dashboard
Introduction
In today's data-driven world, businesses need to make informed decisions based on accurate and real-time data. Microsoft Power BI is a powerful tool that allows users to visualize and analyze data effectively. In this blog post, we will explore a comprehensive sales performance dashboard created in Microsoft Power BI. This dashboard provides valuable insights into various aspects of sales, including total sales, quantity, customer ratings, and more.
Overview of the Dashboard
The dashboard is designed to provide a holistic view of sales performance across different dimensions. It is divided into several sections, each offering specific insights:
1. Total Sales and Quantity
Total Sales: 769M
Total Quantity: 19K
Average Sales: 40K
Transactions: 4K
These metrics give a quick snapshot of the overall sales performance, highlighting the total revenue generated, the number of items sold, the average sales per transaction, and the total number of transactions.
2. Sales by Brand
The dashboard includes a table that breaks down sales by brand, showing the total quantity, total sales, and the number of transactions for each brand. The brands listed are:
Apple: Quantity - 3932, Sales - 16151740, Transactions - 783
OnePlus: Quantity - 3801, Sales - 15000000, Transactions - 705
Samsung: Quantity - 3923, Sales - 15000000, Transactions - 706
Vivo: Quantity - 3801, Sales - 15078482, Transactions - 704
Xiaomi: Quantity - 3664, Sales - 14373337, Transactions - 744
3. Sales by Mobile Model
This section highlights the sales performance of specific mobile models:
iPhone SE: 60M
OnePlus Nord: 58M
Galaxy Note 20: 58M
4. Sales by Day and Month
The dashboard provides a line chart showing total sales by day of the week and by month:
Total Sales by Day:
Saturday: 115M
Monday: 114M
Friday: 112M
Tuesday: 110M
Sunday: 108M
Thursday: 106M
Wednesday: 105M
Total Sales by Month:
January: 70M
February: 68M
March: 66M
April: 64M
May: 62M
June: 60M
July: 58M
August: 56M
September: 64M
October: 65M
November: 57M
December: 64M
5. Customer Ratings
Customer ratings are visualized using a bar chart, showing the number of ratings received:
7.4K
3.4K
2.1K
1.1K
0.3K
6. Sales by City
A map visualization shows the total sales by city, providing a geographical perspective on sales performance. Cities listed include:
Ludhiana
Delhi
Lucknow
Jodhpur
Gorakhpur
Rajkot
Mumbai
Hyderabad
Chennai
Kolkata
Bangalore
Coimbatore
Madurai
7. Transaction by Payment Method
A pie chart illustrates the distribution of transactions by payment method:
UPI: 1K (24.26%)
Debit Card: 1K (24.72%)
Credit Card: 1K (26.86%)
Cash: 1K (24.16%)
Conclusion
This Power BI dashboard provides a comprehensive view of sales performance, allowing businesses to make data-driven decisions. By analyzing sales by brand, mobile model, day, month, city, and payment method, businesses can identify trends, optimize strategies, and improve overall performance. Microsoft Power BI's powerful visualization capabilities make it an invaluable tool for any organization looking to leverage data for success.