The full breadth of functionality that comes with the Data Mining Add-In is staggering. If you inadvertently close the setup wizard, or if you need to point to a different Analysis Services database, you can open the setup wizard by choosing Help → Getting Started on the Data Mining tab. Select the appropriate option and follow the instructions in the setup wizard. The Data Mining Add-In requires an existing 2008 (or later) Analysis Services database to serve as the engine for processing the analyses you eventually perform with it.įigure 14-1: The Data Mining Add-In requires a connection to an Analysis Services database instance. Upon restarting Excel, you're automatically walked through a wizard to connect your newly installed Data Mining Add-In to an Analysis Services database (see Figure 14-1). Pointing to an Analysis Services database Select SQLServer.DMClientXLAddIn and SQLServer.DMXLAddIn in the list of available COM Add-Ins. Select the Add-Ins option on the left, and select COM Add-Ins from the Manage drop-down menu. Be sure to download the version that matches the version of SQL Server your organization is using.Īfter it is installed, follow these steps to activate the add-in:Ģ. Note that Microsoft offers versions for SQL Server 2008 and SQL Server 2012. Type Excel Data Mining Add-In in your favorite search engine to find the free installation package. If you don’t see the tab, you have to download and install it yourself. If you see one, the Data Mining Add-In is already activated. ![]() Open Excel and look for a Data Mining tab on the Ribbon. ![]() Installing and Activating the Data Mining Add-In In this chapter, you discover some of the ways you can use this robust analysis tool to develop analytics and reporting that would have been previously impossible with vanilla Excel. With the Data Mining Add-In, you can utilize powerful SQL Server Analysis algorithms to find data patterns, uncover hidden relationships, develop data-based predictions, and perform many more complex analyses. The Data Mining Add-In for Microsoft Office provides you with a way to leverage the power of Analysis Services from within the familiar Excel interface. Leveraging the Data Mining Table Analysis Tools.Microsoft Business Intelligence Tools for Excel Analysts (2014) PART II: Leveraging SQL for Business Intelligence Chapter 14: Using the Data Mining Add-In for Microsoft Office
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |