BigQuery can handle highly denormalised data, but most business intelligence tools cannot. This is what I meant when I said

"The downsides are clear: the incoming data are hard to understand and work with; they are not readily digestible by business intelligence tools."