In Tableau, you can create dashboard using the OData information.
From Data, click Connect to Data.
Select "OData."
In the Select or enter a URL field, paste the URL from your query.
On Step 3, click Connect.
On Step 4, enter a name for the feed.
Click OK.