View Full Document

Microsoft SQL Server 2008 Data Mining Add-ins for Microsoft Office 2007



View the full content.
View Full Document
View Full Document

13 views

Unformatted text preview:

Microsoft SQL Server 2008 Data Mining Add ins for Microsoft Office 2007 May 2010 Data Mining in Excel 2007 Data Mining Client for Excel 2007 The Data Mining Client add in enables you to go through the full data mining lifecycle within Excel by using your spreadsheet data If you have the Data Mining Client add in installed you should see the Data Mining ribbon when you launch MS Office Excel 2007 in your desktop If you don t have Data Mining Client add in installed you can download it for free and install it from Microsoft s website at http www microsoft com downloads details aspx FamilyId 896A493A 2502 4795 94AEE00632BA6DE7 displaylang en The add ins installation wizard will walk you through the process The ribbon has Data Preparation Data Modeling Accuracy and Validation Model Usage and Management tools as shown below In this document we will go through all the tools in the Data Mining ribbon and see their functionality Now before you can use these Data Mining tools you need a connection to Analysis Services server To connect to Analysis Services server click on the No Connection button shown above in the ribbon under Data Mining Analysis Services Connections screen comes up Open a new connection by clicking the New button Enter Server name as https pump waltoncollege uark edu olap msmdpump dll secure http connection to the Analysis Services server select a specific user name and password as Log on credentials Enter the credentials supplied to you by the University of Arkansas WALTON ES and password and check the check box for Allow saving password Then select DMAddinsDB database from the dropdown list of Catalog names Last Updated 1 16 2019 8 53 a1 p1 Page 2 Data Mining in Excel 2007 NOTE The database named DMAddinsDB is created in the process of preparing the server DMAddinsDB database acts as a container for the mining models created by the Add ins It is a shared database that is supposed to be there to hold data temporarily while users connect to Analysis



Access the best Study Guides, Lecture Notes and Practice Exams

Loading Unlocking...
Login

Join to view Microsoft SQL Server 2008 Data Mining Add-ins for Microsoft Office 2007 and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Microsoft SQL Server 2008 Data Mining Add-ins for Microsoft Office 2007 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?