Retail Business Intelligence Dashboard

Project Overview

This project focuses on analyzing retail sales data to understand why revenue has remained flat for two quarters and which stores and product categories are having declining revenue. Also to uncover revenue trends, product performance, and business opportunities. The goal was to demonstrate how data analytics can help retail businesses make informed decisions around sales optimization, inventory planning, and customer understanding.

Business Questions

The analysis aimed to answer:

# Which stores had declining revenue ?

# Which product category had declining revenue ?

# Understand why revenue is flat

Data Preparation

The dataset was cleaned and transformed by:

# Removing inconsistencies and duplicate records

# Handling missing values

# Creating calculated fields for analysis

# Preparing data models for visualization

Tools used:

# Excel

# Power BI

Analysis Performed

# Sales Performance Analysis

# Revenue trends over time

# Store-level performance comparison

# Category contribution analysis

Product Analysis

# Top-performing products

# Low-performing categories

# Sales distribution

Business Intelligence Dashboard

Developed an interactive Power BI dashboard displaying:

# Total Revenue

# Total Orders

# Sales Trends for the 4 declining stores

# Store Performance for the 4 declining stores

# Category Performance for the 4 declining stores

# Product Insights

Key Insights

# 4 of 12 stores (Store 3, 5, 7, 9) sit at just 56–66% of average revenue

# Electronics revenue is declining every quarter, and getting worse in 4 stores

# Identified the lowest-performing stores and categories contributing to overall declining revenue.

# Highlighted products with low sales and areas requiring attention.

# Provided visibility into sales patterns to support strategic decisions.

Business Recommendations

Based on the analysis:

If BrightMart shares store-level inventory logs, here's the exact calculation I'd run a stockout analysis to understand the impact of electronic stock out financial impact.

Identify the underlying drivers of persistent stock-outs in electronics products by analyzing inventory, supplier, and logistics data. Evaluate supplier performance and delivery lead times to determine whether stock shortages are caused by delayed deliveries, procurement inefficiencies, or other operational issues, and recommend actions to maintain product availability.

Collaboration & Outcome of the Project

I executed this project independently, managing the full workflow from data collection to data cleaning and trasformation, inclusing data analysis and data visualization using Excel and Power BI. 

Even though it was a solo project, i approached it with a collaborative mindset by applying industry-standard practices and documentation to ensure the workflow can be easily understood or extended by other analysts