Skip to main content
SILVER WORKSPACE

Silver Layer Transformation Phase

Bronze ingestion has been completed successfully. Review transformation requirements before implementing business logic.

Transformation Requirements

The Sales Analytics team requires customer segment values to be standardized before downstream reporting.

Current Source Values
PREMIUM
Premium
premium
PREM
Expected Silver Values
Premium
Standard
Enterprise

Engineering Action Center

Review Dataset

Inspect Bronze layer records and identify inconsistencies.

Ready

Review Escalation

Understand stakeholder concerns and business impact.

Ready

Design Transformation Logic

Prepare Silver layer standardization approach.

Ready

Silver Layer Investigation Workspace

A reporting discrepancy has been raised by the Sales Analytics team. Investigate the incoming Bronze data before designing the Silver transformation.

Sales Analytics Escalation
Executive dashboards are showing multiple segment categories for the same customer group. Revenue reports contain PREMIUM, Premium, premium and PREM as separate values.
Bronze Layer Sample Data
customer_idcustomer_segment
1001PREMIUM
1002Premium
1003premium
1004PREM
Investigation Finding
Bronze ingestion is working correctly. The issue is caused by inconsistent business values arriving from upstream systems. Standardization must occur in the Silver transformation layer.
Proceed To Gold Layer →