BI Solution for Zara Corp.

1. Presented by; Dave Lawrence, AnastasiyaBelchankova, Elena Dorneanu, Rodolfo Popocatl Paul On Behalf of; DLC Services Corp. BI Solution for Zara Corp.

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 • AnastasiyaBelchankova – HR and Logistics Specialist • Rodolfo Popocatl Paul – Team Lead and Programmer

3. What we do! • Analysis • Analyise client needs • Modelling • Presentation/Agreement • Design • Coding • Report and dashboard design • Data migration • Testing • Implementation • Installation • Training • After sales support

4. Zara Requirements • In General • By Region, by store, and by employee • Flexible time constraints, by week, by month, by quarter, by year • 25 approximate users – department heads and executive management • Sales Information • Average units, total units, average revenue, total revenue • Revenue vs forecast • Labour Information • Average Hourly Labour – efficiency • Average Sales Units by Employee – efficiency (in Sales Dashboard) • Campaign Information • Are campaigns successful – efficiency • How exactly do campaigns affect sales • Inventory Information • Inventory turns

5. The Model and Use Case Testing

6. Model and Relationships 1 1 M M M M M 1 M M 1 1 1 1 1 M M M 1 M 1 M 1 1 M 1 1 M 1 M 1 M M

7. Use Case Test – Sales by Month by Region Delimiter Indicator Calculated Indicator

8. The Indicators and Dashboards

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: • National info broken down by region • Regional info broken down by stores • Store info broken down by employee

25. Price Quote 375 Total Hours @ 100 Euros Per Hour • Analysis – 100 Hrs • Analysis – 20 Hrs • Modelling – 20 Hrs • Presentation/Agreement – 60 Hrs • Design – 195 Hrs • Coding – 60 Hrs • Report and Dashboard Design – 60 Hrs • Data migration – 15 Hrs • Testing – 60 Hrs • Implementation – 80 Hrs • Installation – 10 Hrs • Training – 20 Hrs, 5 – 4 Hr Sessions • Support – 50 Hrs, On site Total 37,500 Euros

26. Thank You For Your Time!Questions?

27. Use Case Testing

28. Use Case Test – Units Sold by Month by Store Delimiter Indicator Calculated Indicator

29. Use Case Test – Average Units Sold by Employee Delimiter Indicator Calculated Indicator

30. Use Case Test – National Sales vs Forecast Delimiter Indicator Calculated Indicator

31. Use Case Test – Sales Matrix by Order Type Delimiter Indicator Calculated Indicator

32. Use Case Test – Average Hourly Labour by Region Delimiter Indicator Calculated Indicator

33. Use Case Test – Average Inventory Turns by Region Delimiter Indicator Calculated Indicator

34. Use Case Test – Average Inventory Turns by Region by Category Delimiter Indicator Calculated Indicator

35. Use Case Test – Promotion Sales vs Prior Year (and Prior Month) Delimiter Indicator Calculated Indicator

36. Use Case Test – Promotion Sales vs Prior Year by Promotional Items and Cost Delimiter Indicator Calculated Indicator

37. Useful Formulas *********************************** Growth Formula ( -1) *100 *************************************