Thank you very much for your response! This is great stuff! I'm pretty sure this will meet all of my needs.
Many thanks for providing your map. It's obvious that there's a lot of work in there and I am very grateful that you were so willing to share it with me. I have a couple of questions that I wonder if you can help with.
Have you or anyone else tried to use the map with a Microsoft Analysis Services data connection in Tableau? The reason I ask is that when I join to this type of connection, the dimensions/attributes and measures are grayed out.
We do separate budgets for Canada and French Canada (Quebec). Is there a way for me to differentiate these?
Q1 no, but I've managed a PostgresSQL/ESRI personal dB data connection before. I believe there is an extension to Microsoft SQL sever (Spatial) that would possibly help you, but I don't want to lead you down the wrong path. Would advise using Postgres SQL/PostGIS, as these are spatially aware. The tables need to be Tableau ready format though:
I.e. ID,path order,X,Y
Q2 For the split between countries and provinces, you'll need to create a hierarchy using Natural Earth Admin 0 (the file I gave you) and Natural Earth Admin 1. You can append the tables, but I'd advise using NEA0 X,Y and NEA1 X,Y so you can join tables to both and use a dimension swapper between the two. Left outer on ID of the Feature (Shapefile DBF) PostGIS comes with a handy SHP loader.