: Stores metrics like price, quantity, and foreign keys.
-- Finding total sales by product category SELECT p.category, SUM(s.sale_amount) AS total_revenue FROM fact_sales s JOIN dim_product p ON s.product_key = p.product_key GROUP BY p.category; Use code with caution. Copied to clipboard Building a Data Warehouse with Examples in SQL ...
moves data from raw sources (like CSVs or ERP systems) into your warehouse. Extract : Pulling raw data into the Bronze Layer . : Stores metrics like price, quantity, and foreign keys
A data warehouse typically uses a , consisting of a central Fact Table (quantitative data like sales) surrounded by Dimension Tables (descriptive data like products or dates). : Stores metrics like price
: Cleaning data in the Silver Layer , such as standardizing "Yes/No" strings to booleans. Load : Inserting into the final Gold Layer tables.