{"id":"https://openalex.org/W7147090715","doi":"https://doi.org/10.18524/2413-9998.2025.3(61).350376","title":"IMPLEMENTATION OF AUTOMATIC SELECTION OF ASSORTMENT MATRIX FOR CATEGORY ANALYSIS IN POWER BI","display_name":"IMPLEMENTATION OF AUTOMATIC SELECTION OF ASSORTMENT MATRIX FOR CATEGORY ANALYSIS IN POWER BI","publication_year":2025,"publication_date":"2025-12-25","ids":{"openalex":"https://openalex.org/W7147090715","doi":"https://doi.org/10.18524/2413-9998.2025.3(61).350376"},"language":"en","primary_location":{"id":"doi:10.18524/2413-9998.2025.3(61).350376","doi":"https://doi.org/10.18524/2413-9998.2025.3(61).350376","is_oa":true,"landing_page_url":"https://doi.org/10.18524/2413-9998.2025.3(61).350376","pdf_url":"https://rinek.onu.edu.ua/article/download/350376/342026","source":{"id":"https://openalex.org/S4210214394","display_name":"Market economy modern management theory and practice","issn_l":"2413-9998","issn":["2413-9998"],"is_oa":true,"is_in_doaj":true,"is_core":false,"listed_in":["doaj"],"host_organization":"https://openalex.org/P4310321835","host_organization_name":"Odesa University","host_organization_lineage":["https://openalex.org/P4310321835"],"host_organization_lineage_names":["Odesa University"],"type":"journal"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Market economy: modern management theory and practice","raw_type":"journal-article"},"volume":null,"type":"article","is_traditional":true,"indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://rinek.onu.edu.ua/article/download/350376/342026","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5083158692","display_name":"\u041c\u0430\u0440\u0438\u043d\u0430 \u041f\u0435\u0442\u0440\u0456\u0432\u043d\u0430 \u0427\u0430\u0439\u043a\u043e\u0432\u0441\u044c\u043a\u0430","orcid":"https://orcid.org/0000-0002-9490-5112","observed_orcids":["https://orcid.org/0000-0002-9490-5112"]},"institutions":[{"id":"https://openalex.org/I181840440","display_name":"Odesa I. I. Mechnikov National University","ror":"https://ror.org/03b6cpn03","country_code":"UA","type":"education","lineage":["https://openalex.org/I181840440"]}],"countries":["UA"],"is_corresponding":false,"raw_author_name":"M. P. Chaikovska","raw_affiliation_strings":["Mechnikov National University 24/26 Frantsuzkyi Blvd. , Odesa , 65058 , Ukraine"],"raw_orcid":"https://orcid.org/0000-0002-9490-5112","affiliations":[{"raw_affiliation_string":"Mechnikov National University 24/26 Frantsuzkyi Blvd. , Odesa , 65058 , Ukraine","institution_ids":["https://openalex.org/I181840440"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5020761482","display_name":"V. M. Stoyanov","orcid":"https://orcid.org/0009-0006-1884-4457","observed_orcids":["https://orcid.org/0009-0006-1884-4457"]},"institutions":[{"id":"https://openalex.org/I181840440","display_name":"Odesa I. I. Mechnikov National University","ror":"https://ror.org/03b6cpn03","country_code":"UA","type":"education","lineage":["https://openalex.org/I181840440"]}],"countries":["UA"],"is_corresponding":false,"raw_author_name":"V. M. Stoianov","raw_affiliation_strings":["Mechnikov National University 24/26 Frantsuzkyi Blvd. , Odesa , 65058 , Ukraine"],"raw_orcid":"https://orcid.org/0009-0006-1884-4457","affiliations":[{"raw_affiliation_string":"Mechnikov National University 24/26 Frantsuzkyi Blvd. , Odesa , 65058 , Ukraine","institution_ids":["https://openalex.org/I181840440"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I181840440"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"24","issue":"3(61)","first_page":"160","last_page":"171"},"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.8931000232696533,"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.8931000232696533,"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/T10328","display_name":"Supply Chain and Inventory Management","score":0.07460000365972519,"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"}},{"id":"https://openalex.org/T11161","display_name":"Consumer Market Behavior and Pricing","score":0.023000000044703484,"subfield":{"id":"https://openalex.org/subfields/1406","display_name":"Marketing"},"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/assortment-planning","display_name":"assortment planning","score":0.7699999809265137},{"id":"https://openalex.org/keywords/category-management","display_name":"category management","score":0.7940000295639038},{"id":"https://openalex.org/keywords/power-bi","display_name":"Power BI","score":0.6570000052452087},{"id":"https://openalex.org/keywords/dax","display_name":"DAX","score":0.7839999794960022},{"id":"https://openalex.org/keywords/product-ranking","display_name":"product ranking","score":0.6970000267028809},{"id":"https://openalex.org/keywords/data-driven-decision-making","display_name":"data-driven decision making","score":0.6779999732971191},{"id":"https://openalex.org/keywords/store-profitability","display_name":"store profitability","score":0.453000009059906},{"id":"https://openalex.org/keywords/retail-analytics","display_name":"retail analytics","score":0.48899999260902405},{"id":"https://openalex.org/keywords/dashboards","display_name":"dashboards","score":0.550000011920929},{"id":"https://openalex.org/keywords/optimization-model","display_name":"optimization model","score":0.47999998927116394}],"concepts":[{"id":"https://openalex.org/C5274069","wikidata":"https://www.wikidata.org/wiki/Q2285707","display_name":"Categorical variable","level":2,"score":0.7171000242233276},{"id":"https://openalex.org/C189430467","wikidata":"https://www.wikidata.org/wiki/Q7293293","display_name":"Ranking (information retrieval)","level":2,"score":0.6963000297546387},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6870999932289124},{"id":"https://openalex.org/C2780009758","wikidata":"https://www.wikidata.org/wiki/Q6804172","display_name":"Measure (data warehouse)","level":2,"score":0.5683000087738037},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5566999912261963},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.5291000008583069},{"id":"https://openalex.org/C90673727","wikidata":"https://www.wikidata.org/wiki/Q901718","display_name":"Product (mathematics)","level":2,"score":0.5031999945640564},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.48840001225471497},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.42489999532699585},{"id":"https://openalex.org/C163258240","wikidata":"https://www.wikidata.org/wiki/Q25342","display_name":"Power (physics)","level":2,"score":0.41260001063346863},{"id":"https://openalex.org/C42475967","wikidata":"https://www.wikidata.org/wiki/Q194292","display_name":"Operations research","level":1,"score":0.39559999108314514},{"id":"https://openalex.org/C2778348673","wikidata":"https://www.wikidata.org/wiki/Q739302","display_name":"Production (economics)","level":2,"score":0.39250001311302185},{"id":"https://openalex.org/C2778572836","wikidata":"https://www.wikidata.org/wiki/Q380933","display_name":"Space (punctuation)","level":2,"score":0.3889999985694885},{"id":"https://openalex.org/C106487976","wikidata":"https://www.wikidata.org/wiki/Q685816","display_name":"Matrix (chemical analysis)","level":2,"score":0.3695000112056732},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.34709998965263367},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.29010000824928284},{"id":"https://openalex.org/C147101817","wikidata":"https://www.wikidata.org/wiki/Q13443840","display_name":"Product category","level":3,"score":0.26829999685287476},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.26260000467300415},{"id":"https://openalex.org/C148483581","wikidata":"https://www.wikidata.org/wiki/Q446488","display_name":"Feature selection","level":2,"score":0.26190000772476196},{"id":"https://openalex.org/C107327155","wikidata":"https://www.wikidata.org/wiki/Q330268","display_name":"Decision support system","level":2,"score":0.2551000118255615},{"id":"https://openalex.org/C137402852","wikidata":"https://www.wikidata.org/wiki/Q5249239","display_name":"Decision matrix","level":2,"score":0.25270000100135803}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.18524/2413-9998.2025.3(61).350376","doi":"https://doi.org/10.18524/2413-9998.2025.3(61).350376","is_oa":true,"landing_page_url":"https://doi.org/10.18524/2413-9998.2025.3(61).350376","pdf_url":"https://rinek.onu.edu.ua/article/download/350376/342026","source":{"id":"https://openalex.org/S4210214394","display_name":"Market economy modern management theory and practice","issn_l":"2413-9998","issn":["2413-9998"],"is_oa":true,"is_in_doaj":true,"is_core":false,"listed_in":["doaj"],"host_organization":"https://openalex.org/P4310321835","host_organization_name":"Odesa University","host_organization_lineage":["https://openalex.org/P4310321835"],"host_organization_lineage_names":["Odesa University"],"type":"journal"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Market economy: modern management theory and practice","raw_type":"journal-article"},{"id":"pmh:oai:dspace.onu.edu.ua:123456789/44561","doi":null,"is_oa":false,"landing_page_url":"https://dspace.onu.edu.ua/handle/123456789/44561","pdf_url":null,"source":{"id":"https://openalex.org/S4377196575","display_name":"INSTITUTIONAL REPOSITORY OF ODESSA NATIONAL UNIVERSITY NAMED I.I. Mechnykova (Odesa I.I.Mechnikov National University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I181840440","host_organization_name":"Odesa I. I. Mechnikov National University","host_organization_lineage":["https://openalex.org/I181840440"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Article"},{"id":"pmh:oai:ojs.journals.uran.ua:article/350376","doi":null,"is_oa":true,"landing_page_url":"https://rinek.onu.edu.ua/article/view/350376","pdf_url":null,"source":{"id":"https://openalex.org/S4377196123","display_name":"Scientific periodicals of Ukraine","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-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"2413-9998","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"doi:10.18524/2413-9998.2025.3(61).350376","doi":"https://doi.org/10.18524/2413-9998.2025.3(61).350376","is_oa":true,"landing_page_url":"https://doi.org/10.18524/2413-9998.2025.3(61).350376","pdf_url":"https://rinek.onu.edu.ua/article/download/350376/342026","source":{"id":"https://openalex.org/S4210214394","display_name":"Market economy modern management theory and practice","issn_l":"2413-9998","issn":["2413-9998"],"is_oa":true,"is_in_doaj":true,"is_core":false,"listed_in":["doaj"],"host_organization":"https://openalex.org/P4310321835","host_organization_name":"Odesa University","host_organization_lineage":["https://openalex.org/P4310321835"],"host_organization_lineage_names":["Odesa University"],"type":"journal"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Market economy: modern management theory and practice","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W7147090715.pdf","grobid_xml":"https://content.openalex.org/works/W7147090715.grobid-xml"},"referenced_works_count":9,"referenced_works":["https://openalex.org/W2972545401","https://openalex.org/W3121233777","https://openalex.org/W3121891820","https://openalex.org/W4394856673","https://openalex.org/W4404569649","https://openalex.org/W4405679350","https://openalex.org/W4408161279","https://openalex.org/W4411175994","https://openalex.org/W4416594192"],"related_works":["https://openalex.org/W2162924706","https://openalex.org/W2048111145","https://openalex.org/W2033919760","https://openalex.org/W2801938735","https://openalex.org/W1865223047","https://openalex.org/W7100071098","https://openalex.org/W4415963917","https://openalex.org/W7098023540","https://openalex.org/W420156162","https://openalex.org/W2499314255"],"abstract_inverted_index":{"The":[0,59,94,137,169,253,286,341,379],"article":[1,219],"presents":[2],"a":[3,9,14,268,318,350,375,424],"methodology":[4],"for":[5,24,135,184,193,260,271,292,297,321,427],"the":[6,19,36,45,62,66,70,72,75,80,98,104,114,145,205,218,221,383,393],"formation":[7],"of":[8,21,48,65,69,77,100,223,353,364,385],"multicategory":[10],"assortment":[11,22,92,120,206,298,324,354,398],"matrix":[12],"and":[13,35,55,79,111,118,152,180,211,228,238,245,273,283,309,329,346,356,367,389,403,431,439,445],"comprehensive":[15],"approach":[16,254],"to":[17,43,89,240,249,411],"automating":[18],"selection":[20],"matrices":[23],"retail":[25,339,377,429],"outlets":[26],"with":[27,196,214,264],"limited":[28,276],"shelf":[29,116,277],"space.":[30],"Using":[31],"Power":[32,172,313,443],"BI":[33,173,314,444],"tools":[34,296],"DAX":[37,81,86,311,365],"language,":[38],"an":[39,127,176,257],"algorithm":[40],"was":[41],"developed":[42],"identify":[44],"optimal":[46],"set":[47],"SKUs":[49,165,407],"considering":[50,148],"product":[51],"ranking,":[52,386],"category":[53,112,150,189,334,387,432],"structure,":[54,388],"client":[56],"space":[57,390],"constraints.":[58,93],"study":[60,170,342],"details":[61],"implementation":[63,441],"logic":[64,395],"strategic":[67,212],"vision":[68],"company,":[71],"mathematical":[73,302,435],"model,":[74],"construction":[76],"tables,":[78],"calculations,":[82],"including":[83,191],"two":[84],"key":[85],"measures":[87],"designed":[88],"apply":[90],"different":[91,338],"first":[95],"measure":[96,139],"evaluates":[97],"status":[99,143],"each":[101],"SKU":[102,142],"within":[103],"category,":[105],"taking":[106,349],"into":[107,231,307,392],"account":[108],"its":[109],"ranking":[110,226],"limit,":[113],"available":[115,410],"space,":[117],"actual":[119],"allocation,":[121],"thereby":[122],"providing":[123,362],"decisions":[124],"on":[125],"whether":[126],"item":[128],"should":[129],"be":[130,305,372],"included,":[131],"excluded,":[132],"or":[133,163,202,415],"marked":[134],"review.":[136],"second":[138],"assesses":[140],"overall":[141],"at":[144],"store":[146,284],"level,":[147],"aggregated":[149],"values":[151],"adjusted":[153],"limits,":[154],"ensuring":[155,208],"that":[156,370,382,405],"high-priority":[157],"items":[158,195],"are":[159,166,408,418],"retained":[160],"while":[161,279,413],"low-priority":[162],"restricted-status":[164],"not":[167],"proposed.":[168],"illustrates":[171],"capabilities":[174],"as":[175,200,317],"optimization":[177],"analytics":[178,430],"platform":[179,320],"demonstrates":[181],"practical":[182,269,440],"aspects":[183],"implementing":[185,322],"data-driven":[186,295,437],"decision-making":[187],"in":[188,333,374],"management,":[190,433],"rules":[192],"excluding":[194],"special":[197],"statuses,":[198],"such":[199],"NPI":[201],"DEL,":[203],"from":[204],"matrix,":[207],"both":[209,344],"efficiency":[210,332],"alignment":[213],"company":[215],"goals.":[216],"Furthermore,":[217],"highlights":[220],"integration":[222,384],"demand":[224],"data,":[225],"logic,":[227],"categorical":[229],"constraints":[230,391],"simple,":[232],"but":[233],"effective":[234],"dashboards,":[235],"enabling":[236],"managers":[237],"analysts":[239],"proactively":[241],"monitor":[242],"decision":[243,327,394],"outcomes":[244],"adjust":[246],"assortments":[247],"according":[248],"dynamic":[250],"market":[251],"conditions.":[252],"proposed":[255],"provides":[256,423],"innovative":[258],"model":[259,368],"balancing":[261],"economic":[262],"performance":[263],"operational":[265],"constraints,":[266],"offering":[267],"framework":[270,426],"retailers":[272],"distributors":[274],"facing":[275],"capacity":[278],"maximizing":[280],"customer":[281],"choice":[282],"profitability.":[285],"paper":[287],"also":[288],"considers":[289],"methodological":[290],"implications":[291],"designing":[293],"adaptive":[294],"optimization,":[299],"illustrating":[300],"how":[301],"formulations":[303],"can":[304,371,396],"translated":[306],"intuitive":[308],"actionable":[310],"metrics.":[312],"thus":[315],"serves":[316],"powerful":[319],"automated":[323],"strategies,":[325],"enhancing":[326],"quality,":[328],"increasing":[330],"managerial":[331,401],"management":[335],"applications":[336],"across":[337],"contexts.":[340],"contributes":[343],"practically":[345],"theoretically":[347],"by":[348],"classic":[351],"problem":[352],"planning":[355],"addressing":[357],"it":[358],"through":[359,442],"systematic":[360],"automation,":[361],"examples":[363],"calculations":[366],"structure":[369],"replicated":[373],"multi-category":[376],"environment.":[378],"findings":[380],"demonstrate":[381],"improve":[397],"effectiveness,":[399],"reduce":[400],"workload,":[402],"ensure":[404],"priority":[406],"made":[409],"shoppers":[412],"restricted":[414],"low-performing":[416],"products":[417],"appropriately":[419],"managed.":[420],"This":[421],"research":[422],"novel":[425],"applied":[428],"bridging":[434],"modeling,":[436],"decision-making,":[438],"DAX-based":[446],"tools.":[447]},"counts_by_year":[],"updated_date":"2026-11-06T12:05:46.655746","created_date":"2026-04-02T00:00:00"}