Thanks for the feedback @Jermuk!
Would it make any sense to bridge the MQTT broker back to our head office to allow for real-time displays and dashboards?
And for the daily reports (realtime not required, but 15-60min update would be nice), would you store that on a site database, then sync to an external database (cloud, or head office), or store straight to cloud, and site needs to read from external database?