Archive for the ‘Billy Decker – Blog’ 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 MoreExcel 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 MoreExcel 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 MoreExcel 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 MoreExcel 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 MoreExcel 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 MoreExcel 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 MoreExcel 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 MoreExcel 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 MoreExcel 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 MoreExcel at Data Mining – Your First Model
Today, I’m going to show how to start data mining in less than 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 to which you […]
Read MoreAdding Silver to Gold
Science and business intelligence share a very similar drive to gain more knowledge and understanding. Where science seeks to understand what is happening in the universe through equations and building upon or replacing theories, business intelligence uses data modeling and visualizations to understand what is happening in the universe of a particular company. Both fields have […]
Read MoreThe Importance of Being Naïve
One of the first simplifying assumptions a scientist makes when studying a system is that nothing in the system interacts with anything else or that each object is independent. This seems like a fairly naïve assumption because experience tells us that everything interacts with…well, everything else. However, there are a couple of major advantages that […]
Read More