![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step01_StartingDSV.jpg) Step 1 Starting, a Data Source View (DSV) exists | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step02_NewMiningStructure.jpg) Step 2 Right click, Create a New Mining Structure | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step03_WelcomeToTheDataMiningWizard.jpg) Step 3 Welcome to the Data Mining Wizard |
![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step04_SelectTheDefinitionMethod.jpg) Step 4 Select the Definition Method | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step05_SelectTheDataMiningTechnique-A.jpg) Step 5A Select the Data Mining Technique-A (before selection is completed) | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step05_SelectTheDataMiningTechnique-B.jpg) Step 5B Select the Data Mining Technique-B (after selection is completed) |
![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step06_SelectTheDataSourceView.jpg) Step 6 Select the Data Source View | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step07_SpecifyTableTypes-A.jpg) Step 7A Specify Table Types-A (before selection(s) is/are completed) | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step07_SpecifyTableTypes-B.jpg) Step 7B Specify Table Types-B (after selection(s) is/are completed) |
![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step08_SpecifyColumnsContentDataType.jpg) Step 8 Specify Columns’ Content and Data Type | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step09_SpecifyTheTrainingData-A.jpg) Step 9A Specify the Training Data (before selections are completed) | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step09_SpecifyTheTrainingData-B.jpg) Step 9B Specify the Training Data (after selections are completed) |
![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step10_CompletingTheWizard-A.jpg) Step 10A Completing the Wizard (default dialog box values) | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step10_CompletingTheWizard-B.jpg) Step 10B Completing the Wizard (changed default dialog box values) | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step11_CompletedMiningStructure.jpg) Step 11 Completed Mining Structure (in Management Studio) |
![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step12_MiningModelsTAB.jpg) Step 12 Mining Models TAB | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step13_MiningModelsTAB_SetAlgorithmParameters-A.jpg) Step 13A Mining Models TAB Right click, Set Algorithm Parameters… | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step13_SetAlgorithmParameters-B.jpg) Step 13B Set Algorithm Parameters (prior to changes) |
![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step13_SetAlgorithmParameters-C.jpg) Step 13C Set Algorithm Parameters (after changes) (the only change was Periodicity_Hint) | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step14_TargetedMailingMM_ViewDesigner-A.jpg) Step 14A Targeted Mailing Mining Model Right Click, View Designer… | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step14_TargetedMailingMM_ViewDesigner-B.jpg) Step 14B Targeted Mailing Mining Model ViewDesigner Mining Structure TAB |
![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step15_TargetedMailing_MiningModelsTAB.jpg) Step 15 Targeted Mailing Mining Model Mining Models TAB (hovering over “Create a Related Mining Model” BUTTON) | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step16_TargetedMailing_NewMiningModels-A.jpg) Step 16A Targeted Mailing Mining Model New Mining Models dialog box | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step16_TargetedMailing_NewMiningModels-B.jpg) Step 16B Targeted Mailing Mining Model New Mining Models dialog box (dialog box completed) [I used a special charachter for the name here] |
![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step17_TargetedMailing_NewMiningModels_NB_Warning.jpg) Step 17 Targeted Mailing Mining Model New Mining Models Naïve Bayes Warning | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step18_TargetedMailing_NewMiningModels_NB_completed.jpg) Step 18 Targeted Mailing Mining Model New Mining Model – Naïve Bayes model – completed | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step19_TargetedMailing_CreateAnotherNewMiningModels.jpg) Step 19 Targeted Mailing Mining Model Mining Models TAB (hovering over Create a Related Mining Model BUTTON) |
![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step20_TargetedMailing_AnotherNewMiningModels-A.jpg) Step 20A Targeted Mailing Mining Model New Mining Model dialog box | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step20_TargetedMailing_AnotherNewMiningModels-B.jpg) Step 20B Targeted Mailing Mining Model New Mining Model dialog box – completed | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step21_TargetedMailing_AnotherNewMiningModels_completed.jpg) Step 21 Targeted Mailing Mining Model New Mining Models – completed (as viewed in Management Studio) |
![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step22_MgmtStudio_SSAS-Connection_BeforeDeployment.jpg) Step 22 Viewing Management Studio, Analysis Services connection, prior to deployment of project | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step23_Deploy_in_BIDS.jpg) Step 23 Right click, deploy project in BIDS | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step24_Deploy_in_progress_BIDS.jpg) Step 24 Deployment in progress (BIDS) |
![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step25_Deploy_completed_BIDS.jpg) Step 25 Deployment completed (BIDS) | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step26_Deploy_completed_SSMS.jpg) Step 26 Deployment completed (SSMS) (Notice the Mining Structures node expanded) | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step27_SalesForecastingMM_ViewDesigner.jpg) Step 27 Sales Forecasting Mining Model Right click, ViewDesigner… |
![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step28_SalesForecastingMM_MiningStructureTAB.jpg) Step 28 Sales Forecasting Mining Model Mining Structure TAB | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step29_SalesForecastingMM_MiningModelViewTAB_MSTimeSeriesViewer_selected.jpg) Step 29 Sales Forecasting Mining Model Mining Model Viewer TAB Selecting the Microsoft Time Series Viewer | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step30_SalesForecastingMM_MiningModelViewTAB_MSTimeSeriesViewer_ChartsTAB-AllItems.jpg) Step 30 Sales Forecasting Mining Model Mining Model Viewer TAB, Decision Tree TAB – selected Microsoft Time Series Viewer – selected, all items included |
![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step31_SalesForecastingMM_MiningModelViewTAB_MSTimeSeriesViewer_ChartsTAB-ItemsRemoved.jpg) Step 31 Sales Forecasting Mining Model Mining Model Viewer TAB, Microsoft Time Series Viewer – selected Charts TAB – selected, some items Removed | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step32_TargetedMailingMM_MiningModelViewTAB_MSTreeViewer_DecisionTreeTAB-selected.jpg) Step 32 Targeted Mailing Mining Model Mining Model Viewer TAB Microsoft Tree Viewer Decision Tree TAB – selected | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step33_TargetedMailingMM_MiningModelViewTAB_MSTreeViewer_DecisionTreeTAB-BackgroundListBox_equals_1.jpg) Step 33 Targeted Mailing Mining Model Mining Model Viewer TAB Microsoft Tree Viewer Decision Tree TAB – selected setting the Background List Box equals to ‘1’ |
![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step34_TargetedMailingMM_MiningModelViewTAB_MSTreeViewer_DecisionTreeTAB-pan-screenzoom-control.jpg) Step 34 Targeted Mailing Mining Model Mining Model Viewer TAB Microsoft Tree Viewer Decision Tree TAB – selected, using the “pan screen & zoom” control | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step35A_TargdMailingMM_MiningModelViewTAB_MSTreeViewer_DependencyNetworkTAB.jpg) Step 35A Targeted Mailing Mining Model Mining Model Viewer TAB Microsoft Tree Viewer Dependency Network TAB, All links displayed | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step35B_TargMailMM_MinModelViewTAB_MSTreeViewer_DependencyNetworkTAB-All_Links_slider-moved-down-three-notches.jpg) Step 35B Targeted Mailing Mining Model Mining Model Viewer TAB Microsoft Tree Viewer Dependency Network TAB, Links slider moved down three notches |
![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step36_TargMailMM_MinModelViewTAB_MSTrView_DepNetwkTAB-AllLinkssliderdownthreenotches_BBNode-selected.jpg) Step 36 Targeted Mailing Mining Model Mining Model Viewer TAB Microsoft Tree Viewer Dependency Network TAB, Links slider moved down three notches Bike Buyer Node – selected (in the middle) | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step37_TargMailMM_MinModelViewTAB_MSTrView_DepNetwrkTAB_Slider-to-StrongestLinks_BikeBuyerNode-selected.jpg) Step 37 Targeted Mailing Mining Model Mining Model Viewer TAB Microsoft Tree Viewer Dependency Network TAB, Bike Buyer Node – selected (in the middle) All Links slider moved to Strongest Links, Bike Buyer Node – selected | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step38_TargetedMailingMM_MiningAccuracyChartTAB_DependencyNetworkTAB.jpg) Step 38 Targeted Mailing Mining Model Mining Accuracy Chart TAB Column Mapping TAB |
![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step39_TargetedMailingMM_MiningAccuracyChartTAB_SelectCaseTableDialog.jpg) Step 39 Targeted Mailing Mining Model Mining Accuracy Chart TAB Column Mapping TAB Select Case Table Dialog | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Impl_DM_SQL2K5_Step40_TargetedMailingMM_MiningAccuracyChartTAB_CaseTableSelected_vTargetMail.jpg) Step 40 Targeted Mailing Mining Model Mining Accuracy Chart TAB Column Mapping TAB Select Case Table selected, vTargetMail | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Step41_TargMailMM_MinAccChartTAB_CaseTableSelected_vTargetMail_SelPredMinModCol-PredVal-ONE-chosen-A.jpg) Step 41A Targeted Mailing Mining Model Mining Accuracy Chart TAB Column Mapping TAB Case Table selected, vTargetMail, choosing the “Predict Value”, where “1” is being chosen |
![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Step41_TargetedMailingMM_MiningAccuracyChartTAB_CaseTableSelected_vTargetMail_SelPredMinModCol-PredVal-ONE-chosen-B.jpg) Step 41B Targeted Mailing Mining Model Mining Accuracy Chart TAB Column Mapping TAB Case Table selected, vTargetMail, choosing the “Predict Value”, after “1” has been chosen | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Step42_TargMailMM_MinAccChartTAB_CaseTableSelected_vTargetMail_SelPredMinModCol-LiftChartTAB-selected-A.jpg) Step 42 Targeted Mailing Mining Model Mining Accuracy Chart TAB Lift Chart TAB selection made | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Step43_TargMailMM_MinAccChartTAB_CaseTableSelected_vTargetMail_SelPredMinModCol-LiftChartTAB-rendered-B.jpg) Step 43 Targeted Mailing Mining Model Mining Accuracy Chart TAB Lift Chart TAB, graph rendered |
![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Step44_TargMailMM_MinAccChartTAB_CaseTableSelected_vTargetMail_SelPredMinModCol-ClassificationMatrixTAB-selected-A.jpg) Step 44 Targeted Mailing Mining Model Mining Accuracy Chart TAB Classification Matrix TAB – selected | ![](http://wordpress.e-squillace.com/wp-content/uploads/2020/06/Step45_TargMailMM_MinAccChartTAB_CaseTableSelected_vTargetMail_SelPredMinModCol-ClassificationMatrixTAB-rendered-B.jpg) Step 45 Targeted Mailing Mining Model Mining Accuracy Chart TAB Classification Matrix TAB-rendered | |
| | |