Using the provided maps in Tableau, they cannot be rotated (this might make a good one for the Ideas section). However, using a background image this could probably be accomplished.
For number 2, filter actions could be used to have the map zoom into one specific point based on the spreadsheet. The following link provides more information on actions:
Hope this helps!
1. Change your x for y, BUT, for underlying streets and highways you are going to have to convert to foreground analysis rather than use the background map. Super bad practise, but possible.
If you can post a screenshot of your area of analysis, I could have a go and knock this up for you.
The other option is to change the axis (map options -> no map) but the only way to do this would be to convert to cartesian.