Level 7 - ArchitectQuery-Based Questionsm4 dimensional performance models
Top Products by Revenue in Star Model
Return top 20 product_name by paid revenue in Q1 2025.
Schema Context
fact_sales(product_sk, date_sk, amount, order_status), dim_product(product_sk, product_name), dim_date(date_sk, full_date)