SQL Server Analysis Service 2012 – Basic Data mining - Part 1

Preparing the Analysis Services Database

In order to create Analysis Services Database make sure that the following are installed:

·         Microsoft SQL Server 2012

·         Microsoft SQL Server Analysis Services in multidimensional mode

·         The Adventure Works DW 2012 database.

Step1:- create an Analysis Services project           

·         Open SQL Server Data Tools (SSDT).

·         On the File menu, point to New, and then select Project.

·         Select Analysis Services Multidimensional and Data Mining Project.

·         Name the new project DataMining.

·         Change the instance where data mining objects are stored. on the Project menu, select Properties.  

·         Property Pages pane, under Target, verify that the Server name is localhost. In my case I am using server as “DELL\MSSQLSERVER2012” and click apply and ok.

Step2:- Creating a Data Source

·         In Solution Explorer, right-click the Data Sources folder and select New Data Source.

·         On the Welcome to the Data Source Wizard page, click next.

·         On the Select how to define the connection page, click New to add a connection to the AdventureWorksDW2012 database.

·         Click Finish and The new data source, Adventure Works DW 2012, appears in the Data Sources folder in Solution Explorer

Step3:- Creating a Data Source View

·         In Solution Explorer, right-click Data Source Views, and select New Data Source View.

·         On the Welcome to the Data Source View Wizard page, click Next

·         On the Select a Data Source page, under Relational data sources, select the Adventure Works DW 2012 data source that you created in the last task. Click  Next

·         On the Select Tables and Views page select ProspectiveBuyer (dbo) and vTargetMail (dbo) table to the right hand side.

·         On the Completing the Wizard page, by default the data source view is named Adventure Works DW 2012. Change the name to Targeted Mailing, and then click Finish

·         The new data source view opens in the Targeted Mailing.dsv [Design] tab.