Creating a SSAS Connection

Connecting the Data Mining Add-In to an SSAS instance involves two tasks. First, the SSAS server must be configured to work with the Data Mining Add-In. The second required task is adding the configured SSAS server connection within the Data Mining Add-In. In between those two tasks are some things that you can do to avoid common frustrations in making the connection to SSAS.

Configuring the SSAS Server

Within the Connection group of the Analyze menu, notice the No Connection label illustrated in Figure 10-14. This is an indication we have no SSAS server available to execute data mining operations. Therefore, our next step is configuring the connection between Microsoft Excel and SSAS.

Figure 10-14. Data Mining ...

Get PowerPivot for Business Intelligence Using Excel and SharePoint now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.