Creating an Analysis Services Project (Basic Data Mining Tutorial)


Applies To: SQL Server 2016 Preview

Each Microsoft SQL Server Analysis Services project defines the objects in a single Analysis Services database. An Analysis Services database can contains many different types of objects

  • Multidimensional models (cubes)

  • Mining structures and mining models

  • Supporting objects such as data sources, data source views, and custom assemblies

Note that you do not require a cube to do data mining. If you need to perform data mining on an existing cube, you should add the data mining models to the same project you used to build the cube. However, for most purposes you can build your models on relational data sources, such as a data warehouse, and get better performance if a cube is not involved.

In this tutorial you will use a relational data warehouse, AdventureWorksDW2012, as the data source. You will deploy all your data mining objects to an Analysis Services database named BasicDataMining, used just for data mining.

By default, Analysis Services uses the localhost instance for new projects. If you are using a named instance or a different server, you must first create and open the project and then change the instance name.

For more information about Analysis Services projects, see Creating an Analysis Services Project.

To create an Analysis Services project

  1. Open SQL Server Data Tools (SSDT).

  2. On the File menu, point to New, and then select Project.

  3. Verify that Business Intelligence Projects is selected in the Project types pane.

  4. In the Templates pane, select Analysis Services Multidimensional and Data Mining Project.

  5. In the Name box, name the new project BasicDataMining.

  6. Click OK.

To change the instance where data mining objects are stored

  1. In SQL Server Data Tools (SSDT), on the Project menu, select Properties.

  2. On the left side of the Property Pages pane, under Configuration Properties, click Deployment.

  3. On the right side of the Property Pages pane, under Target, verify that the Server name is localhost. If you are using a different instance, type the name of the instance. Click OK.

Creating a Data Source (Basic Data Mining Tutorial)

Build Analysis Services Projects (SSDT)
Create an Analysis Services Project (SSDT)