Scenario: You use a SQL-based tool to visualize data stored in BigQuery. The visualizations require the use of outer joins and analytic functions. Visualizations must be based on data that is no less than 4 hours old. Business users have reported that the visualizations are too slow to generate. You want to improve the performance of the queries while minimizing the maintenance overhead of the data preparation pipeline. Question: How should you improve the performance of the visualization queries and reduce the maintenance overhead of the data preparation pipeline?