Skip to content

creating-an-analysis-services-project-basic-data-mining-tutorial.md

Latest commit

 

History

History
64 lines (42 loc) · 3.69 KB

creating-an-analysis-services-project-basic-data-mining-tutorial.md

File metadata and controls

64 lines (42 loc) · 3.69 KB
title Creating an Analysis Services Project (Basic Data Mining Tutorial) | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.suite
ms.technology
analysis-services
ms.tgt_pltfrm
ms.topic article
ms.assetid 784c0401-0358-4117-9c85-4e8220ce71d9
caps.latest.revision 50
author jeannt
ms.author jeannt
manager jhubbard

Creating an Analysis Services Project (Basic Data Mining Tutorial)

Each [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssASnoversion] project defines the objects in a single [!INCLUDEssASnoversion] database. An [!INCLUDEssASnoversion] 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, [!INCLUDEssSampleDBDWobject], as the data source. You will deploy all your data mining objects to an [!INCLUDEssASnoversion] database named BasicDataMining, used just for data mining.

By default, [!INCLUDEssASnoversion] 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 [!INCLUDEssASnoversion] projects, see Creating an Analysis Services Project.

To create an Analysis Services project

  1. Open [!INCLUDEssBIDevStudioFull].

  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. [!INCLUDEclickOK]

To change the instance where data mining objects are stored

  1. In [!INCLUDEssBIDevStudioFull], 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. [!INCLUDEclickOK]

Next Task in Lesson

Creating a Data Source (Basic Data Mining Tutorial)

See Also

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