Bi developpers are using Visual Studio for SSAS, SSRS and SSIS development all the time,but tend to forget to use Visual studio for there database development.

A database project, even when you generate all your structures, opens the road to putting your database code under source control and move forward to a continuous integration/deployment for the database part of your datawarehouse. You can start from scratch or start with your currenct databases as a starting point to move foreward with the reverse engineering option.
With a template in Visual studio you can generate all your tables and views in a second from a metadata solution.

I'll show how to set up your database project, how to generate tables and views from metadata directly in the database project and where database project can help in deploying your entire solution quickly to all you environments, including security settings and statics base data.