Retail Sales Dashboard

The Retail Sales Dashboard is an interactive Power BI project designed to analyze and visualize key performance metrics for a supermarket shop. It provides an at-a-glance view of sales performance, profitability, and product-level insights, enabling managers to make informed, data-driven decisions.

Objective

The aim of this dashboard was to build a real-time, insightful retail performance report that tracks sales, profit, and customer behavior across multiple dimensions such as time, product, and payment mode.

Data & Methodology

Data Source: Sample retail sales dataset containing transaction details, product categories, and sales channels.
Data Preparation: Cleaned and transformed the dataset in Power BI using Power Query to ensure consistency and accuracy.
Modeling: Created DAX measures to calculate total sales, total profit, and profit percentage, along with time intelligence functions for monthly and daily trends.
Visualization Highlights:
- KPI cards to display Total Sales (187K), Total Profit (30K), and Profit % (19%).
- Monthly and Daily charts showing revenue and profit trends.
- Treemaps for top-performing products and categories.
- Donut charts for sales type and payment mode distribution.
- Filters for year, month, sale type, and payment mode for flexible analysis.

Key Insights

Sales peaked during mid-year months, indicating seasonal buying patterns.
Direct sales accounted for the majority of transactions, contributing to steady profitability.
Category05 and Category03 were top-performing segments, driving overall revenue growth.

Tools & Technologies

Power BI Desktop for report design and interactivity.
Power Query for data transformation.
DAX for calculated measures and KPIs.

Outcome

This dashboard demonstrates how data visualization and business intelligence can simplify complex retail data into actionable insights. It helps decision-makers monitor sales trends, optimize inventory, and identify opportunities for growth.