Report Portal

Virtual Lab: SQL Server 2008 Data Mining Table Analysis Tools for Excel

Duration: 90 Minutes
Event ID: 1032397025

After completing this lab, you will be better able to prepare Excel and your data for table analysis, use the Key Influencers tool and interpret the reports generated, use the Detect Categories tool, the Fill from Example tool, forecasting tool (to predict future sales), and use the Highlight Exceptions tool to locate possible data outliers or corruption. 

Additionally, you will be be more familiar with the Scenario Analysis tool to analyze what demographics changes increase a customers probability of buying a product, use the Prediction Calculator tool to determine the risk and profitability in marketing to potential customers with a set of particular demographic features, and use the Shopping Basket Analysis tool to determine products that are frequently purchased together.

Tags: data mining, excel, virtual lab

 

2007-2015 VidasSoft Systems Inc.