Skip to content

Latest commit

 

History

History
39 lines (29 loc) · 3.39 KB

File metadata and controls

39 lines (29 loc) · 3.39 KB
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 kfile

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)

First Task in Lesson

Creating an Analysis Services Project (Basic Data Mining Tutorial)

Next Lesson

Lesson 2: Building a Targeted Mailing Structure (Basic Data Mining Tutorial)

See Also

Data Source Views in Multidimensional Models
Data Sources Supported (SSAS Multidimensional)
Build Analysis Services Projects (SSDT)
Creating an Analysis Services Project