You have been tasked to design a solution for a global e-commerce company using BigQuery. They require real-time analysis of sales transactions. The company has a strong presence in the US, Europe, and Asia. Your design should prioritize data locality and low latency querying for each region. What is the optimal approach to meet these requirements?