Analytics in Action

Using Data Mining Models in SQL Server Integration Services (SSIS)

Once you have created a data mining model, such as a Decision Tree, or Neural Network, you normally want to create some predictions. This is easily done using the "Data Mining Query"  transformation in SSIS. SSIS is particularly useful if you need...

Building a Tabular Data Warehouse using SQL Server Analysis Services (SSAS) 2012

Tabular models are a simple but high performance alternative to building OLAP cube based Data Warehouses. This video demonstrates how a simple Tabular Data Warehouse can be built in about 5 minutes. Tabular models are a new feature in SQL...

Creating a Cluster Model using the Excel Addin for SQL Server.

Clustering is the classification of similar objects into different groups, or more precisely, the partitioning of a data set into subsets (clusters), so that the data in each subset (ideally) share some common trait - often proximity according to some...

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....

Microsoft Visio Data Mining Add in for Excel

The Visio Data Mining Add In for Excel provides a very flexible template to visualize & format data mining models produced in the Excel Data Mining Addin. This demonstration covers 4 topics - 1) what is the Microsoft Visio Data...

Analyze Key Influencers Tool Demonstration.

Demonstration of how to use the "Analyze Key Influencer Tool" using the Excel Data Mining Add in. The video covers 1) What is the "Key Influencer Tool"? 2) What sort of business problems can it help answer? 3) A practical...

Using a Decision Tree Algorithm via the Excel Data Mining Addin

The Excel Data Mining Addin can be used to build predictive models such as Decisions Trees within Excel. The Excel Data Mining Addin sends data to SQL Server Analysis Services (SSAS) where the models are built. The final model is...