You have been tasked with creating a near real-time inventory dashboard that reads from the main inventory tables in your BigQuery data warehouse. The historical inventory data is stored in the form of inventory balances categorized by item and location. The inventory system receives several thousand updates every hour. Your goal is to maximize the performance of the dashboard while ensuring the accuracy of the data. What steps should you take to accomplish this?