The business intelligence team has a dashboard tracking retail store metrics with the following schema:

store_id INT, 
total_sales_gtd FLOAT, 
avg_daily_sales_gtd FLOAT, 
total_sales_ytd FLOAT, 
avg_daily_sales_ytd FLOAT, 
previous_day_sales FLOAT, 
total_sales_7d FLOAT,
avg_daily_sales_7d FLOAT, 
updated TIMESTAMP

The Lakehouse contains a validated products_per_order table with near real-time incremental updates, having these fields:

store_id INT, 
order_id INT, 
product_id INT, 
quantity INT, 
price FLOAT,
order_timestamp TIMESTAMP

Since long-term sales trend reporting is less volatile, analysts only need daily refreshes for this dashboard. Given that the dashboard will be queried interactively by multiple users throughout the day, it must return results quickly while minimizing compute costs per materialization.

What solution would meet these end-user requirements while effectively controlling costs?