Power BI Desktop
Sale Volume
264M
Total Units Of sales
5M
Total COGS
34.44M
Volume by Sku
WATER-C… SILK-CA… ESSENCE SKIN-MIST CHANNE…
PC-OIL CHANNE… SILK-CRE… DP-CLEA… VIOLET-C… SEPH-BO… SEPH-BE… DS-CREAM VIOLET-C…
SPF35 CHANNE… SILK-CA… LGT-PEA… SERUM-E… CL-POW… CL-POW…
31M
17M
12M
10M
10M
9M
9M
8M
7M
7M
6M
6M
5M
5M
4M
3M
3M
3M
3M
3M
3M
WATER… SILK-C… SEPH-B… SKIN-M… PC-OIL
DP-CLE… DS-MASK SILK-C… ESSENCE SKIN-M… VIOLET… SEPH-B…
BLOT DS-CRE… SILK-CR… CHANN…
SPF35 CHANN… CHANN… GOLDS… LGT-PE…
477K
347K
253K
216K
196K
194K
169K
146K
139K
134K
104K
103K
100K
83K
73K
72K
72K
67K
65K
62K
59K
Net Gain Margin
192.98M
Volume and Net Cogs
34.44M (11.55%)
Volume Net Cogs
264M (88.45%)
Volume and Net Gain
Margin
192.9… (42.2…)
Volume Net Gai…
264M (57.74%)
Volume Year by Year
2019
2018
2017
70M
125M
69M
0M
50M
Net Gain Margin by Year
100M
Net Gain Margin
2019
2018
Year
2017
Power BI Desktop
0M
5M
10M
15M
20M
Year
2017 2018 2019
5M (17.01%)
1M (2.71%)
4M (13.37%)
0M (0.17%)
4M (11.6%)
0M (0.1%)
1M (4.12%)
3M (9.26%)
5M (16.6%)
1M (4.18%)
0M (0.7%)
2M (6.64%)
1M (1.9%)
2M (5.69%)
Sales based on product subclass
Classification.Subclass
(Blank) 0
Blot Body Bridge Bundle Cleanser
Curated Beauty Curated Gift
Sales by Distribution Channel
CHANNEL 6
CHANNEL 7
CHANNEL 1
CHANNEL 3
CHANNEL 4
CHANNEL 2
CHANNEL 8
CHANNEL 5
15.01%
13.95%
13.92%
12.98%
11.74%
11.44%
10.79%
10.16%
sales by region
Region Name
Northeast
Southern
Western
International
Central
Canada
© 2022 Miiccrrossofftt Corrporrattiion
ABC Inc Top Sales Insights
.
Sales Volume
264 M
Total Units
5M
Average Unit
Retail
Rs. 52.8
Net Cost Of Sold Goods
(COGS)
34.44M
(14%)
Net Gain Margin(GM)
192.98M
(73%)
Top Selling Product
Water Cream
YOY Growth
(2017-2019)
81 44
% %
Best Performing Channel
Channel 6 (15%)
Best Product Subclass
Bridge
Best Sales Region
North-East
1
2
3
4
5
6
7
8
10
9
THANK YOU
FOR BETTER VISUALIZATION PLEASE REFER THIS LINK (OPEN IN Power Bi)
https://drive.google.com/file/d/1CiXJ2IkzdgONNmjTc2ARpuL2Fj8NmX-e/view?usp=sharing