Global Cookie Company

Microsoft Fabric Architecture — Interactive Data Flow

Data Pipeline
Data Sources
When POS Goes Down
Registers queue transactions offline and sync when connection restores. No lost sales. Historical data stays safe in OneLake.
POS & Sales
When Inventory Sync Fails
Mirroring auto-reconnects when bakery systems recover. Change feed tracks position — no missed updates. OneLake replica stays queryable.
Bakery Inventory
When GPS Tracking Drops
Trucks buffer GPS pings locally and bulk upload when back online. Route history preserved. Dashboards show last known position.
Delivery Tracking
When Social APIs Fail
Retry with exponential backoff. Sentiment analysis continues on cached reviews. Alerts flag when feeds go stale.
Social Reviews
When Supplier Files Fail
Schema validation catches format issues early. Failed uploads show clear errors. Previous supplier data stays intact.
Supplier Orders
OneLake - Unified Data Layer
Delta Format
Delta Format
Default table format with versioning, transactions, and time-travel built in.
Parquet
Parquet
Columnar file format optimized for fast analytics queries.
Shortcuts
Shortcuts
Pointers to external data (S3, Blob) — no copying required.
Fabric Experiences
When ETL Jobs Fail
Checkpointing saves progress — jobs resume where they left off. Recipe and production data stays consistent. Spark UI shows exactly what failed.
Production ETL
Recipe & Batch Data
When Forecasts Fail
Model falls back to last successful prediction. Bakeries get conservative restock recommendations. MLflow logs what went wrong for debugging.
Demand Forecasting
Predict Next Week's Sales
When Queries Fail
Query insights show what went wrong. Delta's ACID transactions prevent partial writes. Sales and inventory data stays consistent.
Sales & Inventory
Unified Data Warehouse
When Streams Drop
Checkpoints track position — no missed oven temps or truck locations. Dead-letter queues capture failed events. Dashboards show last known state.
Live Monitoring
Bakeries & Trucks
When Dashboards Fail
Direct Lake falls back to cached data with warnings. Execs still see yesterday's numbers. Refresh history logs what broke.
Executive Dashboard
Company-Wide View
When Alerts Fail
Missed alerts queue for retry. Managers get batched notification when service recovers. Trigger history logs every attempt.
Stock Alerts
Low Inventory Warnings
🏠 Portfolio Home
Data Flow Status
Click "Start Data Flow" to see how Global Cookie Company's data moves from stores, bakeries, and trucks through OneLake to dashboards and alerts.
POS & Sales
Bakery Inventory
Delivery Tracking
Social Reviews
Supplier Orders