DnA Program and Reporting _ Architecture

Sample of Program view from a Fictional Retail Company

1. Existing Architecture Platforms Azure Data Warehouse Reporting Staging Automic Presentation PowerBI / SSRS (Data Modeling | Transformation) Current Reporting Capability Business Logic and Data Data exists Would need to add element for Curbside Add Safety Oracle Datawarehouse Reporting Ingestion Curation Physical Data Layer (Reporting Datamart) Reporting Data Model (Logical Data Layer) Current Reporting Capability Sales (but captured from DW Automic ) Margin Budget/Finance metrics Essbase DW Safety Curbside Data elements Data Work Tlog

2. Data & Analytics – Executive Summary FY24 Strategic Objectives Modernize & transform our DnA platforms Migrate to cloud data & analytical technology & processes Define strategy for RAW data (how we get it, store it, etc..) Define ingestion & curation strategy, technology & processes Define architecture & data for delivering the new ingestion layer Current state / future state diagrams Decision framework Iterative delivery methodology & plan to migrate existing capabilities off the Data Warehouse Stop building new in DW unless absolutely business critical Define strategy & technology for presentation layer Including inventory, review & rationalization of existing reports DRAFT

3. Data & Analytics – Current State Architecture Enterprise Insights & Analytics Enterprise Data Warehouse Enterprise Insights & Analytics

4. Strategic Roadmap – Migrate from DW to ESL July - Sept Y4 – Q1 FY24 – Q2 FY24 – Q3 FY24 – Q4 FY25 – Q1 FY25 – Q2 FY25 – Q3 FY25 – Q4 Ingestion & Curation Initiatives enabled & supported by Data & Analytics Curbside Curbside Ingestion Curation Tlog Tlog RSC Indirect Procurement Indirect Procurement Talon RSC Talon Medalia Safety Labor Retail Exec and Ops Retail Exec and Ops Kalibrate Known Loss Medallia Oct – Dec Q1 Jan - Mar Apr- Jun Data Hub BY Engage3 Eagle Eye Upside Tecsa

5. Data Domains Safety Phase 1 Safety data (Retail Exec Rpt ) Phase 2 remaining data  (Safety Reports) Labor  Kronos(UKG)  new attributes (Actual & Schedule) Logile ( Getgo ) (Projection) ESSBASE (Budget) Sales TLOG  realtime   OOS Ingest new data sources for OOS GESCOM Medalia VOC VOG Other core data sources Whse Vendor  DSD Supplier Whse  Inventory Whse  Labor Price (GE, Comp) Cost (Base, Store,  Off Invoice, Acquisition, Net) Vendor Perks ScanPayGo Gift Cards Scanbacks Shipment Vendor Income Allowances MyPerks / Fuelperks Daily Demand Tags GEAC LAGO/Ad Recaps

6. Reports Migration Excel Merch Reports Over 150 reports have been identified of which we can consolidate down to 18 Power BI reports. Sales Reports Intraday sales reports Region/Division Sales reports Customer Business Metrics (CBM) Period End Gross Margin after Income Financial Dashboards Item Master Reports Movement Reports Item Movement Warehouse Movement Ship movement Holiday Reports – Thanksgiving, Christmas, SuperBowl , Easter, etc Inventory Reports Meat Aging Reports for different Buyers Ship and Sold Reports Pricing and Promo Reports Family Query Tx Count by Basket Value (Prior 8 Weeks) LAGO item by Promo Week RP Future Costs w Movement MyPerks Ad Wk Sales vs Adv Card (rolling 8 ad wk ) GE Price vs Competitor Promo with 5 Wk Movement OB vs NB Price Alert New Requests Retail Item Price   Retail Executive dashboard Vendor OOS reporting Vendor OOS dashboard and reports  Safety Safety Dashboard/Reporting Labor Labor reporting review and analysis  reporting.

7. Capacity Plan for Migration Efforts     October - November October - November - December Role /  Data Safety Labor TLOG E2E 2     x Solution Architecture 1     0.25 Ingestion 3 1 1 Data Architecture 2 1 1 Data Modelling 1.5 0.5 1 Curation 3 1 1 Data Testing   1 1 Power BI Reporting 4 1 1 Power BI Testing / QA   1 1