Creating an Analysis Services Project (Basic Data Mining Tutorial)

Each Microsoft SQL Server Analysis Services project defines the schema for the objects in a single Analysis Services database. An Analysis Services database contains mining structures and mining models, multidimensional models (cubes), and supporting objects such as data sources and data source views. In this tutorial you will be using the AdventureWorksDW2012 database as a data source. You will deploy the data mining objects to an Analysis Services database named BasicDataMining.

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.

Next Task in Lesson

Creating a Data Source (Basic Data Mining Tutorial)

See Also

Concepts

Build Analysis Services Projects (SSDT)

Create an Analysis Services Project (SSDT)

Other Resources

How to: Build and Deploy an Analysis Services Project