SQL Server DAX Setup Sample Databases
By: Siddharth Mehta
In this chapter we will look at the steps to setup a test environment using the AdventureWorks databases.
Follow the steps below to create an environment where we can learn more about DAX.
Setup a tabular SSAS database
A detailed discussion of Data Modeling in Tabular SSAS is out of scope of this tutorial, but we need some tabular structure where we can work with DAX. Follow the steps below so we have a database to work with.
Step 1: Download "Adventure Works DW 2014 Full Database Backup" and "Adventure Works Tabular Model SQL 2014 Backup" files.
Step 2: Assuming that SQL Server and SSAS Tabular is already installed, restore the DW backup file on a SQL Server instance, and Tabular model backup on SSAS instance.
Step 3: Open a new SSAS Tabular project in SQL Server Data Tools by using the "Import from server (Tabular)" template and selecting the tabular model that we restored in Step 2.
Step 4: Once you create the project, open the Model.bim file. It won't have any data yet. From the Model menu, select Process > Process All option. This option will read data from the DW and process all the tables in the model. Post processing you should be able to see data in all the tables.
Step 5: From the model menu, select Model View > Diagram
View. You should be able to see a model as shown below. Now we have a database ready
to practice DAX.
- Consider exploring the data model to understand the different tables, relationships and the type of data in different tables.