Retail Profitability Intelligence Dashboard

Project Overview

A retail analytics project combining Python, SQL, and Power BI to analyze sales, profit, risk levels, and loss-making categories.

Tools Used

• Python (Pandas, Matplotlib, Seaborn)
• SQL
• Power BI
• GitHub

Dataset

Superstore retail dataset containing sales, profit, customer, product, and regional information.

Key KPIs

• Total Sales
• Total Profit
• Total Orders
• Average Profit Margin

Dashboard Features

• Sales by Category
• Profit by Region
• Profit by Sub-Category
• Risk Level Distribution
• Interactive Filters:
  • Region
  • Segment
  • Category

SQL Analysis

SQL queries used for:

• Top profit-making sub-categories
• Loss-making sub-categories
• Discount vs Profit analysis
• Regional sales and profit analysis

Project Structure