Increase the compute resources of the Databricks cluster before running the weekly report to reduce execution time.

Directly query the transactional data each time the report is needed, ensuring the most up-to-date information is used.

Create a new Delta Lake table that pre-aggregates the sales data on a daily basis and query this table for the weekly report.

Store the query results in a blob storage and update it manually every month to ensure data freshness.