StepRight - Gold Layer Reporting and Analysis
Section 3 left four clean, current-state-queryable silver tables and three bronze tables that never needed business rules of their own. This section is where that shared foundation finally earns its keep: five denormalized gold tables, each built for one specific consumer – finance, marketing, merchandising, growth, and operations – instead of one generic “reporting layer” that satisfies nobody well. Every gold table here is a Lakeflow Declarative Pipelines materialized view, the same primitive Part 1, Section 9 introduced, now doing real work: joining SCD Type 2 history at its current version, reconciling a bronze table that skipped silver entirely, and turning row-level facts into the daily rollups a dashboard actually queries.
flowchart LR
subgraph Silver
SO[silver_orders]
SOI[silver_order_items]
SC[silver_customers]
SP[silver_products]
end
subgraph Bronze["Bronze -- no silver layer needed"]
BI[bronze_inventory_valid]
BCS[bronze_clickstream_valid]
BF[bronze_fulfillment_valid]
end
SO --> G1[gold_daily_revenue]
SOI --> G1
SC --> G1
SP --> G1
SC --> G2[gold_customer_360]
SO --> G2
SOI --> G2
SOI --> G3[gold_product_performance]
SP --> G3
BI --> G3
BCS --> G4[gold_clickstream_funnel]
SP --> G4
SO --> G5[gold_fulfillment_health]
BF --> G5
G1 --> Finance[Finance]
G2 --> Marketing[Marketing]
G3 --> Merch[Merchandising]
G4 --> Growth[Growth Team]
G5 --> Ops[Operations]
Lectures
| # | Lecture | Est. Read |
|---|---|---|
| 1 | Revenue Computation by Day, Category, Region | 10 min read |
| 2 | Customer 360 for Marketing | 4 min read |
| 3 | Product Performance and Sales Velocity for Merchandising | 5 min read |
| 4 | Clickstream Funnel Analysis for Growth Teams | 4 min read |
| 5 | Product Delivery and Fulfilment Health for Operations | 5 min read |
| ← Previous: Developing Silver SDP Pipeline for File Sources | Next: Revenue Computation by Day, Category, Region → | |:—|—:|