Shawn Wallwork recently alerted me to a way to get roads to show nicely in Tableau maps. You will want to check out his post here: http://community.tableau.com/message/191176#191176
You'll want to see what level of detail it includes for the Puget Sound region of WA (but considering that's where Tableau's main office is, maybe you're in luck!)
As far as other WMS services that include what you're looking for, I'm not sure I can be of much help. But hopefully others here will know some options.
Unfortunately there isn't any good option. WMS is a very enterprise-y legacy mapping standard, first created some time ago and it hasn't evolved very much. Urban Mapping is Tableau's mapping partner and we provide native access to Tableau, obviating the needs for WMS. We already offer most of what you are looking for! You can read a bit more on this thread and on a microsite we created.
Not exactly a match to your question but maybe something useful could pop up.
That's a useful list.
For custom mapping in Tableau, I'm using the following:
- ESRI ArcMap (using personal geodatabase, which is MS Access)
- QGIS using PostgreSQL with a PostGIS instance (as the backend dB)
- Geoserver (as the WMS/WFS/Shapefile/Raster file server)
- AtlasStyler (to style the XML/SLD files)
- RIchard Leeke's "Shapetotab"
- R + Openlayers
For Data (mostly ESRI shapefiles):
- NOAA (RIDGEradar, Watchwarn)
- USGS (HRO)
- Ordnance Survey (UK)
- Ireland Census Bureau
Answering your questions:
- demographic information - ideally population and income
- Public transportation
I'd look at the National Atlas WMS server - if the data is US Centric.
As you can see, the data and mapping tools are available, and with the exception of ESRI, by and large, open source. If you like, there is also an idea here, which may be of interest to you.
While I agree WMS is an older standard, I disagree with Ian, in as much as WMS is a capability in Tableau that shouldn't be ignored, because it is as stable and responsive as you make it. Once you have generated your own map layers and start serving them, bear in mind the data is hosted by you, not a third party, so you have greater control over the data's look and feel. I get exceptional offline and online performance using Geoserver (especially with postGIS tables), you can layer as you wish, and style the maps in your own way, and the only cost is development time.