{"id":"https://openalex.org/W2603246155","doi":"https://doi.org/10.1109/sami.2017.7880359","title":"Advanced analysis of manufacturing data in Excel and its Add-ins","display_name":"Advanced analysis of manufacturing data in Excel and its Add-ins","publication_year":2017,"publication_date":"2017-01-01","ids":{"openalex":"https://openalex.org/W2603246155","doi":"https://doi.org/10.1109/sami.2017.7880359","mag":"2603246155"},"language":"en","primary_location":{"id":"doi:10.1109/sami.2017.7880359","doi":"https://doi.org/10.1109/sami.2017.7880359","is_oa":false,"landing_page_url":"https://doi.org/10.1109/sami.2017.7880359","pdf_url":null,"source":{"id":"https://openalex.org/S7407086137","display_name":"IEEE World Symposium on Applied Machine Intelligence and Informatics (SAMI)","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":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2017 IEEE 15th International Symposium on Applied Machine Intelligence and Informatics (SAMI)","raw_type":"proceedings-article"},"volume":null,"type":"conference-paper","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5021749036","display_name":"Erik Kaj\u00e1ti","orcid":"https://orcid.org/0000-0002-4182-6162","observed_orcids":["https://orcid.org/0000-0002-4182-6162"]},"institutions":[{"id":"https://openalex.org/I183764125","display_name":"Technical University of Ko\u0161ice","ror":"https://ror.org/05xm08015","country_code":"SK","type":"education","lineage":["https://openalex.org/I183764125"]}],"countries":["SK"],"is_corresponding":false,"raw_author_name":"Erik Kajati","raw_affiliation_strings":["Department of Cybernetics and Artificial Intelligence, Technical University of Kosice, Slovak Republic"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Cybernetics and Artificial Intelligence, Technical University of Kosice, Slovak Republic","institution_ids":["https://openalex.org/I183764125"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5023473584","display_name":"Martin Mi\u0161kuf","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I183764125","display_name":"Technical University of Ko\u0161ice","ror":"https://ror.org/05xm08015","country_code":"SK","type":"education","lineage":["https://openalex.org/I183764125"]}],"countries":["SK"],"is_corresponding":false,"raw_author_name":"Martin Miskuf","raw_affiliation_strings":["Department of Cybernetics and Artificial Intelligence, Technical University of Kosice, Slovak Republic"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Cybernetics and Artificial Intelligence, Technical University of Kosice, Slovak Republic","institution_ids":["https://openalex.org/I183764125"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5088770281","display_name":"Peter Papcun","orcid":"https://orcid.org/0000-0002-3937-286X","observed_orcids":["https://orcid.org/0000-0002-3937-286X"]},"institutions":[{"id":"https://openalex.org/I183764125","display_name":"Technical University of Ko\u0161ice","ror":"https://ror.org/05xm08015","country_code":"SK","type":"education","lineage":["https://openalex.org/I183764125"]}],"countries":["SK"],"is_corresponding":false,"raw_author_name":"Peter Papcun","raw_affiliation_strings":["Department of Cybernetics and Artificial Intelligence, Technical University of Kosice, Slovak Republic"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Cybernetics and Artificial Intelligence, Technical University of Kosice, Slovak Republic","institution_ids":["https://openalex.org/I183764125"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I183764125"],"apc_list":null,"apc_paid":null,"fwci":1.8555,"has_fulltext":false,"cited_by_count":13,"citation_normalized_percentile":{"value":0.82220753,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"000491","last_page":"000496"},"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.9994999766349792,"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.9994999766349792,"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/T13204","display_name":"Competitive and Knowledge Intelligence","score":0.0,"subfield":{"id":"https://openalex.org/subfields/1408","display_name":"Strategy and Management"},"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/T14260","display_name":"Impact of AI and Big Data on Business and Society","score":0.0,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/business-intelligence","display_name":"business intelligence","score":0.8640000224113464},{"id":"https://openalex.org/keywords/microsoft-excel","display_name":"Microsoft Excel","score":0.8050000071525574},{"id":"https://openalex.org/keywords/microsoft-excel-add-in","display_name":"Excel add-in","score":0.9750000238418579},{"id":"https://openalex.org/keywords/power-query","display_name":"Power Query","score":0.9279999732971191},{"id":"https://openalex.org/keywords/power-pivot","display_name":"Power Pivot","score":0.9990000128746033},{"id":"https://openalex.org/keywords/power-view","display_name":"power view","score":0.921999990940094},{"id":"https://openalex.org/keywords/power-maps","display_name":"power maps","score":0.972000002861023},{"id":"https://openalex.org/keywords/power-bi","display_name":"Power BI","score":0.9959999918937683},{"id":"https://openalex.org/keywords/management-information-systems","display_name":"management information systems","score":0.7910000085830688},{"id":"https://openalex.org/keywords/steelmaking","display_name":"steel industry","score":0.5419999957084656},{"id":"https://openalex.org/keywords/manufacturing-data-analysis","display_name":"manufacturing data analysis","score":0.7990000247955322}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6510351300239563},{"id":"https://openalex.org/C117671659","wikidata":"https://www.wikidata.org/wiki/Q11049265","display_name":"Manufacturing engineering","level":1,"score":0.33421841263771057},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.1689656376838684}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/sami.2017.7880359","doi":"https://doi.org/10.1109/sami.2017.7880359","is_oa":false,"landing_page_url":"https://doi.org/10.1109/sami.2017.7880359","pdf_url":null,"source":{"id":"https://openalex.org/S7407086137","display_name":"IEEE World Symposium on Applied Machine Intelligence and Informatics (SAMI)","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":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2017 IEEE 15th International Symposium on Applied Machine Intelligence and Informatics (SAMI)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure","score":0.5378999710083008}],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":14,"referenced_works":["https://openalex.org/W619313412","https://openalex.org/W1918287679","https://openalex.org/W2029608738","https://openalex.org/W2082004061","https://openalex.org/W2224060837","https://openalex.org/W2263203959","https://openalex.org/W2296300849","https://openalex.org/W2310754551","https://openalex.org/W2310874860","https://openalex.org/W2462666973","https://openalex.org/W2522550505","https://openalex.org/W6619533229","https://openalex.org/W6639947604","https://openalex.org/W6693109448"],"related_works":["https://openalex.org/W2087217377","https://openalex.org/W6922780666","https://openalex.org/W2257908967","https://openalex.org/W7045994351","https://openalex.org/W1684298244","https://openalex.org/W7141540851","https://openalex.org/W7160637509","https://openalex.org/W4416059886","https://openalex.org/W6979760501","https://openalex.org/W7070621777"],"abstract_inverted_index":{"This":[0],"article":[1],"focuses":[2],"on":[3,104],"the":[4,13,39,98,105],"business":[5,94],"analytics":[6],"and":[7,17,31,54,78,89,102],"data":[8,37,107],"analysis":[9],"by":[10,67],"application":[11],"of":[12,19],"advanced":[14,93],"tools,":[15],"technologies":[16],"methods":[18],"Business":[20],"Intelligence":[21],"(BI).":[22],"These":[23],"tools":[24],"enable":[25],"companies":[26],"to":[27,62,75,118],"gain":[28],"competitive":[29],"advantage":[30],"improve":[32],"their":[33],"processes.":[34],"We":[35],"had":[36],"from":[38],"biggest":[40],"steel":[41],"factory":[42],"in":[43,64],"Slovakia.":[44],"In":[45,70],"papers":[46],"[1],":[47],"[2]":[48],"we":[49,73],"worked":[50],"with":[51,97],"BI":[52,91],"solutions":[53],"there":[55],"was":[56],"request":[57],"that":[58],"all":[59],"reports":[60],"have":[61],"be":[63],"formats":[65],"supported":[66],"Microsoft":[68],"Excel.":[69],"this":[71],"paper,":[72],"decided":[74],"use":[76],"Excel":[77,100],"Add-ins":[79,101],"like":[80],"Power":[81,83,85,87,90],"Query,":[82],"Pivot,":[84],"View,":[86],"Map,":[88],"for":[92],"analysis.":[95],"Sequentially":[96],"selected":[99],"based":[103],"available":[106],"a":[108],"complete":[109],"management":[110],"information":[111],"system":[112],"has":[113],"been":[114],"created,":[115],"capable":[116],"respond":[117],"various":[119],"queries.":[120]},"counts_by_year":[{"year":2025,"cited_by_count":5},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":2}],"updated_date":"2026-11-07T11:25:07.637180","created_date":"2017-04-07T00:00:00"}