This project demonstrates an end-to-end

This project demonstrates an end-to-end data auditing pipeline built to solve typical data fragmentation issues faced by growing French e-commerce brand. By bridging disconnected customer registries, transactional records, and fulfilment center warehouse logs, this architecture automates inventory compliance checks under the French Anti Waste Law (Loi AGEC) and extracts core customer value metrics.

Based on simulated 4-table relational database model across 250 sales transactions, the unified data engine successfully extracted the following business insights.

• Total Revenue Audited: 24,057€

• Total Order Process: 250 packages

• VIP Customer Tier Count: 33 Premium Clients (Users with lifetime spend ≥ €300)

• Fulfillment Center Non-Compliance Alert: 8 items flagged as critical deadstock (stored over 120 days)

• Total Warehouse Capital Frozen: 3,369€ locked-up in slow moving apparel stock

To eliminate data siloes and replace manual entries with an automated dashboard reporting interface, the following rational systems were designed:

Cross-Sheet Relational Data Bridges: Deployed advanced multi-criteria XLOOKUP formulas to map transactional row items back to unique customer city and ID profiles across the registry databases.

Dynamic Financial Aggregations: Utilized targeted SUMIF and COUNTIF arrays to calculate Customer Lifetime Value (CLV) and track real time transaction velocities.

Automated Regulatory Alert Logic: Implemented nested conditional IF(and()) time-subtraction parameters to instantly measure warehouse shelf age (=TODAY() – Arrival_date) against France’s strict 120-days storage limits.