Data Mining with DMX

To my knowledge, Microsoft has three methods of performing data mining within their BI stack. The Excel Add-In, the GUI and wizards within BIDS, and the DMX query language. Obviously the key draw back to the Excel Add-in is that you can't schedule it to run automatically without human intervention. However, the Excel Add-in provides an excellent method to form your hypothesis and test it. The GUI and the wizards are nice and you can create repeatable processes using those tools alone. The command line interface that DMX provides has it's own appeal to old folks like me who can remember when computer magazines included program listings.