Jamie's Junk

Whatever comes to mind "The official blog of the SQL Server Analysis Services Data Mining Architect" (tm)

  • Jamie's Junk

    What's a book without a cover - redux

    • 1 Comments
    Three years ago next month I posted on our first book and now we can peek at what's to come! I guess with the price of gas, Wiley decided that black gold was more interesting than the yellow stuff.  Readers of the last edition will notice a new addition...
  • Jamie's Junk

    Screencasts, more screencasts, plus some scripts.

    • 1 Comments
    Oddly enough, this week was a banner week for data mining screencast references. I took some internal strategy training, and was asked by several attendees for links to the screencasts that I made (on the download page ) and received two (maybe three...
  • Jamie's Junk

    "Supercrunchers" and Microsoft Data Mining

    • 1 Comments
    Ian Ayres, Yale Law school professor and author of SuperCrunchers , talks about data driven decisions and the Data Mining Addins in this Gartner podcast . He also mentions some other company, but we won't talk about them :) Give it a listen!
  • Jamie's Junk

    Unwinding MDX Flattening Semantics with DMX

    • 3 Comments
    When issuing an MDX statement in code, you have the option of requesting either a multidimensional set or a relational rowset as the result set. If you are familiar with MDX and multidimensional concepts, the multidimensional result is the obvious choice...
  • Jamie's Junk

    A data mining survey

    • 1 Comments
    Karl Rexer of Rexer analytics has taken up a hobby of implementing a somewhat unscientific survey of data mining users to determine trends in the industry - see what kinds of software people are using - all that kind of stuff. In Karl's own words: ...
  • Jamie's Junk

    Silverlight Viewers, Data Mining Road Show, and TechEd

    • 1 Comments
    A enthusiast in China took a suggestion all the way and has implemented at least a decision tree viewer in Silverlight - I don't read Chinese, but you can see it here Rafal Lukawiecki - consistantly one of the top TechEd Europe speakers - has been...
  • Jamie's Junk

    DMX Queries - the DataSource hole

    • 3 Comments
    So many people have told me how much they like DMX - the fact that they can use a query language to create, train, and query mining models is simply unprecedented in the data mining world. And they love it. Until..... Until, that is, they decide...
  • Jamie's Junk

    To (a) or not to (a), that is the question?

    • 1 Comments
    While looking for content for the next edition of my book (newsflash! I'm currently working on the next edition of my book!) I went hunting around for that trick using decision trees to predict the states of a single column independently rather than all...
  • Jamie's Junk

    Tools Can Be So Much Fun PLUS Cluster Accuracy

    • 1 Comments
    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...
  • Jamie's Junk

    New Server at SQLServerDataMining.com

    • 1 Comments
    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...
  • Jamie's Junk

    How can we mine? Let me count the ways...

    • 1 Comments
    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...
  • Jamie's Junk

    New DM Team Blog

    • 0 Comments
    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...
  • Jamie's Junk

    Test post from Windows Live Writer

    • 1 Comments
    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...
  • Jamie's Junk

    New Time Series Features for SQL Server 2008

    • 1 Comments
    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...
  • Jamie's Junk

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

    • 2 Comments
    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...
  • Jamie's Junk

    SQL Server 2008 and Analysis Services DMV's

    • 2 Comments
    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...
  • Jamie's Junk

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

    • 2 Comments
    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...
  • Jamie's Junk

    BIDS Helper available on CodePlex

    • 1 Comments
    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...
  • Jamie's Junk

    New DMX Syntax option in SQL Server SP2

    • 0 Comments
    Quite a while back I promised to tell everyone about the subtle new feature in DMX in SQL Server 2005 SP2. Well, that day has finally arrived, true believers – your patience has paid off! J One of the nice improvements we made to SQL Server 2005 DMX...
  • Jamie's Junk

    Important Update for the Data Mining Addins!

    • 1 Comments
    Due to a late found performance regression we decided to rerelease the data mining addins. A change we made in the product shortly before release was causing queries in the Data Mining Client for Excel to take several minutes instead of several seconds...
  • Jamie's Junk

    Tree Utilities in Analysis Services Stored Procedures

    • 1 Comments
    This past week I was helping out a customer that wanted to reduce the length of a questionairre by using data mining to determine which of the 300+ questions were actually necessary for them to get the understanding they required. By using a tree model...
  • Jamie's Junk

    Social Network Analysis with SQL Server 2005 Data Mining

    • 0 Comments
    A few years ago John Hancock spent some time with our team and did some interesting work around using the Association Rules algorithm and some custom Analysis Services stored procedures to implement link analysis (a.k.a. social network analysis). His...
  • Jamie's Junk

    Automatically Label Clusters using Analysis Services Stored Procedures

    • 0 Comments
    I just found this awesome posting on CodePlex by furmangg to automatically label the clusters generated by the clustering algorithm. It examines the cluster content to generate human-readable descriptions and then changes the labels appropriately. Check...
  • Jamie's Junk

    Data Mining Addins Released to Web!

    • 2 Comments
    The SQL Server 2005 Data Mining Add-ins for Office 2007 have finally released to web yesterday along with SP2 of SQL Server 2005. The DM team has done a great write-up on how to get the add-ins (and everything else necessary) and also a really nice whitepaper...
  • Jamie's Junk

    Predictive Traffic Analytics with SQL Server 2005

    • 0 Comments
    Inrix is a company that uses data mining is a very interesting way - they combine department of transportation information with info from other sources to build models that predict what the traffic will be like at any given point and time and can then...
Page 2 of 5 (117 items) 12345