◆ BLACK FRIDAY ◆

RETAIL ANALYTICS SYSTEM v1.0
INITIALIZING...

◆ BLACK FRIDAY — RETAIL ANALYTICS

ANALYTICS DASHBOARD  |  550,068 TRANSACTIONS  |  5,891 CUSTOMERS  |  3,631 PRODUCTS
▶ CAPSTONE PROJECT
◈TOTAL REVENUE 0ALL TRANSACTIONS COMBINED
◉UNIQUE CUSTOMERS 0 REGISTERED SHOPPERS
◫TOTAL TRANSACTIONS 0PURCHASE RECORDS
◧UNIQUE PRODUCTS 0 DISTINCT SKUs
◐AVG PURCHASE / TXN ₹0 PER TRANSACTION
◑AVG SPEND / USER ₹0CUSTOMER LIFETIME VALUE
◈ SALES BY AGE GROUP
◉ GENDER REVENUE SPLIT
◫ MARITAL STATUS
◧ TRANSACTIONS BY CITY
◈ TOP OCCUPATIONS BY REVENUE
◧ CITY TENURE — TRANSACTION COUNT
CITY LOYALTY INDEX
1 YEAR193,821 TXN
2 YEARS101,838 TXN
3 YEARS95,285 TXN
4+ YEARS84,726 TXN
NEW (0 YRS)74,398 TXN
◑ CUSTOMER SEGMENT PROFILES
◐ AGE × GENDER HEATMAP — AVG PURCHASE (₹)
◈ TOP CATEGORIES — REVENUE
◉ TOP CATEGORIES — TRANSACTION VOLUME
◫ FULL CATEGORY PERFORMANCE TABLE
◧ MULTI-CATEGORY PURCHASE PATTERNS
◫ CITY REVENUE SKYLINE
◈ REVENUE BY CITY
◐ TRANSACTIONS BY CITY
◧ AVG PURCHASE — CITY × AGE GROUP (₹)
◈ TOP 5 STRATEGIC INSIGHTS
◉ STRATEGIC RECOMMENDATIONS
◑ DATA QUALITY REPORT
USER_ID COMPLETENESS100%
PRODUCT_ID COMPLETENESS100%
PURCHASE COMPLETENESS100%
CATEGORY 2 PRESENT68.4%
CATEGORY 3 PRESENT30.3%
◆ Missing Cat 2/3 treated as "Not Applicable" — no imputation required.
◆ 31,248 rows (5.7%) had inconsistent stay_years format — standardized.
◆ No duplicate User+Product pairs found. Dataset integrity: PASS.
◐ KPI SCORECARD