Every Angle Smart information from SAP systems 11 March 2014 - PowerPoint PPT Presentation

Every Angle Smart information from SAP systems 11 March 2014

Maxeda DIY ■ DIY retailer in the Netherlands and Belgium with several formats ■ Operating over 400 stores in Belgium, the Netherlands and Luxemburg ■ Assortment of 80,000 SKUs Every Angle - Roundtable 2

Martin van Dijk ■ 24 Years experience in retail-IT ■ Started as system developer, followed the traditional career path ■ IT manager at MS Mode, a private label fashion retailer ■ Working in the CIO office of Maxeda for 3 years ■ Since April 1 st 2013 IT manager at Maxeda DIY for Service Delivery Every Angle - Roundtable 3

My agenda ■ What is our IT strategy? ■ What can we and do we outsource? ■ Do we follow a single vendor or multi vendor strategy? ■ How can we manage cost down? ■ Do we control our own processes? ■ How are we going to deliver service to our colleagues and customers? Every Angle - Roundtable 4

SAP experience ■ From 1996 to 1998: working at first retail implementation of SAP in the Netherlands ■ From 2003 to 2004: implementation of SAP at MS Mode, followed by “run and maintain ” ■ Currently at Maxeda DIY: one SAP system for all formats Every Angle - Roundtable 5

SAP within Maxeda DIY ■ One SAP system for different organisations ■ Brico ■ PlanIT ■ Praxis ■ Standardization of: ■ Product hierarchy and master data ■ Business processes ■ As a result: ■ 81m entries in MARC ■ Database size: R3 = 2.8 Tb Every Angle - Roundtable 6

IT system landscape Every Angle - Roundtable 7

Application process mapping MONITORING 1.1. Marketing 1.2. Demand 1.3. Assortment 1.4. Retail Price & 1.5. Promotion Planning 1. Commercial Management 1. Demand Research Managing & Management & Revenue Management and Management Monitoring Forecasting Space Planning Retail Arcview Retail BI & Optimization IKB Retail 2.1. Vendor Relation 2.2. Foreign Trade 2.3. Purchase Order 2.4. Private Label BI and Buying 2. Sourcing Management Management Management & Retail/FiCo Own Production Retail EYR (Sunrise) (BR) Fiche Fournisseur (Br.) SAP SIM 3.1. Define and Arrange 3.2. Supply Chain 3.3. Replenishment and 3.4. Inventory 5. Supply Chain 3. SCM Supply Chain Planning Inventory Optimization Management Visibility and Tracking Monitoring 3. SCM Retail Retail Retail Retail BI EX Trim (DC) 4.1. Warehouse 4.2. Transport 4. Logistic 4. Logistic Management Management Monitoring execution Retail (for flowers) 5.1. Point-of-Sales 5.3. Store Operations 5.7. Call Center 5.9. Customer Data 5. Store 5.4. Store Staff 5.6. e-Commerce Monitoring Planning Management & Store (& Portal) AS@R www.brico.be (Wanabe) Profiling CoKoPas BI Sales and Services 5. Store, Customer Pin applic. www.praxis.nl BAS LMN BAS CAPP/BDA Retail www.plan-it.be for PDA AdresXpress www.brikodepot.com E-gift card (Wondercom) 5.2. In-Store Cash 5.5. Catalog 5.8. Customer Service 5.10. Customer Loyalty Pocket Management Management LMN browser AS@R CAPP/BDA + Informatie zuilen Corona(PI) Dupfact E-gift card 6.1. Development of 6.2. Finance & 6.4. Corporate Services 6.5. HRM 6.6. Master Data 6.7. Information 6.(3) Analytics and Management Business Strategy Controlling & Operational Support Management Technology Services Performance 6. Enterpise HR (incl. Time) & Support Retail/FiCo + SIM BI Management Retail/FiCo 2007 Prisma Business Objects Portal PIM Datax E-learning PRXnet Hyperion Virus Scanner = Application coverage = SAP module Every Angle - Roundtable 8 = Unknown / To be validated

Simplified architecture Business Objects SAP BW/HANA Every Angle POS WMS Every Angle - Roundtable 9

What’s the role of Every Angle ■ It’s quite simple to put data into SAP… ■ It can be difficult to get information out of SAP ■ Huge volumes => Slow queries ■ Difficult to find right tables ■ Difficult to combine tables in queries ■ Either you have reports programmed in R/3 ■ Or you define reports in BW (and optimize them for frequent and convenient use) Every Angle - Roundtable 10

Every Angle usage ■ Used by IT ■ Master data checks ■ Used by the business ■ analysis for Supply Chain ■ analysis for master data ■ analysis for Buying => Operational Business Analytics Every Angle - Roundtable 11

What makes Every Angle different? Every Angle - Roundtable 12

Advantages of Every Angle ■ Very simple to use for almost all users that are a bit familiar with Excel. ■ Very, very fast! ■ Friendly priced Every Angle - Roundtable 13

Drawbacks of Every Angle  You run all queries on a snapshot of your SAP-data  You can’t modify/upload data into SAP  It’s very easy to get data from SAP into Excel. What happens then… Every Angle - Roundtable 14

Every Angle organisation  Open and pragmatic approach  Highly experienced consultants with business understanding  Active (pro-active) system monitoring/management Every Angle - Roundtable 15

Lessons Learned  Start with a live demo on your Q system  Involve business users early in the process (so from the beginning)  Aim for improvements, not only in reporting but also in:  Organization  Procedures  Processes  SAP Every Angle - Roundtable 16

Questions Martin van Dijk IT manager Service Delivery Maxeda DIY e: martin.van.dijk@diymaxeda.com m: 06 20 200 316 Every Angle - Roundtable 17