Excel-based data mining method

A data mining and data technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of reports and no data mining products, etc., and achieve the effect of simple and easy to learn modeling, increase profitability, and save costs

Inactive Publication Date: 2013-01-23
PCI TECH GRP CO LTD
View PDF2 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Most of the current research projects are funded by the government, such as the National Natural Science Foundation of China, the 863 Program, the "Ninth Five-Year Plan", etc., but there are no reports on domestic data mining products

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Excel-based data mining method
  • Excel-based data mining method
  • Excel-based data mining method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0024] The principle of embodiment one, participate in image 3 .

[0025] Excel calls the data mining engine in the SQLSERVER2008 database through the SQLSERVER2008 data mining add-in program to perform data mining, and outputs the results to excel.

[0026] Excel data mining needs to install excel 2007, if it is an earlier version, it needs to be uninstalled, and then install the excel 2007 version; after the installation, you need to install the excel data mining plug-in to connect to the database; you can install the sqlserver 2008 database or other connected ones on this machine Installed on the data of sqlserver2008.

[0027] Implementation process of Embodiment 1, see figure 1 .

[0028] The present invention provides a kind of data mining method based on excel, described method comprises the training of excel model and the utilization of excel model:

[0029] The training of the excel model includes processes such as data acquisition, data preprocessing, model oper...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses an excel-based data mining method. Data mining is realized by virtue of an excel tool and a data mining external program as well as a database. By mining operating data or production data of an enterprise for a plurality of years, the modes can be applied to improve an operating strategy according to the useful mode found out by a data mining algorithm, so that the labor productivity is improved, the cost is reduced, and the profit of the enterprise is increased. General data mining can be achieved by professional personnel and a lot of money, and common medium-sized and small enterprises cannot bear the burden, therefore, the data mining achieved by the excel is elaborated in the text and most people who understand the excel can conduct the data mining.

Description

technical field [0001] The invention relates to the field of data mining, in particular to an excel-based data mining, which can simplify and practicalize the data mining. Background technique [0002] With the increasing influence of data mining in academia and industry, in recent years, data mining has developed rapidly in research and application, especially in the field of business and banking, which is faster than the development of research. [0003] Domestic personnel engaged in data mining research are mainly in universities, and some are in research institutes or companies. There are many research fields involved, generally focusing on the research of learning algorithms, the practical application of data mining and the research on the theory of data mining. Most of the current research projects are funded by the government, such as the National Natural Science Foundation of China, the 863 Program, the "Ninth Five-Year Plan", etc., but there is no report on domesti...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 何健明刘世清汤湛成
Owner PCI TECH GRP CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products