Once you've set up your saved query, you can find it on your homepage.
2. Clicking the query will allow you to "Execute Query" and show you the result set (if there is a SELECT at the end). Sometimes the query will have parameters you need to fill out first before executing.
Once you execute a query, you can switch the Display to Pivot Mode to see different visualizations of the data.
If you want to share the report, you can click the Pivot URL button on the top right to copy the URL to that pivoted report. Simply add it as an applet and bookmark it to return to the pivoted view!