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

Author Archive

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

Excel 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 More

Adding 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 More

The 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

Subscribe

You can subscribe to our RSS feed.