Analytics in Action

Archive for April, 2011

Creating prediction queries using the SQL Server data mining add in for Excel

The Data Mining Query allows you to create predictions using a data mining model that you have already created. In this demonstration I show how you can use this tool to predict whether customers are likely to attend a marketing...

Using Profit Charts in SQL Server 2008 to Optimize Marketing Campaigns

Profit charts provide an estimate of the maximum profit that can be generated from a marketing campaign using various data mining models. This demonstration used the SQL Server 2008 Data mining addin for Excel 2010 to generate a profit ...

Using Lift (Accuracy/Gains) Charts to Evaluate Data Mining Models in SQL Server 2008

Lift Charts are used to evaluate & compare the strength of predictive models. This tutorial uses a lift chart to compare  a Neural Network to a  Decision Tree model created in a previous video. The raw data that will enable...

Creating Data Mining Structures & Predictive Models (Neural Networks & Decision Trees) using the Excel Add-In for SQL Server 2008

A demonstration of how to create Data Mining Structures & Predictive Models using the Excel Data mining Addin for SQL Server 2008. A data mining structure is created first and then a Microsoft Decision Tree & Neural Network are created....