Testing the randomness of the split with a SSAS decision trees model

You need to test the randomness of the split from the previous recipe. You will use the SSAS decision trees algorithm to check whether you can predict a set membership with input variables. You should get a very shallow tree, meaning there are no patterns that could explain the set membership.

Getting ready

For this recipe, you need to have SSAS installed in multidimensional and data mining mode. You also need to finish the previous recipe.

How to do it...

1. In SSDT, add a new analysis services multidimensional and data mining project to the Chapter08 solution and name the project Ch08SSAS.
2. In solution explorer, right-click the Data Sources folder and select New Data Source to create a new data source.
3. In the Data Source Wizard welcome screen, click Next.
4. In the Select how to define the connection screen, create a data source using a connection AdventureWorksDW2014 database. Click Next.
5. In the Impersonation Information screen, you...