Data Mining Visualization with Microsoft Analysis Services

Version 1

    Description

    Data Mining Visualization with Microsoft Analysis Services prediction model queries (DMX). For this I used the classic Microsoft SQL Server AdventureWorks 2012 SSAS Mined Customers OLAP cube and ran a Prediction Join on the Decision Tree data mining model, clustering and several others to bring the data into Tableau. The prediction query (DMX) result data set included buyer prospect demographic attributes and a Prediction Score obtained from the PredictProbability function.

     

     

    Screenshot:

    00DM.jpg

    Tableau Version: (example 7.1)

    8.0

    Original Author

    Jen Underwood

    jen@impactanalytix.com

    @idigdata

    http://www.impactanalytix.com