Reply to thread

If you're asking if BigQuery is for you, I would say that's very subjective but I think it's probably overkill for most automotive businesses / dealerships.

Something like PowerBI can drill into your data and get conclusions for you if you know what you're looking for.

I view BigQuery as something to be used in situations where you have massive amounts of data points that are disparate and you're trying to find trends and conclusions based on that. If you tracked a dealership with foot traffic, online traffic, sales, service, wi-fi access point connections, daily weather, staff vacations, working hours, etc and you put it all in BigQuery, you could ask it to find things like the busiest time of day or which weather results in the most sales walk-ins, etc.

The potential is massive, but unless you have multiple rooftops and loads of data to track, I think it's overkill.