About

This is an example of a WordPress page, you could edit this to put information about yourself or your site so readers know where you are coming from. You can create as many pages like this one or sub-pages as you like and manage all of your content inside of WordPress.

  1. Stevan,

    Really interesting stuff here! I’m a newbie (sort of) to SSDM and I’d like to find a pre-packaged application that enables me to do the following:

    1)Select an existing view or OLAP cube from a SQL Server database;

    2)Choose various types of statistical analysis based on date ranges and parameters I select;

    (example – show me the six-month moving avg for each salesperson along with a prediction of the next six months, and a regression vs. the company’s overall sales, filtered by several key products or categories)

    3)Produce nicely-formatted reports that a client can print out, or email a pdf to his sales team, or the like.

    Is there such a package at the ‘ready-to-go’ stage that anyone has put together?

    I realize that all of this can be done with the proper skills and time; I have done some similar things using MSFT Access database reports, so the logic is pretty easy really – I just want a package that I can call up (or plug in) and have a nice interface like a dialog box – then you just select DB, select dataset, build the report from the available params and menu of stat functions, and save/print whatever you want from the results.

    There is quite a demand out there for this (and I know PowerPivot is one great tool to get there) but I’m curious if someone has a product or open source package already wired together? Please email me at w.herbert@tx.rr.com with any help.

    Thanks!

    Bill Herbert

    • Hey Bill, pleased to meet you – I don’t think there’s any such package out there yet. However, you could select from a cube or database and apply one of the nine algorithms I’ve discussed here, right in an ordinary SSDM project. The catch is that to produce well-formatted reports, you’d either have to connect to Reporting Services – which can load SSDM results directly – or develop a custom user interface in C# or VB. Also, certain simple stats might be easier to calculate right on the server, such as moving averages in cases where you didn’t need a full Time Series. I’m not aware of anyone packaging all of this in a ready-to-go fashion though. You’re right though, it would be quite useful to have software out there that did all of this stuff under the hood. There’s a hole in the market there…

      — Steve

  2. I forgot to mention, Reporting Services can produce Microsoft Word documents, which can of course be easily ported to .pdfs. Another common approach is to simply copy the graphical controls produced by SSDM as image files and paste them into other programs. All of this functionality already exists, but hasn’t yet been integrated into a point-and-click type of package yet. Thanks for feedback BTW šŸ™‚

  3. Stevan, do you have a page on your website which consolidates all the links in the “Rickety Stairway to SQL Server Data Mining”? This could be very helpful.

    • Yes, I do šŸ™‚ You can access them all through the Categories entry for the Rickety series, which can be found here https://multidimensionalmayhem.wordpress.com/category/a-rickety-stairway-to-sql-server-data-mining/ . There should be several other categories in the sidebar to the right, including: An Informal Compendium of SSAS Errors; DIY Data Mining Outlier Detection with SQL Server; Integrating Other Data Mining Tools with SQL Server; Miscellaneous SQL Server Topics; Other Analysis Services (SSAS) Topics and PASS (Professional Association of SQL Server). If you have any suggestions on how I can improve the navigation, feel free to share ’em. I plan to keep this blog going for years to come, so I might as well pay more attention to the organization and formatting šŸ™‚ Thanks

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: