2 of 14

01 / BUSINESS CONTEXT

Project Overview

DATASET TIMELINE

2015–2017

Supermarket retail transactions across India.

Business Problem

Unclear profit margins across regional retail branches.

Analytical Objective

Build SQL Star Schema for Power BI insights.

Validated Scope

9,994 verified orders across 97 Indian locations.

3 of 14

02 / SQL SERVER DATA CLEANING

Step 1: Check Table Name

SELECT name FROM sys.tables WHERE name = 'Supermarket__Sales';

Result: Supermarket__Sales

Catalog Verification

Confirmed exact table name alongside 6 warehouse tables.

4 of 14

03 / SQL SERVER DATA CLEANING

Step 2: Remove Duplicates

WITH CTE AS (SELECT *, ROW_NUMBER() OVER (PARTITION BY Order_ID ORDER BY Order_ID) as rn FROM dbo.Clean)

DELETE FROM CTE WHERE rn > 1;

0 rows affected

Zero duplicate Order_ID records found in dbo.Clean.

5 of 14

04 / SQL SERVER DATA CLEANING

Step 3: Remove NULLs

DELETE FROM dbo.Clean WHERE Order_ID IS NULL OR Customer_Name IS NULL OR Sales IS NULL;

0 rows affected

9,994 Verified Rows

Complete data integrity across all mandatory fields.

6 of 14

Table Name	Role	TotalRows
Clean	Staging	9,994
Dim_Customer	Dimension	50
Dim_Product	Dimension	23
Dim_Location	Dimension	97
Dim_Date	Dimension	1,236
Fact_Sales	Fact Table	9,994

05 / DATA WAREHOUSE ARCHITECTURE

Data Warehouse Model Counts

SELECT 'Clean' AS TableName, COUNT(*) FROM dbo.Clean UNION ALL SELECT 'Fact_Sales', COUNT(*) FROM dbo.Fact_Sales;

7 of 14

06 / DATA MODELING

Star Schema Architecture

Dim_Customer (1)

Dim_Location (1)

Dim_Date (1)

Fact_Sales (*)

Keys, Order_ID, Discount

Dim_Product (1)

8 of 14

07 / POWER BI EXECUTIVE OVERVIEW

Sales & Profit Analysis Dashboard

TOTAL SALES

15M ($14.96M)

TOTAL ORDERS

10K Orders

TOTAL PROFIT & MARGIN

3.75M (25.05%)

9 of 14

08 / GEOGRAPHIC PERFORMANCE

City & Region Analysis

TOP REGION

Central (5M+)

Highest regional revenue across India.

TOP CITIES BY PROFIT

Vellore & Bodi

174K profit each in city rankings.

10 of 14

09 / PRODUCT PERFORMANCE

Category Analysis Dashboard

#1 PRODUCT CATEGORY

Eggs, Meat & Fish

$2.3M Total Sales

#2 PRODUCT CATEGORY

Snacks

$2.2M Total Sales

11 of 14

10 / ANALYTICAL FINDINGS

Key Sales Insights

Central Region Dominance: Generates over 5M in total revenue.

Top Profit Hubs: Vellore and Bodi yield 174K profit each.

Category Leadership: Eggs, Meat & Fish leads at 2.3M.

Healthy Margin Stability: Overall profit margin holds at 25.05%.

12 of 14

11 / TECHNICAL STACK

Tools & Technologies Used

SQL Server

Star Schema modeling via CTE cleaning.

Power Query

Date.FromText using en-GB locale formatting.

DAX Measures

Dynamic KPI calculations for profit margins.

Power BI Desktop

Interactive Gold & Black executive visuals.

13 of 14

12 / STRATEGIC ACTION PLAN

Business Recommendations

Cold-Chain Expansion

Prioritize Eggs, Meat & Fish inventory.

Replicate Top Models

Apply Vellore & Bodi pricing regionally.

Discount Calibration

Cap promotional discounts during low months.

1 of 14