Explain how processing through bronze, silver, and gold layers works and how you build business dashboards from them.

Bronze is the raw ingestion layer where data is stored in its original format (e.g., Parquet, JSON) with minimal transformation. Silver is the cleaned and enriched layer; here we perform deduplication, type casting, and basic joins to create a more usable dataset. Gold is the curated layer that aggregates and models data for business consumption, often stored in a star or snowflake schema. To build dashboards, we first query the gold layer because it contains pre‑aggregated metrics. Business users can then slice and dice the data using BI tools like Power BI or Tableau. The pipeline ensures that any change in the raw data propagates through silver and gold, keeping dashboards up‑to‑date.