Supermarket Sales Analysis Dashboard using Microsoft Power BI: Uncovering Insights for Effective Marketing Strategies
View interactive dashboard: https://www.novypro.com/project/trihandayani-3
The Supermarket Sales Dashboard, created using Microsoft Power BI, offers a comprehensive view of the supermarket’s performance. It showcases the daily gross income, average product ratings by category, gross income by product category, gross income by quantity sold, and average gross income per quantity by product category. By utilizing Microsoft Power BI, the dashboard provides interactive visualizations and data-driven insights, empowering decision-makers to analyze sales trends, identify lucrative product categories, and make informed marketing strategies for business growth and success.
Introduction
The Supermarket Sales Dashboard, developed using Microsoft Power BI, provides decision-makers with a comprehensive view of the supermarket’s performance. It offers valuable insights into key sales metrics, including daily gross income, average product ratings by category, gross income by product category, gross income by quantity sold, and average gross income per quantity by product category. By leveraging the powerful capabilities of Microsoft Power BI, this interactive dashboard empowers decision-makers to analyze sales trends, identify lucrative product categories, and make data-driven marketing strategies to drive business growth and maximize profitability. With its user-friendly interface and visually appealing visualizations, the Supermarket Sales Dashboard equips decision-makers with the tools they need to make informed decisions and optimize sales performance.
Objective
The objective of the Supermarket Sales Dashboard is to provide decision-makers with actionable insights to enhance the supermarket’s performance and profitability. By visualizing key sales metrics and analyzing product categories, the dashboard aims to identify sales trends, understand customer preferences, and optimize marketing strategies to drive revenue growth.
Data Source
The data for this dashboard is sourced from the supermarket’s internal sales database. It includes information on daily gross income, product ratings, product categories, quantity sold, and other relevant sales data. The data is securely obtained and processed to ensure accuracy and confidentiality.
Data Cleaning and Preparation
To ensure data integrity and accurate insights, the data cleaning and preparation process focuses on removing duplicates and filtering rows. This streamlined approach eliminates inconsistencies and prepares the data for visualization and analysis, resulting in a reliable and informative dashboard.
Insights
- The combination chart on page 1 highlights the exceptional sales performance on February 7, 2019, with a total invoice ID of 20 and a gross income of $344.20. The pie chart illustrates that the Food and Beverage sector was the leading contributor to sales in the first quarter of 2019, generating a gross income of $2635.22 (17.6%). Conversely, the Health and Beauty category had the lowest gross income. Furthermore, the bar chart indicates that the Food and Beverage category received the highest average rating of 7.1 among all the categories, while the Home and Lifestyle category had the lowest average rating.
- The scatter plot on page 2 demonstrates a positive correlation between quantity and gross income, suggesting that customers who purchase more items contribute to higher gross revenue. The sum of quantity table reveals that the electronic accessories category has the highest number of products sold. However, when considering the Average Gross Amount per Quantity data, it becomes evident that the Electronic Accessories category generates the lowest average gross amount per quantity. In other words, selling more products in this category does not necessarily result in higher total sales.
Recommendations
- Enhancing the Food and Beverage Sector: Since the Food and Beverage sector contributes significantly to sales, it is crucial to focus on its optimization. Continuously evaluate and update the product offerings in this category to cater to customer preferences and trends. Additionally, consider promotional strategies and collaborations with local suppliers to further attract customers and drive sales.
- Improving the Health and Beauty Category: Given the lower gross income of the Health and Beauty category, it is essential to assess and identify areas for improvement. Conduct market research to understand customer needs and preferences within this category. Consider expanding the product range, introducing new and innovative products, and enhancing the overall customer experience to increase sales and profitability.
- Addressing Average Rating Disparities: While the Food and Beverage category receives the highest average rating, it is essential to maintain consistency across all categories. Analyze the factors contributing to lower ratings in certain categories, such as Home and Lifestyle, and take appropriate actions to improve customer satisfaction. This may involve improving product quality, addressing customer concerns promptly, and providing exceptional customer service.
- Maximizing Gross Revenue: Capitalize on the positive correlation between quantity and gross income by implementing strategies to encourage customers to purchase more items. Consider offering bundle deals, cross-selling and upselling techniques, and loyalty programs to incentivize customers to increase their order quantities. By focusing on increasing the average transaction value, you can significantly impact the overall gross revenue.
- Reevaluating the Electronic Accessories Category: Despite having the highest number of products sold, the Electronic Accessories category generates the lowest average gross amount per quantity. Evaluate the pricing strategy, product assortment, and competitive landscape within this category. Consider optimizing the product mix, exploring new pricing models, and identifying ways to increase the average gross amount per quantity to improve profitability.
- Continuous Monitoring and Adaptation: Regularly monitor and analyze sales performance, customer feedback, and market trends. Use the insights gained from the dashboard to make data-driven decisions and adapt strategies accordingly. Stay proactive in identifying opportunities for growth, addressing customer needs, and maintaining a competitive edge in the supermarket industry.
Visit my portfolio: https://dataexplorewithyani.my.canva.site/
BI portfolio: https://www.novypro.com/profile_projects/trihandayani
LinkedIn profile: http://www.linkedin.com/in/tri-handayani007