Tableau maps address information by ZIP. When your organization needs more detailed mapping of addresses, show off your skills with Google Geolocation API, VBA, and Excel.
Use Tableau tabadmin to Clean House and Free Storage. Using this script you can leverage the power of tabadmin cleanup by pipping a highly verbose output into a daily log file as part of regular Tableau server maintenance.
You don't always get to choose your production software. Anytime a professional software product stores a date as a float it seems like someone should get a good scolding. There are rare occasions where a float is a necessary design decision, but that doesn't make it mean you need to enjoy working with that database.