StatSlice Business Intelligence and Analytics | Business Intelligence and Analytics Dallas | Business Intelligence Training Dallas

Archive for the ‘Data Mining’ Category

Excel at Data Mining – How to Detect Categories

Today, I’m going to show you how to detect categories in your data in less than 5 minutes with the Microsoft Excel data mining add-in. Our goal is to uncovered hidden categories or clusterings in our data.

Read More

Excel at Data Mining – How to Randomly Sample Your Data

Today, I’m going to show you how to random sample and oversample data in less than 5 minutes with the Microsoft Excel data mining add-in. In this example, we will create a random sample and oversample the bike buyer source data.

Read More

Excel at Data Mining – How to Manage Models

Today, I’m going to show you how to browse, document, and manage models in 5 minutes with the Microsoft Excel data mining add-in. The assumption of this post is that you have already installed the data mining add-in for Excel and configured the add-in to be pointed at an instance of SQL Server with Analysis Services to which you have access rights.

Read More

Excel at Data Mining – Creating a Classification Matrix

Today, I’m going to show you how to create and read a Classification Matrix in less than 5 minutes with the Microsoft Excel data mining add-in. Our goal is to create a Classification Matrix based on a mining structure with all of its associated models that we have created previously.

Read More

Excel at Data Mining – Creating a Profit Chart

Today, I’m going to show you how to create and read a Profit Chart in less than 5 minutes with the Microsoft Excel data mining add-in*. In this example, we will create a profit chart based on a mining structure with all of its associated models that we have created previously.

Read More

Excel at Data Mining – Connecting to a SQL Server Data Source

Today, I’m going to show you how to connect to a SQL Server data source in less than 5 minutes with the Microsoft Excel data mining add-in. Our goal is to connect to a SQL Server data source and then create a Neural Network Model on the data.

Read More

Excel at Data Mining – Your First Lift Chart

In this blog, Billy Decker shows you how to create and read a lift chart in less than 5 minutes with the Microsoft Excel data mining add-in. In this example, we will create a lift chart using a Logistic Regression model and look at its performance.

Read More

Excel at Data Mining – Your First Predictions

Today, I’m going to show how to start making your first predictions in less than 5 minutes with the Microsoft Excel data mining add-in. In this example, we will create a set of predictions for new customers using a Logistic Regression models based upon old customers.

Read More

Excel at Data Mining – Time Series Forecasting

Today, I’m going to show you how to start data mining in less than 5 minutes with the Microsoft Excel data mining add-in. In this example, we will create a forecasting model that will predict the trend of bikes sales in different regions.

Read More

Excel at Data Mining – Quick Data Preparation

Using Microsoft Excel’s data mining add-in, I’m going to show you how to use Data Preparation wizards to get your data ready to be mined. You will need to configure the add-in to point at an instance of SQL Server to which you have access rights before beginning this tutorial.

Read More

Subscribe

You can subscribe to our RSS feed.