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

Every Angle

Smart information from SAP systems

11 March 2014

Every Angle - Roundtable

2

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

■ 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 1st 2013 IT manager at Maxeda DIY for Service Delivery

3

Martin van Dijk

Every Angle - Roundtable

■ 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?

4

My agenda

Every Angle - Roundtable

■ 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

5

SAP experience

Every Angle - Roundtable

■ 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

6

SAP within Maxeda DIY

Every Angle - Roundtable

7

IT system landscape

Every Angle - Roundtable

8

• 1. Commercial

Monitoring

• 3. SCM

Monitoring 6.(3) Analytics and Performance Management

• 5. Store

Monitoring 2.1. Vendor Relation Management 3.2. Supply Chain Planning 6.1. Development of Business Strategy 1.4. Retail Price & Revenue Management 1.2. Demand Managing & Forecasting 1.3. Assortment Management & Space Planning & Optimization 1.5. Promotion Planning and Management 2.3. Purchase Order Management 2.4. Private Label Management & Own Production 2.2. Foreign Trade

• 5. Supply Chain

Visibility and Tracking 3.4. Inventory Management 3.1. Define and Arrange Supply Chain 6.5. HRM 6.4. Corporate Services & Operational Support 6.2. Finance & Controlling 1.1. Marketing Research 3.3. Replenishment and Inventory Optimization

• 1. Demand

Management

• 2. Sourcing

and Buying

• 3. SCM
• 5. Store, Customer

Sales and Services

• 6. Enterpise

Management & Support MONITORING

• 4. Logistic

Monitoring

• 4. Logistic

execution

4.2. Transport Management 4.1. Warehouse Management 5.1. Point-of-Sales 5.2. In-Store Cash Management 5.3. Store Operations 5.4. Store Staff Planning 5.5. Catalog Management 5.7. Call Center 5.8. Customer Service 5.6. e-Commerce 5.9. Customer Data Management & Profiling 5.10. Customer Loyalty 6.6. Master Data Management 6.7. Information Technology Services

AS@R

Application process mapping

= SAP module = Application coverage

www.brico.be (Wanabe) Hyperion CoKoPas LMN EX Trim (DC) IKB Fiche Fournisseur (Br.) EYR (Sunrise) (BR) www.praxis.nl www.plan-it.be BI BI BI BI BI HR (incl. Time) Store (& Portal) Retail Retail Retail Retail Retail Retail Retail Retail Retail/FiCo Retail/FiCo + SIM Retail/FiCo www.brikodepot.com (Wondercom)

Portal PRXnet

LMN

= Unknown / To be validated

BAS BAS Pin applic. AS@R for PDA

Virus Scanner

Prisma Business Objects Retail E-learning

+ Informatie zuilen

AdresXpress E-gift card E-gift card

Pocket browser

2007 Datax Dupfact

Corona(PI) CAPP/BDA CAPP/BDA Arcview Retail (for flowers) PIM SAP SIM

Every Angle - Roundtable

9

Simplified architecture

SAP BW/HANA

Every Angle

POS WMS Business Objects

Every Angle - Roundtable

■ 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)

10

What’s the role of Every Angle

Every Angle - Roundtable

■ Used by IT ■ Master data checks ■ Used by the business ■ analysis for Supply Chain ■ analysis for master data ■ analysis for Buying => Operational Business Analytics

11

Every Angle usage

Every Angle - Roundtable

12

What makes Every Angle different?

Every Angle - Roundtable

■ Very simple to use for almost all users that are a bit familiar with Excel. ■ Very, very fast! ■ Friendly priced

13

Advantages of Every Angle

Every Angle - Roundtable

 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…

14

Drawbacks of Every Angle

Every Angle - Roundtable

15

Every Angle organisation

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

Every Angle - Roundtable

16

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

Martin van Dijk IT manager Service Delivery Maxeda DIY e: martin.van.dijk@diymaxeda.com m: 06 20 200 316

17

Questions