O'Reilly logo

Microsoft Business Intelligence Tools for Excel Analysts by Bernard Wehbe, Jared Decker, Michael Alexander

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 14: Using the Data Mining Add-In for Microsoft Office

In This Chapter

  • Installing the Data Mining Add-In
  • Leveraging the Data Mining Table Analysis Tools

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. 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.

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.

Installing and Activating the Data Mining Add-In

Open Excel and look for a Data Mining tab on the Ribbon. If you see one, the Data Mining Add-In is already activated. If you don’t see the tab, you have to download and install it yourself.

Downloading the Data Mining Add-In

Type Excel Data Mining Add-In in your favorite search engine to find the free installation package. Note that Microsoft offers versions for SQL Server 2008 and SQL Server 2012. Be sure to download the version that matches the version of SQL Server your organization is using.

After it is installed, follow these steps to activate the add-in:

  1. Choose File → Options.
  2. Select the Add-Ins option on the left, and select COM Add-Ins from the Manage drop-down menu. Click Go.
  3. Select SQLServer.DMClientXLAddIn and SQLServer.DMXLAddIn ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required