Big data analysis tool and method based on EXCEL

The invention provides a big data analysis tool and method based on EXCEL. Through parameter configuration, the big data analysis method based on EXCEL uses the poi technique to export excel spreadsheet data, and solves the problem of iterative development of general software; through the role distr...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: ZHANG TINGTING, LUO BAOSHENG, LIU JIAN
Format: Patent
Sprache:chi ; eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
container_end_page
container_issue
container_start_page
container_title
container_volume
creator ZHANG TINGTING
LUO BAOSHENG
LIU JIAN
description The invention provides a big data analysis tool and method based on EXCEL. Through parameter configuration, the big data analysis method based on EXCEL uses the poi technique to export excel spreadsheet data, and solves the problem of iterative development of general software; through the role distribution mechanism, the operation can be divided into data analysts, auditors, operators, the underlying work is distributed to the data analyst, the operating interface is simple; by encapsulating codes and componentizing related functions, secondary development can be realized according to actual needs, the method has the advantages of simplicity, ease of use and low cost, compared with the way of web crawler + cloud computing, the method is more efficient and cost-effective and is very suitable for small and medium-sized enterprises to use. 本发明提供的基于EXCEL的大数据分析工具和方法,通过参数配置化,使用poi技术导出excle表格数据,解决了般软件需要迭代开发的问题;通过角色分配机制,将操作分为数据分析师、审核人员、操作人员,将底层工作交给数据分析师,操作界面简单医用;通过封装代码,将相关功能组件化,可以在此基础上根据实际需求快速进行二次开发,具有简单、易用、低成本的优点,相较
format Patent
fullrecord <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_CN108897877A</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>CN108897877A</sourcerecordid><originalsourceid>FETCH-epo_espacenet_CN108897877A3</originalsourceid><addsrcrecordid>eNrjZDBwykxXSEksSVRIzEvMqSzOLFYoyc_PAfJSFHJTSzLyUxSSEotTUxTy8xRcI5xdfXgYWNMSc4pTeaE0N4Oim2uIs4duakF-fGpxQWJyal5qSbyzn6GBhYWluYW5uaMxMWoA1BwqFA</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Big data analysis tool and method based on EXCEL</title><source>esp@cenet</source><creator>ZHANG TINGTING ; LUO BAOSHENG ; LIU JIAN</creator><creatorcontrib>ZHANG TINGTING ; LUO BAOSHENG ; LIU JIAN</creatorcontrib><description>The invention provides a big data analysis tool and method based on EXCEL. Through parameter configuration, the big data analysis method based on EXCEL uses the poi technique to export excel spreadsheet data, and solves the problem of iterative development of general software; through the role distribution mechanism, the operation can be divided into data analysts, auditors, operators, the underlying work is distributed to the data analyst, the operating interface is simple; by encapsulating codes and componentizing related functions, secondary development can be realized according to actual needs, the method has the advantages of simplicity, ease of use and low cost, compared with the way of web crawler + cloud computing, the method is more efficient and cost-effective and is very suitable for small and medium-sized enterprises to use. 本发明提供的基于EXCEL的大数据分析工具和方法,通过参数配置化,使用poi技术导出excle表格数据,解决了般软件需要迭代开发的问题;通过角色分配机制,将操作分为数据分析师、审核人员、操作人员,将底层工作交给数据分析师,操作界面简单医用;通过封装代码,将相关功能组件化,可以在此基础上根据实际需求快速进行二次开发,具有简单、易用、低成本的优点,相较</description><language>chi ; eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2018</creationdate><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20181127&amp;DB=EPODOC&amp;CC=CN&amp;NR=108897877A$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,776,881,25542,76290</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20181127&amp;DB=EPODOC&amp;CC=CN&amp;NR=108897877A$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>ZHANG TINGTING</creatorcontrib><creatorcontrib>LUO BAOSHENG</creatorcontrib><creatorcontrib>LIU JIAN</creatorcontrib><title>Big data analysis tool and method based on EXCEL</title><description>The invention provides a big data analysis tool and method based on EXCEL. Through parameter configuration, the big data analysis method based on EXCEL uses the poi technique to export excel spreadsheet data, and solves the problem of iterative development of general software; through the role distribution mechanism, the operation can be divided into data analysts, auditors, operators, the underlying work is distributed to the data analyst, the operating interface is simple; by encapsulating codes and componentizing related functions, secondary development can be realized according to actual needs, the method has the advantages of simplicity, ease of use and low cost, compared with the way of web crawler + cloud computing, the method is more efficient and cost-effective and is very suitable for small and medium-sized enterprises to use. 本发明提供的基于EXCEL的大数据分析工具和方法,通过参数配置化,使用poi技术导出excle表格数据,解决了般软件需要迭代开发的问题;通过角色分配机制,将操作分为数据分析师、审核人员、操作人员,将底层工作交给数据分析师,操作界面简单医用;通过封装代码,将相关功能组件化,可以在此基础上根据实际需求快速进行二次开发,具有简单、易用、低成本的优点,相较</description><subject>CALCULATING</subject><subject>COMPUTING</subject><subject>COUNTING</subject><subject>ELECTRIC DIGITAL DATA PROCESSING</subject><subject>PHYSICS</subject><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2018</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNrjZDBwykxXSEksSVRIzEvMqSzOLFYoyc_PAfJSFHJTSzLyUxSSEotTUxTy8xRcI5xdfXgYWNMSc4pTeaE0N4Oim2uIs4duakF-fGpxQWJyal5qSbyzn6GBhYWluYW5uaMxMWoA1BwqFA</recordid><startdate>20181127</startdate><enddate>20181127</enddate><creator>ZHANG TINGTING</creator><creator>LUO BAOSHENG</creator><creator>LIU JIAN</creator><scope>EVB</scope></search><sort><creationdate>20181127</creationdate><title>Big data analysis tool and method based on EXCEL</title><author>ZHANG TINGTING ; LUO BAOSHENG ; LIU JIAN</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_CN108897877A3</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>chi ; eng</language><creationdate>2018</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>ZHANG TINGTING</creatorcontrib><creatorcontrib>LUO BAOSHENG</creatorcontrib><creatorcontrib>LIU JIAN</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>ZHANG TINGTING</au><au>LUO BAOSHENG</au><au>LIU JIAN</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Big data analysis tool and method based on EXCEL</title><date>2018-11-27</date><risdate>2018</risdate><abstract>The invention provides a big data analysis tool and method based on EXCEL. Through parameter configuration, the big data analysis method based on EXCEL uses the poi technique to export excel spreadsheet data, and solves the problem of iterative development of general software; through the role distribution mechanism, the operation can be divided into data analysts, auditors, operators, the underlying work is distributed to the data analyst, the operating interface is simple; by encapsulating codes and componentizing related functions, secondary development can be realized according to actual needs, the method has the advantages of simplicity, ease of use and low cost, compared with the way of web crawler + cloud computing, the method is more efficient and cost-effective and is very suitable for small and medium-sized enterprises to use. 本发明提供的基于EXCEL的大数据分析工具和方法,通过参数配置化,使用poi技术导出excle表格数据,解决了般软件需要迭代开发的问题;通过角色分配机制,将操作分为数据分析师、审核人员、操作人员,将底层工作交给数据分析师,操作界面简单医用;通过封装代码,将相关功能组件化,可以在此基础上根据实际需求快速进行二次开发,具有简单、易用、低成本的优点,相较</abstract><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language chi ; eng
recordid cdi_epo_espacenet_CN108897877A
source esp@cenet
subjects CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
title Big data analysis tool and method based on EXCEL
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-28T16%3A21%3A06IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-epo_EVB&rft_val_fmt=info:ofi/fmt:kev:mtx:patent&rft.genre=patent&rft.au=ZHANG%20TINGTING&rft.date=2018-11-27&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3ECN108897877A%3C/epo_EVB%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rfr_iscdi=true