Join Ron Davis for an in-depth discussion in this video Analyzing key influencers, part of Excel Data-Mining Fundamentals.
- Now we're going to use the analyze tab to analyze our data. This is the little spreadsheet that comes when you install the SQL server data mining add-ins. That's because we have a set of data in here that we can use to go through and apply analytics to it. That's the same one we're going to use. Most of the stuff we're going to do over here on the this table tools. I'm going to go over to the analyze and the first thing we're going to do is we're going to call analyze key influences. What we want to analyze is purchased bikes.
We want to look at the group here and see which one of these different columns, these different attributes has the most influence on whether or not they purchased a bike. We'll just say run. And what that's going to do is put another sheet down here into the workbook. Just like that. Here we have the data mining discrimination and I'll add that report and close. This is the main one you want to look at here on the top. What we see is the relative impact for cars value of two favors no.
And that is a high relative impact, marital status. You come down and read that information. The second report here is your discrimination report. So, favors no and favors yes. Up here as opposed to just favors and the relative impact, this shows us the no as opposed to the yes. So, that's information. This is a handy little one to come through. Particularly this first chart is, in my opinion, by far the most important one because we can see here that immediately the value of the cars, at least for the input data that we send in, has the highest impact on whether or not they purchased a bike.
- Solving business problems with data mining
- Exploring Excel's data-mining algorithms
- Data mining with Excel SQL Server Analysis Services
- Using the Data Preparation tab
- Detecting categories
- Using the Prediction Calculator