First, did you know that you can query BigQuery from Excel using ShufflePoint? If you are interested please contact support for details. 

The BQ-GA integration pushes detailed data into BQ each day. The result is a lot of BQ tables. Including all the relevant tables one-by-one in the FROM clause would be painful if you were doing, for example, a Year-to-date query. Now BQ offers a nice solution. Google added exressiveness to the FROM clause so that you can select a group of dated tables using filtering expressions. Find out more at the update query reference at https://developers.google.com/bigquery/query-reference#tablewildcardfunctions.