title

Lesson 1: Preparing the Analysis Services Database (Basic Data Mining Tutorial) | Microsoft Docs

ms.custom

ms.date

06/13/2017

ms.prod

sql-server-2014

ms.reviewer

ms.technology

analysis-services

ms.topic

conceptual

ms.assetid

2a796977-6568-4705-9d27-86a9b36658c2

author

minewiskan

ms.author

owend

manager

craigg

Lesson 1: Preparing the Analysis Services Database (Basic Data Mining Tutorial)

You are a new employee of [!INCLUDEssSampleDBCoFull] who has been tasked with designing a business intelligence application in [!INCLUDEssCurrent]. [!INCLUDEssSampleDBCoFull] hopes to leverage your [!INCLUDEssASnoversion] data mining experience to discover interesting and actionable information about people who have purchased bicycles. They then want you to predict which prospective customers are most likely to purchase a bicycle in the future.

Designing this application in [!INCLUDEssNoVersion] starts with the creation in [!INCLUDEssBIDevStudioFull] of a [!INCLUDEssNoVersion] [!INCLUDEssASnoversion] project based on the [!INCLUDEssASnoversion] project template for multidimensional modeling and data mining. After you create an [!INCLUDEssASnoversion] project, you define one or more data sources. Then, you define a view of the metadata, called a data source view, from selected tables and views from the data sources.

In this lesson, you will create an [!INCLUDEssASnoversion] project, define a single data source, and add a subset of tables to a data source view. This lesson includes the following tasks:

Creating an Analysis Services Project (Basic Data Mining Tutorial)

Creating a Data Source (Basic Data Mining Tutorial)

Creating a Data Source View (Basic Data Mining Tutorial)