ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
FASHION RETAIL ANALYTICS
4
5
Business Analytics · Mid-Term Assignment
6
7
Submitted To: Mr. Aditya D. Vyas
8
9
10
11
TOTAL ORDERSPRODUCTSREGIONSSTATUS
12
13
50943
14
15
16
📂 WORKBOOK NAVIGATION
17
18
📦Product MasterMaster list of 9 products with their Product ID, Category, Sub-Category & Unit Price
19
20
🛒Raw Orders Data50 orders with Order ID, Order Date, Customer Name, Region, Product ID, Quantity, Status & Warehouse Location
21
22
🔍Processed Orders DataPart A: XLOOKUP function to retrieve Category, Sub-Category, Unit Price & calculate Total Sales
23
Part C: Conditional Formatting - Top 5 Sales Values, Icon Sets, Data Bars & Color Scale
24
📊Pivot AnalysisPart B: Pivot Tables - Sales by Category, Region, Status, & Monthly Sales Trend along with other tables
25
26
📈Charts DashboardPart D: Column, Line (Trendline), Scatter (Trendline), Pie & Treemap
27
28
29
📊 QUICK SUMMARY
30
31
Most OrdersSouth Region16 Orders
32
Top Category by SalesFootwearHigh-Value Category
33
Price Range₹1,254 – ₹4,644Unit Price Range
34
Warehouse LocationsDelhi, Mumbai, Bangalore3 Warehouses
35
Date RangeJan – Jun 20266 Months of Data
36
37
MFM 2nd Semester · Business Analytics
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100