当前位置：网站首页>Data mining series (2)_ The data mining plug-in of Excel connects to SQL server

Data mining series (2)_ The data mining plug-in of Excel connects to SQL server

2022-04-22 03:44:00 【Wen Xin '】

List of articles

One 、 Connect

My computer -》 Right click -》 management -》

Insert picture description here
take MSSQLServerOLAPService open ：

Insert picture description here
open SQL Server：
Insert picture description here
Insert picture description here
New database ：
Insert picture description here

open Excel Data mining plug-in ：
Insert picture description here
Insert picture description here
Insert picture description here
At this point, the connection is successful
Insert picture description here
You can use Excel Complete the work of data mining ：
Insert picture description here

Two 、 Use

Simply use data to get familiar with the functions of data mining ：

1、 Data browsing function

Insert picture description here
First Ctrl+A Select all data
Insert picture description here
Insert picture description here
Insert picture description here
It's similar to python In the middle of cut and qcut.

2、 data classification

Insert picture description here
Insert picture description here
Insert picture description here
Insert picture description here
Insert picture description here
Insert picture description here
The structure just created above can also be created in SQL Server Found in ：
Insert picture description here
Right click and select browse ：
Insert picture description here
At this time in SQL Server You can also see Excel Mining model in
Insert picture description here

版权声明
本文为[Wen Xin ']所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204220343269379.html

边栏推荐

猜你喜欢

随机推荐