Companion for MS Analysis Services

 

Today I discovered a very nice Analysis Services client tool. Produced by SQLMinds, the tool seems a great addition to Analysis Services. It provides many components, among them a performance tuning service, an OLAP cube browser for the web and a very nice web front end for data mining, the DM Companion tool which can be launched at http://x32.sqlminds.com/dmcompanion.

So, here are a few really nice things about the DM Companion tool (BTW, a fully working demo is running at the aforementioned URL).

The tool works to some extent like a Data Mining -specific SQL Server Management Studio for the web. Therefore, it allows you connect to the server of your choice (through the Analysis Services HTTP pump). The demo seems to allow anonymous connections (pretty safe  as all the interactions offered by the tool are read-only).  Next you get to chose your AS catalog and the mining model you want to use.

For each model you have the option to browse the content or execute predictions.

The prediction feature provides a nice interface for defining singleton predictions, as you can see below:

image

The interface supports specifying multiple nested table keys as input, so the tool can perform associative predictions as well. It reminds me of the XMLA Thin Miner sample running on SQLServerDatamining,com, however, it looks much better and is nicely integrated with the rest of the application. While prediction functions do not seem to be directly supported, the application is able to predict a cluster for clustering models.

The model browsing features are really nice. Analysis Services includes a set of sample web viewers for Naive Bayes, Trees and Clustering. This application provides some seriously better looking viewers for these algorithms, and extends the suite at least for Neural Networks (a really nice viewer), Sequence Clustering and Association Rules.  The DM Companion viewers offer all the features in the sample viewers, with a nicer implementation which uses AJAX and has better graphics, plus a solid set of new features, the most spectacular being the interactive dependency net browser and the pie chart visualization for decision trees, which you can see below.

image image

 

Overall, DM Companion looks like a really nice tool for sharing your data mining implementation on the web

4 Responses to “Companion for MS Analysis Services”

  1. Thank you for the review. Let us know what needs to be added to the tool.

    Some additional info:
    a) You can use the tool to access any HTTP configured SSAS (http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx). Just set the http endpoint under “Analysis Server” textbox and click refresh. You may need to enable ‘cross-domain’ and javascript options under IE, and add http://*.sqlminds.com to your trusted sites (under IE Security->Trusted Sites). The tool is client-side only script so it uses the NT identity of the user to access SSAS so security is built in by default.

    b) Check out the BI Companion at http://x64.sqlminds.com/bicompanion for cube browsing.

    The tools are FREE for use as long as they are launched from our web site. For more info: http://www.sqlminds.com/Products/CompanionforMSAnalysisServer/tabid/119/Default.aspx

  2. […] - bookmarked by 4 members originally found by velcrokat1 on 2008-07-23 Companion for MS Analysis Services http://www.bogdancrivat.net/dm/archives/45 - bookmarked by 1 members originally found by rafitzg […]

  3. […] recorded first by fletort on 2008-08-08→ Companion for MS Analysis Services […]

  4. […] public links >> xmla Analysis Services via HTTP First saved by pancresio | 7 days ago Companion for MS Analysis Services First saved by marctrumm | 10 days ago Q&A on Management Excellence and Oracle EPM, […]

Discussion Area - Leave a Comment