---
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 [!INCLUDE[ssSampleDBCoFull](../includes/sssampledbcofull-md.md)] who has been tasked with designing a business intelligence application in [!INCLUDE[ssCurrent](../includes/sscurrent-md.md)]. [!INCLUDE[ssSampleDBCoFull](../includes/sssampledbcofull-md.md)] hopes to leverage your [!INCLUDE[ssASnoversion](../includes/ssasnoversion-md.md)] 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 [!INCLUDE[ssNoVersion](../includes/ssnoversion-md.md)] starts with the creation in [!INCLUDE[ssBIDevStudioFull](../includes/ssbidevstudiofull-md.md)] of a [!INCLUDE[ssNoVersion](../includes/ssnoversion-md.md)] [!INCLUDE[ssASnoversion](../includes/ssasnoversion-md.md)] project based on the [!INCLUDE[ssASnoversion](../includes/ssasnoversion-md.md)] project template for multidimensional modeling and data mining. After you create an [!INCLUDE[ssASnoversion](../includes/ssasnoversion-md.md)] 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 [!INCLUDE[ssASnoversion](../includes/ssasnoversion-md.md)] 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)](../../2014/tutorials/creating-an-analysis-services-project-basic-data-mining-tutorial.md)  
  
 [Creating a Data Source (Basic Data Mining Tutorial)](../../2014/tutorials/creating-a-data-source-basic-data-mining-tutorial.md)  
  
 [Creating a Data Source View (Basic Data Mining Tutorial)](../../2014/tutorials/creating-a-data-source-view-basic-data-mining-tutorial.md)  
  
## First Task in Lesson  
 [Creating an Analysis Services Project (Basic Data Mining Tutorial)](../../2014/tutorials/creating-an-analysis-services-project-basic-data-mining-tutorial.md)  
  
## Next Lesson  
 [Lesson 2: Building a Targeted Mailing Structure (Basic Data Mining Tutorial)](../../2014/tutorials/lesson-2-building-a-targeted-mailing-structure-basic-data-mining-tutorial.md)  
  
## See Also  
 [Data Source Views in Multidimensional Models](https://docs.microsoft.com/analysis-services/multidimensional-models/data-source-views-in-multidimensional-models)   
 [Data Sources Supported (SSAS Multidimensional)](https://docs.microsoft.com/analysis-services/multidimensional-models/supported-data-sources-ssas-multidimensional)   
 [Build Analysis Services Projects (SSDT)](https://docs.microsoft.com/analysis-services/multidimensional-models/build-analysis-services-projects-ssdt)   
 [Creating an Analysis Services Project](../analysis-services/lesson-1-1-creating-an-analysis-services-project.md)