Use excel for data mining (1)

Use excel for data mining (1)
Use excel for data mining (1)

After configuring the environment, you can use excel for data mining.

For environment configuration problems, see:

Http://blog.csdn.net/xinxing__8185/article/details/46445435

Example DMAddins_SampleData.xlsx

File: http://download.csdn.net/detail/xinxing__8185/8780481

This dataset can be used for the following exercises:

Before use, make excel connect to analysis service: <Strong? Http: www.bkjia.com kf ware vc "target =" _ blank "class =" keylink "> VcD4KPHA + IDxpbWcgc3JjPQ = "http://www.2cto.com/uploadfile/Collfiles/20150612/20150612102021118.png" alt = "\">

The localhost is already connected.

Click New:

Enter the server name. The local server is generally named localhost:

Test the connection. After the connection is successful, click OK, indicating that the excel file is connected to the analysis service.