{"id":"https://openalex.org/W4390664220","doi":"https://doi.org/10.1051/e3sconf/202447402029","title":"Using the power query system for processing and data mining SAP ERP","display_name":"Using the power query system for processing and data mining SAP ERP","publication_year":2024,"publication_date":"2024-01-01","ids":{"openalex":"https://openalex.org/W4390664220","doi":"https://doi.org/10.1051/e3sconf/202447402029"},"language":"en","primary_location":{"id":"doi:10.1051/e3sconf/202447402029","doi":"https://doi.org/10.1051/e3sconf/202447402029","is_oa":true,"landing_page_url":"https://doi.org/10.1051/e3sconf/202447402029","pdf_url":"https://www.e3s-conferences.org/articles/e3sconf/pdf/2024/04/e3sconf_icite2023_02029.pdf","source":{"id":"https://openalex.org/S4210186093","display_name":"E3S Web of Conferences","issn_l":"2267-1242","issn":["2267-1242","2555-0403"],"is_oa":true,"is_in_doaj":true,"is_core":false,"listed_in":["ddh","doaj","jufo-1","norway-1"],"host_organization":"https://openalex.org/P4310319748","host_organization_name":"EDP Sciences","host_organization_lineage":["https://openalex.org/P4310319748","https://openalex.org/P4310319982"],"host_organization_lineage_names":["EDP Sciences","Science Press"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"E3S Web of Conferences","raw_type":"journal-article"},"volume":null,"type":"conference-paper","is_traditional":true,"indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://www.e3s-conferences.org/articles/e3sconf/pdf/2024/04/e3sconf_icite2023_02029.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5073498791","display_name":"Alexey Leonidovich Tkachenko","orcid":"https://orcid.org/0000-0003-4276-3017","observed_orcids":["https://orcid.org/0000-0003-4276-3017"]},"institutions":[{"id":"https://openalex.org/I51094848","display_name":"Kaluga State University named after K.E.Tsiolkovski","ror":"https://ror.org/04rdgrr80","country_code":"RU","type":"education","lineage":["https://openalex.org/I51094848"]}],"countries":["RU"],"is_corresponding":true,"raw_author_name":"Alexey Tkachenko","raw_affiliation_strings":["Kaluga State University n.a. K.E. Tsiolkovski, 248023 Kaluga, Russia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Kaluga State University n.a. K.E. Tsiolkovski, 248023 Kaluga, Russia","institution_ids":["https://openalex.org/I51094848"]}]},{"author_position":"last","author":{"id":null,"display_name":"Mikhail Chernyshov","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I51094848","display_name":"Kaluga State University named after K.E.Tsiolkovski","ror":"https://ror.org/04rdgrr80","country_code":"RU","type":"education","lineage":["https://openalex.org/I51094848"]}],"countries":["RU"],"is_corresponding":false,"raw_author_name":"Mikhail Chernyshov","raw_affiliation_strings":["Kaluga State University n.a. K.E. Tsiolkovski, 248023 Kaluga, Russia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Kaluga State University n.a. K.E. Tsiolkovski, 248023 Kaluga, Russia","institution_ids":["https://openalex.org/I51094848"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5073498791"],"corresponding_institution_ids":["https://openalex.org/I51094848"],"apc_list":null,"apc_paid":null,"fwci":1.4742,"has_fulltext":true,"cited_by_count":3,"citation_normalized_percentile":{"value":0.79830953,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":95},"biblio":{"volume":"474","issue":null,"first_page":"02029","last_page":"02029"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.8438000082969666,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.8438000082969666,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11938","display_name":"ERP Systems Implementation and Impact","score":0.12389999628067017,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11734","display_name":"Decision Support System Applications","score":0.006300000008195639,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/power-query","display_name":"Power Query","score":0.9879999756813049},{"id":"https://openalex.org/keywords/sap-erp","display_name":"SAP ERP","score":0.9909999966621399},{"id":"https://openalex.org/keywords/data-mining","display_name":"data mining","score":0.7710000276565552},{"id":"https://openalex.org/keywords/data-processing","display_name":"data processing","score":0.7559999823570251},{"id":"https://openalex.org/keywords/financial-data-analysis","display_name":"financial data analysis","score":0.9440000057220459},{"id":"https://openalex.org/keywords/data-transformation","display_name":"data transformation","score":0.8080000281333923},{"id":"https://openalex.org/keywords/real-time-financial-data","display_name":"real-time financial data","score":0.6679999828338623},{"id":"https://openalex.org/keywords/decision-support","display_name":"decision support","score":0.6140000224113464}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7902220487594604},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.7084907293319702},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6317514181137085},{"id":"https://openalex.org/C43214815","wikidata":"https://www.wikidata.org/wiki/Q7310987","display_name":"Reliability (semiconductor)","level":3,"score":0.5685823559761047},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5408198833465576},{"id":"https://openalex.org/C138827492","wikidata":"https://www.wikidata.org/wiki/Q6661985","display_name":"Data processing","level":2,"score":0.5070643424987793},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.4979712963104248},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.4741591513156891},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4504099190235138},{"id":"https://openalex.org/C85345410","wikidata":"https://www.wikidata.org/wiki/Q851587","display_name":"Business process","level":3,"score":0.4467516243457794},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4157086908817291},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.4079528748989105},{"id":"https://openalex.org/C163258240","wikidata":"https://www.wikidata.org/wiki/Q25342","display_name":"Power (physics)","level":2,"score":0.3735363483428955},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.27143874764442444},{"id":"https://openalex.org/C174998907","wikidata":"https://www.wikidata.org/wiki/Q357662","display_name":"Work in process","level":2,"score":0.24092978239059448},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.11449047923088074},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C162853370","wikidata":"https://www.wikidata.org/wiki/Q39809","display_name":"Marketing","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1051/e3sconf/202447402029","doi":"https://doi.org/10.1051/e3sconf/202447402029","is_oa":true,"landing_page_url":"https://doi.org/10.1051/e3sconf/202447402029","pdf_url":"https://www.e3s-conferences.org/articles/e3sconf/pdf/2024/04/e3sconf_icite2023_02029.pdf","source":{"id":"https://openalex.org/S4210186093","display_name":"E3S Web of Conferences","issn_l":"2267-1242","issn":["2267-1242","2555-0403"],"is_oa":true,"is_in_doaj":true,"is_core":false,"listed_in":["ddh","doaj","jufo-1","norway-1"],"host_organization":"https://openalex.org/P4310319748","host_organization_name":"EDP Sciences","host_organization_lineage":["https://openalex.org/P4310319748","https://openalex.org/P4310319982"],"host_organization_lineage_names":["EDP Sciences","Science Press"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"E3S Web of Conferences","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:25d2bd02b289400aadfc57839a61b8b1","doi":null,"is_oa":true,"landing_page_url":"https://doaj.org/article/25d2bd02b289400aadfc57839a61b8b1","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"E3S Web of Conferences, Vol 474, p 02029 (2024)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.1051/e3sconf/202447402029","doi":"https://doi.org/10.1051/e3sconf/202447402029","is_oa":true,"landing_page_url":"https://doi.org/10.1051/e3sconf/202447402029","pdf_url":"https://www.e3s-conferences.org/articles/e3sconf/pdf/2024/04/e3sconf_icite2023_02029.pdf","source":{"id":"https://openalex.org/S4210186093","display_name":"E3S Web of Conferences","issn_l":"2267-1242","issn":["2267-1242","2555-0403"],"is_oa":true,"is_in_doaj":true,"is_core":false,"listed_in":["ddh","doaj","jufo-1","norway-1"],"host_organization":"https://openalex.org/P4310319748","host_organization_name":"EDP Sciences","host_organization_lineage":["https://openalex.org/P4310319748","https://openalex.org/P4310319982"],"host_organization_lineage_names":["EDP Sciences","Science Press"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"E3S Web of Conferences","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4390664220.pdf","grobid_xml":"https://content.openalex.org/works/W4390664220.grobid-xml"},"referenced_works_count":13,"referenced_works":["https://openalex.org/W1519156405","https://openalex.org/W1601244756","https://openalex.org/W1972424157","https://openalex.org/W2021805180","https://openalex.org/W2024187266","https://openalex.org/W2037262697","https://openalex.org/W2072177008","https://openalex.org/W2920897944","https://openalex.org/W3021262422","https://openalex.org/W3115166468","https://openalex.org/W3168213624","https://openalex.org/W4285221676","https://openalex.org/W4292266824"],"related_works":["https://openalex.org/W2030030962","https://openalex.org/W2978210378","https://openalex.org/W2520895807","https://openalex.org/W2234633083","https://openalex.org/W2150614413","https://openalex.org/W2528540228","https://openalex.org/W4407848655","https://openalex.org/W2626221584","https://openalex.org/W7093378620","https://openalex.org/W4311555202"],"abstract_inverted_index":{"The":[0,42],"article":[1,43],"discusses":[2],"the":[3,28,36,48,66,72,88,145,193,198],"use":[4],"of":[5,40,47,51,74,147,159,195,202],"an":[6,45],"intelligent":[7],"Power":[8,23,52,76,99,113,148,177,207],"Query":[9,24,53,100,149,178,208],"system":[10],"for":[11,60,213],"processing":[12,62,82,96,117,190],"data":[13,29,61,81,85,95,116,127,161,189],"from":[14],"SAP":[15,20,67,108,151],"ERP.":[16],"When":[17],"used":[18,59],"with":[19,65,150,155],"ERP":[21,68,109,152],"data,":[22],"can":[25,57,183],"greatly":[26],"simplify":[27],"analysis":[30,219],"process,":[31],"as":[32,34],"well":[33],"improve":[35,137],"accuracy":[37,199],"and":[38,54,87,93,103,118,129,139,172,191,200,221],"reliability":[39,201],"results.":[41],"provides":[44,110,153],"overview":[46],"main":[49],"features":[50],"how":[55],"they":[56],"be":[58],"in":[63,162],"conjunction":[64],"system.":[69],"It":[70],"highlights":[71],"benefits":[73],"using":[75],"Query,":[77],"including":[78],"speeding":[79],"up":[80],"time,":[83,164],"improving":[84],"accuracy,":[86],"ability":[89],"to":[90,101,123,134,168,179,216],"easily":[91],"exchange":[92],"reuse":[94],"procedures.":[97],"Using":[98,176],"process":[102],"analyze":[104,124,180],"bank":[105,181],"statements":[106,182],"via":[107],"many":[111],"advantages.":[112],"Query's":[114],"powerful":[115,211],"transformation":[119],"capabilities":[120],"enable":[121],"organizations":[122,154,186,214],"their":[125,174],"financial":[126,160,203,218],"quickly":[128],"accurately,":[130],"making":[131],"it":[132],"easier":[133],"identify":[135],"trends,":[136],"decision-making":[138],"stimulate":[140],"business":[141,223],"growth.":[142],"In":[143,205],"addition,":[144],"integration":[146],"a":[156,210],"centralized":[157],"representation":[158],"real":[163],"which":[165],"allows":[166],"them":[167],"make":[169],"informed":[170],"decisions":[171],"optimize":[173,217],"activities.":[175],"also":[184],"help":[185],"reduce":[187],"manual":[188],"minimize":[192],"risk":[194],"errors,":[196],"increasing":[197],"information.":[204],"general,":[206],"offers":[209],"solution":[212],"seeking":[215],"processes":[220],"ensure":[222],"success.":[224]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":1}],"updated_date":"2026-09-29T14:09:16.559479","created_date":"2024-01-13T00:00:00"}