So last week I shared my initial clustering analysis using SAP Predictive Analytics 2.0 (Expert Analysis) Looking back at NCAA Basketball Clustering Analysis – Reviewing the Results

Sadly, it did reveal that my team, Kansas, didn’t stand a chance of winning yesterday’s game against Wichita State (congratulations to Wichita State).  Kansas was the only team in cluster 4 who won the first round.  Did this help heal my wounds of losing?  No…I’m reminded of Dr. Smith from Lost in Space:

“The pain of it all” – but life goes on, and there’s more data to review.  So today, I took the winning “Sweet Sixteen” teams and ran autoclustering again

/wp-content/uploads/2015/03/1autoclusering_670240.png

I reduced the number of clusters and looked at winning percentage this time.

/wp-content/uploads/2015/03/2success_670265.png

I ran the analysis successfully, as shown above

/wp-content/uploads/2015/03/3clustersize_670266.png

Above shows my clusters resulting from Predictive Analytics.

/wp-content/uploads/2015/03/5parallel_670267.png

Parallel Coordinates chart is a little easier to read this time (you can tell Kentucky because they continue to have 0 losses)

/wp-content/uploads/2015/03/6scattermatrix_670268.png

Above is the scatter matrix chart from SAP Predictive Analytics

How did the results look?

/wp-content/uploads/2015/03/7cluster_670269.png

So 11 teams are in cluster 1 and 5 are in cluster 3

See teams in the crosstab below – first is cluster 1:

/wp-content/uploads/2015/03/8crosstab_670270.png

Cluster 3 has 5 teams below:

/wp-content/uploads/2015/03/11cross_670280.png

Should I predict based on this?  Kentucky (Cluster 3) over West Virginia (Cluster 1)?

NC State over Louisville?  Utah over Duke?

I am not sure.

Also it doesn’t help that Oklahoma and Michigan State are in the same cluster.


So I go back and look at the old clusters (pre-tournament):


/wp-content/uploads/2015/03/oldcluster_670281.png

Cluster 8 continued:

/wp-content/uploads/2015/03/old2_670282.png

Cluster 8 had the most wins, so based on this Michigan State is favored over Oklahoma


We’ll see what happens this coming weekend.


Reference:

BI pre-conference session at ASUG Annual conference

Monday, May 4. (extra registration fees apply).

Featuring Hands-on SAP BusinessObjects BI 4.1 w/ SAP NetWeaver BW Powered by SAP HANA – Deep Dive

See details here: http://bit.ly/ASUGPreConBI

Focus on Analysis Office, Lumira, and Design Studio. You get to work with these for 7 hours! Full day BI workshop. Limited to 30 people. One person per machine (no sharing).

ASUG BI Annual Conference Schedule with Abstract Links

Also see Upcoming ASUG Business Intelligence Community W… | ASUG

At ASUG BI Annual Conference 2015 Schedule | ASUG there is an Excel version of the grid schedule

Also some upcoming ASUG Predictive Analytics webcasts are listed below:

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply