Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.
Socrata OData documentation
Tableau users should select the OData v2 endpoint option.