1. 2 3 4 5 model and relationships 6 m 1 m m m m m m m m m m m m m m m m 1 1 1 1 1 1 1 1 1 1 1 1 1 1...
TRANSCRIPT
![Page 1: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/1.jpg)
1
BI Solution for Zara Corp.Presented by; Dave Lawrence, Anastasiya Belchankova,
Elena Dorneanu, Rodolfo Popocatl PaulOn Behalf of; DLC Services Corp.
![Page 2: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/2.jpg)
2
Who are DLC Services?
• Custom design and expert knowledge and agile management.• 25 + years experience in the retail sector.• Information delivered quickly and inexpensively• Data Integrity• Scalable Solutions• Market differentiation for our clients
• David Lawrence – Design and Modelling Specialist• Elena Dorneanu – Sales and Marketing Specialist• Anastasiya Belchankova – HR and Logistics Specialist• Rodolfo Popocatl Paul – Team Lead and Programmer
![Page 3: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/3.jpg)
3
What we do!• Analysis
1. Analyise client needs2. Modelling 3. Presentation/Agreement
• Design1. Coding2. Report and dashboard design3. Data migration4. Testing
• Implementation1. Installation 2. Training 3. After sales support
![Page 4: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/4.jpg)
4
Zara Requirements• In General
1. By Region, by store, and by employee2. Flexible time constraints, by week, by month, by quarter, by year3. 25 approximate users – department heads and executive management
• Sales Information1. Average units, total units, average revenue, total revenue2. Revenue vs forecast
• Labour Information1. Average Hourly Labour – efficiency2. Average Sales Units by Employee – efficiency (in Sales Dashboard)
• Campaign Information1. Are campaigns successful – efficiency2. How exactly do campaigns affect sales
• Inventory Information1. Inventory turns
![Page 5: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/5.jpg)
5
The Model and Use Case Testing
![Page 6: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/6.jpg)
6
Model and Relationships
M
1M
M
M
M
MM
M
M
M
M
M
MM
M
M
M1
1
11
1
1
1
1
11
1
11
11
![Page 7: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/7.jpg)
7
Use Case Test – Sales by Month by RegionDelimiterIndicatorCalculated Indicator
![Page 8: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/8.jpg)
8
The Indicators and Dashboards
![Page 9: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/9.jpg)
9
![Page 10: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/10.jpg)
10
![Page 11: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/11.jpg)
11
Filters and Drilling Down• The next set of slides are from the proposed sales
section. • There are currently three types of report on this page:
Sales Reports, Sales vs Forecast reports and Sales Matrix reports.• Users can apply filters to get more detailed info. For
example, the next three slides show:1. National info broken down by region2. Regional info broken down by stores3. Store info broken down by employee
![Page 12: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/12.jpg)
12
![Page 13: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/13.jpg)
13
![Page 14: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/14.jpg)
14
![Page 15: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/15.jpg)
15
![Page 16: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/16.jpg)
16
![Page 17: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/17.jpg)
17
![Page 18: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/18.jpg)
18
![Page 19: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/19.jpg)
19
![Page 20: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/20.jpg)
20
![Page 21: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/21.jpg)
21
![Page 22: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/22.jpg)
22
![Page 23: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/23.jpg)
23
![Page 24: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/24.jpg)
24
![Page 25: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/25.jpg)
25
Price Quote• Analysis – 100 Hrs
1. Analysis – 20 Hrs2. Modelling – 20 Hrs3. Presentation/Agreement – 60 Hrs
• Design – 195 Hrs1. Coding – 60 Hrs2. Report and Dashboard Design – 60 Hrs3. Data migration – 15 Hrs4. Testing – 60 Hrs
• Implementation – 80 Hrs1. Installation – 10 Hrs2. Training – 20 Hrs, 5 – 4 Hr Sessions3. Support – 50 Hrs, On site
Total 37,50
0 Euros
375 Total Hours
@
100 Euros Per Hour
![Page 26: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/26.jpg)
26
Thank You For Your Time!Questions?
![Page 27: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/27.jpg)
27
Use Case Testing
![Page 28: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/28.jpg)
28
Use Case Test – Units Sold by Month by StoreDelimite
rIndicatorCalculated Indicator
![Page 29: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/29.jpg)
29
Use Case Test – Average Units Sold by EmployeeDelimite
rIndicatorCalculated Indicator
![Page 30: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/30.jpg)
30
Use Case Test – National Sales vs ForecastDelimite
rIndicatorCalculated Indicator
![Page 31: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/31.jpg)
31
Use Case Test – Sales Matrix by Order TypeDelimite
rIndicatorCalculated Indicator
![Page 32: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/32.jpg)
32
Use Case Test – Average Hourly Labour by RegionDelimite
rIndicatorCalculated Indicator
![Page 33: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/33.jpg)
33
Use Case Test – Average Inventory Turns by RegionDelimite
rIndicatorCalculated Indicator
![Page 34: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/34.jpg)
34
Use Case Test – Average Inventory Turns by Region by CategoryDelimite
rIndicatorCalculated Indicator
![Page 35: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/35.jpg)
35
Use Case Test – Promotion Sales vs Prior Year (and Prior Month)Delimite
rIndicatorCalculated Indicator
![Page 36: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/36.jpg)
36
Use Case Test – Promotion Sales vs Prior Year by Promotional Items and Cost
DelimiterIndicatorCalculated Indicator
![Page 37: 1. 2 3 4 5 Model and Relationships 6 M 1 M M M M M M M M M M M M M M M M 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1](https://reader036.vdocuments.us/reader036/viewer/2022081417/551bbac3550346c3588b467c/html5/thumbnails/37.jpg)
37
**********************************
Inventory turnover:
Where average inventory:
***********************************
Growth Formula
( -1) *100
*************************************
Useful Formulas