Archive for the ‘Blog Authors’ 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 MoreMaking Data-Driven Decisions – Tableau Analytics Demo
On July 9th, StatSlice Systems and Tableau hosted a lunch and learn event in Dallas, Texas to share how Tableau enables people at all levels throughout an organization to investigate data to find nuances, trends, and outliers in a flash and can better enable you to make data-driven decisions. During the event, Jim Vogel presented a case study on using Tableau effectively for business analytics.
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 MoreHow to Use Power Query: Introducing Microsoft’s Newest BI Tool
If you’ve spent much time in Excel, odds are that at one point you had data in one table that you needed to combine with data from another table. There are few ways to attempt this manually which are time consuming and might not even work. But this task and more are easy with Microsoft Power Query.
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 MoreWebinar: Building a B2B Analytics Portal with Tableau
In this webinar, James Vogel and Bernard Wehbe show you how to use Tableau to quickly build a custom B2B analytics portal to serve your client’s reporting needs over the internet.
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 MoreThe Rise of the Texas Wide Receiver
Feb 5, 2014 was National Signing Day. Every major sports outlet covered which high school football students signed with big time college program. I thought I’d throw in my own visualization about how the players from the state of Texas faired in the signing day. I know that the offensive systems in Texas high schools […]
Read More