While I haven't personally developed out a storm track path map, the answer is yes it can be done. You'll need access to the storm data which is probably freely available from NOAA NHC Data Archive
Here's an example: Track natural storms by power and path | Tableau Software You'll also want to look at Dual-Axis mapping which allows you to layer two maps onto each other: Create Dual-Axis (Layered) Maps in Tableau - Tableau or here: Dual Axis Mapping - Many Ways
OR...using WMS (Web Mapping Services) there's a great blog from Interworks on how to do this: https://interworks.com/blog/ccrouch/2016/03/22/storm-chasing-tableau-how-create-weather-map
If this answers your question, please mark the response as correct to close the thread and so that others might find the answer in the future.
I did this just today. Mostly for fun.
Here are resources I used.
As Don mentioned, you can get the storm data from NHC.
I used this link to get information about Dorian: NHC Data in GIS Formats
You can download a five day forecast polygon shape file from there.
I have access to property zip code data. You will need a shapefile for zip codes.
You can get that from here: https://public.opendatasoft.com/explore/dataset/us-zip-code-latitude-and-longitude/export/
Once you have both the shapefiles, in tableau you can can chose source as a spatial file and join the two together:
Next I used my own source to get properties by zip and joined it to the zip file.
You start by pulling the Geometry field for the storm onto detail mark and Tableau will bring up the Map and represent the polygon.
Pull in the generated longitude of the storm again(This is NOT the longitude of the zip code) again so we can create a dual axis.
Select Dual axis on the second longitude.
Now swap out the geometry detail on the second longitude mark with the geometry of the zip code.
Now you can pull whatever measure you want to display. If you want to display the measure at zip level don't forget to pull in the zip code as detail.
That's the basics of it. There will be some work required in proper formatting to make it presentable. I'm still learning that part.