Supermarket Sale Analysis Project

Data Flow Overview:

• Source: SuperMarket Analysis .xlsx file
• Extracted dimension tables — DimBranch, DimCustomerType, DimPayment, and DimProductLine — directly from the source file for structured reporting.
• BI Layer: Built a star-schema model in Power BI, enabling dynamic dashboards and interactive analysis.

Dashboard Highlights:

• Sales KPIs: Overview of total sales quantity and volume.
• Time Trends: Monthly sales trend tracking to monitor performance over time.
• Product/Category Analysis: Sales volume comparison across different product lines.
• Customer & Payment Insights: Segmentation by customer type, gender, and payment method.
• Regional Performance: Sales breakdown by branch city and state/division with geographic visualization.

Customer Behavior Analysis:

• Count of invoices by gender
• Sales volume by product line and gender
• Overall sales by product line
• Heatmap analysis (gender × time bins × city)
• Trendline analysis of sales by time bins across payment methods and gender

Value Delivered:

• Centralized and structured view of supermarket sales data.
• Enhanced visibility into product, customer, and regional performance.
• Clear, interactive insights to support business decision-making and identify sales opportunities.
• Demonstrates skills in data modeling, dashboard design, and storytelling with data.