Use Excel or any other software to do the following. Share your results in any form of output you see appropriate.
computer science
Description
Question 1: Use
Excel or any other software to do the following. Share your results in any form of output you
see appropriate.
1.
Data: moda satis.xlsx
Definitions: SKU = “Model No”, Sales = “ADET”
Focus on Kategori =Dress, Alt Kategori
=Moda
a.
Create a table that reports the following for each
subgroup of `Stok Grup Aciklamasi’:
i.
Number of distinct SKUs
ii.
Number of distinct SKUs that has the largest
sales and generate in total 25% of sales. Repeat for 50% sales. Repeat for 75%
of sales
iii.
% share of different kinds of “SIPARIS” (e.g.,
ILK ve ILK SIPARIS, RPT RPT2 3 4 vs., ARGE, SEZONLUK...)
b.
Store
distribution: For each subgroup
of `Stok Grup Aciklamasi’:
Data is in columns EB:GQ (If store carries that product, 1;
otherwise, 0)
i.
# stores
that has the product for each SKU (SKUs in decreasing order of sales)
ii.
# SKUs and total inventory at each store (Stores
in decreasing order of # total inventory)
Question 2
Write SQL code in a word document that will answer the
questions below using the following two tables.
Inventory position table
Store table
-
Find the latest StoreStock for each StoreCode,
ProductCode pair
-
Sum sales by BuildingType
-
List stores description which have sales revenue
lower than 50TL in 2014 May
-
In February 2014, what is the difference between
the highest-selling store and the least-selling store?
