Tools Can Be So Much Fun PLUS Cluster Accuracy

For a project I was working on I had to create a lot of models and extract one piece of information from each of them for charting.  Particularly, I wanted to see the impact of changing the cluster count of a clustering model vis-a-vis the model "score" which is stored in the content column "MSOLAP_NODE_SCORE"….

1

New Server at SQLServerDataMining.com

After three years the data mining team has upgraded the server for SQLServerDataMining.com.  The previous server with a 1 GB server with (IIRC) a 40 GB hard drive that ran SQL Server, IIS, Analysis Services and Reporting Services and a beta version of the toolkit we were using.  Now we have a faster server with…

1

How can we mine? Let me count the ways…

Recently I received some customer feedback that SQL Server Data Mining "doesn’t have enough algorithms."  More specifically, the comment was that we have the same capabilities are other Data Mining providers, we just "hide" many facilities as algorithm parameters rather than separating out each as a named algorithm.  So let’s count the Microsoft algorithms a…

1

New DM Team Blog

Bogdan Crivat – whom many of you know from sqlserverdatamining.com and the DM Forums has started his own data mining blog – with a first entry to answer many of the questions around “Excel does this and DM does that”.  In this entry Bogdan discusses comparative regression accuracy between Excel and SQL Server Data Mining,…

0

Test post from Windows Live Writer

This isn’t really a post, but since these giant blue and green guys showed up on campus, I figured I would have to check it out.  For some reason the Live package seems to take quite a long time to install, but it all happens in the background so I could easily go start it…

1

New Time Series Features for SQL Server 2008

The time series algorithm has had some major changes for SQL Server 2008.  We’ve ramped up the algorithm and added prediction against new data.  While the new data prediction is just as cool as the algorithm changes, I’ll have to save that for later – this post I’ll just tell you about the algorithm. As…

1

Preview the Model Documentation feature of the next version of the Data Mining Client for Excel

The attached document has a preview of the output of a new “Model Documentation” feature for our next version of the data mining addins.  You just click on a button, select a model and recieve a report containing (hopefully) interesting and pertinent information about the mining model. What do you think?  Does the feature provide…

2

SQL Server 2008 and Analysis Services DMV’s

One of the cool new features coming in SQL Server 2008 Analysis Services are Dynamic Management Views (DMV).  Actually I never thought of them as DMVs coming from my background, but since everyone else calls them that, there’s no reason we shouldn’t either. So what are they and how did they come about? DMX users…

2

Data Mining Virtual Hands-on Lab Now Available! Also, in other news, Donald in a fishbowl!

For those of you who have been dying to try out the data mining addins we released earlier this year – here’s your chance!  Ok, scratch that, if you’re reading my blog you’ve been there done that, but if there’s that someone special who you know would love the addins and hadn’t had the chance…

2

BIDS Helper available on CodePlex

Furmanng posted a set of utilities to CodePlex that help your OLAP development called BidsHelper. The features are directly integrated into BI Development Studio in toolbars and menus inside the Analysis Services designers.   It currently has an aggregation manager, calc helpers, MDX Script deployment utility, dimension health utility, plus many more features.  Even if you…

1