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

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

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

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

Webinar: 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 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

The 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

Subscribe

You can subscribe to our RSS feed.