This is a dedicated watch page for a single video.
The business intelligence team has a dashboard configured to track various summary metrics for retail stores. This includes total sales for the previous day alongside totals and averages for a variety of time periods. The fields required to populate this dashboard have the following schema: store_id INT , total_sales_qtd FLOAT , avg_daily_sales_qtd 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 For demand forecasting, the Lakehouse contains a validated table of all itemized sales updated incrementally in near real-time. This table, named products_per_order, includes the following fields: store_id INT , order_id INT , product_id INT , quantity INT , price FLOAT , order_timestamp TIMESTAMP Which solution meets the expectations of the end users while controlling and limiting possible costs?