About ShaDey Inc.

Enterprise Retail & Consumer Goods

ShaDey Inc. is a fictitious organisation created as a teaching case study for enterprise data platform design. It represents a multi-brand retail and consumer packaged goods (CPG) enterprise operating across physical stores, e-commerce, and wholesale channels. The organisation manages the full product lifecycle from market research and product ideation through procurement, distribution, in-store merchandising, and post-sale analytics.

Company Profile

Who We Are

ShaDey Inc. operates a portfolio of retail brands across flagship stores, standard locations, outlet channels, and a direct-to-consumer e-commerce platform. The business spans category management, merchandising, supply chain logistics, procurement, and customer engagement, serving both B2C consumers and B2B wholesale buyers.

The organisation runs SAP as its core enterprise system, with ECC 6.0 as the legacy backbone and an active migration path to S/4HANA. Alongside SAP, the technology landscape includes POS systems, warehouse management (WMS), transportation management (TMS), CRM platforms, and e-commerce engines, all feeding into a centralised data warehouse and analytics platform.

Industry
Retail & Consumer Packaged Goods
Multi-category retail with owned brands and third-party supplier relationships across food, apparel, home goods, and specialty segments.
Channels
Omni-Channel
Flagship stores, standard retail locations, outlet channels, e-commerce (web + mobile app), and B2B wholesale distribution.
ERP Platform
SAP ECC 6.0 + S/4HANA
Dual-landscape with active S/4HANA migration. Core modules: MM, SD, FI/CO, PP, WM, QM, and extended PLM.
Customer Base
B2C, B2B & Wholesale
Individual consumers, business buyers, and bulk distributors, each with distinct pricing, fulfilment, and loyalty models.
Data Architecture
Star Schema Data Warehouse
24-entity physical data model with dimensions, facts, data products, and ML/AI feature stores built on SCD Type 2 patterns.
Data Products
9 Products + 4 ML/AI
Customer 360, product catalogue, demand forecasting, promotion effectiveness, inventory position, supplier scorecard, and more.
Operations

What the Organisation Does

ShaDey Inc. manages the complete retail value chain. Products move through 16 distinct lifecycle stages, from identifying market need and ideating new products, through sourcing from suppliers, manufacturing, quality inspection, warehousing, distribution, and in-store merchandising, to point-of-sale, post-sale service, and continuous improvement based on sales analytics and customer feedback.

At every stage, data flows between SAP modules, external systems, and the enterprise data warehouse. The data platform captures these flows, models them as a governed star schema, and surfaces them as analytical data products consumed by merchandising teams, supply chain planners, finance, marketing, and executive leadership.

01
Product Lifecycle Management
End-to-end management of products across 16 stages, from market need identification through procurement, production, distribution, sale, and continuous improvement. Each stage maps to specific SAP transactions and data flows.
02
Supply Chain & Procurement
Supplier management, purchase order processing, goods receipt, quality inspection, warehousing, and transportation. Supplier performance is scored on delivery, quality, lead time, cost variance, and fill rate.
03
Sales & Customer Analytics
Omni-channel sales tracking across POS, e-commerce, and wholesale. Customer 360 profiles, RFM segmentation, churn prediction, lifetime value modelling, and promotion effectiveness analysis.
04
Data Governance & Quality
Centralized business glossary, data stewardship, RACI-based ownership, data quality scorecards, and data contracts. Three governance maturity levels define how metadata alignment impacts downstream trust.
Business Domains

Functional Areas

The organisation's data model spans eight functional domains, each with dedicated entity groups, source system mappings, and analytical data products.

Customer Management
Customer master data, SCD Type 2 versioning, loyalty tiers, customer segmentation, and 360 profiles. Sources: SAP KNA1/BUT000, CRM, e-commerce.
Merchandising
Product master, category hierarchy, brand management, pricing conditions, and promotion planning. Sources: SAP MARA/MAKT/MARC, KONH/KONP.
Sales & Revenue
Order management, billing, sales transactions, returns, and net sales analytics. Sources: SAP VBAK/VBRK/VBRP, POS systems, e-commerce orders.
Supply Chain
Inventory snapshots, stock positions, reorder signals, days-of-supply calculations, and demand forecasting. Sources: SAP MARD/MATDOC, WMS.
Procurement
Supplier management, vendor evaluation, purchase orders, goods receipt, and supplier scorecards. Sources: SAP LFA1, EKKO/EKPO, quality notifications.
Store Operations & Logistics
Store master data, store performance analytics, footfall, conversion, sales per square foot, shipment tracking, and carrier management. Sources: SAP T001W, LIKP, TMS.
Data Products
Derived analytical datasets: Customer 360, product catalogue, net sales daily, sales performance, inventory position, supplier scorecard, store analytics, promotion effectiveness, and order fulfilment.
Data Science & ML/AI
Customer segmentation (k-means RFM), demand forecasting (Prophet/LightGBM), churn prediction, LTV modelling, centralised feature store, and immutable training dataset snapshots.
Technology Landscape

Source Systems & Data Platform

Data flows into the enterprise warehouse from multiple operational systems. Every attribute in the physical data model carries explicit source-to-target lineage tracing back to specific tables and fields.

ERP
SAP ECC 6.0
95+ tables catalogued across MM, SD, FI/CO, PP, WM, QM. Legacy backbone for master data and transactional processing.
ERP (Next Gen)
SAP S/4HANA
7 major simplifications (MATDOC, ACDOCA, BUT000). Active migration with cloud extensions and embedded analytics.
Point of Sale
POS Systems
In-store transaction capture, basket data, store traffic/footfall, and real-time sales feeds.
E-Commerce
Web & Mobile
Customer registrations, online orders, product reviews, ratings, and digital engagement data.
Customer
CRM Platform
Contact management, loyalty programmes, campaign tracking, and customer communication history.
Warehouse
WMS
Warehouse operations, stock movements, pick/pack/ship, shrinkage reporting, and bin-level inventory.
Transport
TMS
Carrier management, shipment tracking, proof of delivery, freight cost, and route optimisation.
Analytics
Data Warehouse
Star schema with SCD Type 2 dimensions, transactional facts, derived data products, and ML feature stores.
ML/AI
ML Pipelines
Prophet/LightGBM demand forecasting, k-means customer segmentation, churn and LTV models, and a centralized feature store.
About This Platform

Data Architecture Knowledge Base

This platform is an interactive reference for ShaDey Inc.'s enterprise data architecture. It serves data architects, analytics engineers, data governance teams, and business analysts who need to understand how data flows from source systems through the warehouse into analytical products.

The platform includes a product lifecycle journey mapping 16 stages to SAP source tables, an interactive ER modeler with 24 entities across CDM/LDM/PDM layers, comprehensive SAP source table catalogues for both ECC and S/4HANA, source-to-target mapping documentation, data governance scenario comparisons, and business glossary references.

Everything is built as a static site with no build tools or runtime dependencies. HTML, CSS, and vanilla JavaScript, designed to work from the file:// protocol with no server required.

Explore the Platform

Start with the product lifecycle to understand the business domain, then explore the data model and governance frameworks.

Product Lifecycle Data Modeler Platform Home