Step 3: Install databases An Analysis Services multidimensional model uses transactional data that you import from a relational database management system. The query designer returns the same data, except the data is presented as a flat rowset. I go to the bottom of the page and click AdventureWorksDW 2012 data file link. Below you can see the Microsoft website path which you can use to download AdventureWorksDW 2012 click on yellow box SQL Server 2012 DW.
In this step by step SQL Tutorial I will show you how to download and install Adventure Works DW 2012. For the purpose of this tutorial I will use SQL Server 2012. Adventureworks 2012 Sample Database Download.
