sql server data warehouse: What's the best Microsoft tool for data modeling of a data warehouse on SQL

That's just about like asking, "What's the best car?" It depends on
what you will be doing with it. Do you need to model both the logical
and physical? Do you need it to do schema generation for you? Reverse
engineering? Does it need to link into SourceSafe?

The big three that I see used the most are ERwin, Power Designer, and
Microsoft Visio w/ Enterprise Architect. I would suggest that you start
with these, check out the websites, download the free trials, and
compare their functionality and ease of use with what you need.

HTH,
-Tom.

ER-Studio is also a very big player


Greg Jackson
PDX, Oregon