Supermarket Sales Dashboard

Goals: The primary goal of this project was to create a comprehensive analysis of sales performance for the year 2024. This involved identifying key metrics, trends, and insights to support strategic decision-making and improve overall sales efficiency.

Business Needs: The project aimed to address several key business needs:

1. Regional Performance: Monitor revenue by region to identify high-performing and underperforming areas.
2. Product Analysis: Evaluate the number of units sold and revenue generated by different product categories.
3. Payment Methods: Understand the distribution of sales across various payment methods.
4. Seasonal Trends: Analyze transaction trends over different months to identify seasonal patterns.
5. Revenue Distribution: Assess the total revenue distribution among regions and product categories.

Discovery and Presentation of Insights:

1. Data Collection: Gathered sales data from various sources, including sales records and financial reports.
2. Data Cleaning: Ensured the data was clean and free from errors or inconsistencies.
3. Exploratory Data Analysis (EDA): Conducted EDA to understand the underlying structure of the data and identify initial patterns.
4. Visualization: Created a dashboard using Power BI to present the data in a visually appealing and easily understandable manner. The dashboard included:
   • Bar graphs showing revenue by region and units sold by product category.
   • Pie charts illustrating payment method distribution and total revenue distribution among regions.
   • Line graphs tracking transactions by month.
5. Reporting: Compiled the insights into comprehensive reports that included visualizations, interpretations, and recommendations.

By following these steps, the project successfully delivered valuable insights that met the business needs and supported the goals of improving sales performance and strategic decision-making.