The tutorial assumes you are using AdventureWorksDW2012, however, later versions do work. It provides the original data used by the Analysis Services databases and projects that you build and deploy throughout the tutorial.

AdventureWorksDW2012 or later – This is a relational data warehouse that runs on a Database Engine instance.

For the purposes of this tutorial, you use the following relational database as your data source. 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.

Download adventureworks 2012 cube