{"id":"https://openalex.org/W7224645883","doi":"https://doi.org/10.46880/methosisfo.v6i2.6518","title":"PERANCANGAN DATA WAREHOUSE PENJUALAN BERBASIS STAR SCHEMA UNTUK MENDUKUNG PERAMALAN PENJUALAN MENGGUNAKAN METODE ARIMA PADA WARKOP BARIS","display_name":"PERANCANGAN DATA WAREHOUSE PENJUALAN BERBASIS STAR SCHEMA UNTUK MENDUKUNG PERAMALAN PENJUALAN MENGGUNAKAN METODE ARIMA PADA WARKOP BARIS","publication_year":2026,"publication_date":"2026-10-20","ids":{"openalex":"https://openalex.org/W7224645883","doi":"https://doi.org/10.46880/methosisfo.v6i2.6518"},"language":"id","primary_location":{"id":"pmh:oai:ojs.ejurnal.methodist.ac.id:article/6518","doi":"https://doi.org/10.46880/methosisfo.v6i2.6518","is_oa":true,"landing_page_url":"https://ejurnal.methodist.ac.id/index.php/methosisfo/article/view/6518","pdf_url":"https://ejurnal.methodist.ac.id/index.php/methosisfo/article/download/6518/3296","source":{"id":"https://openalex.org/S7407075959","display_name":"METHOSISFO : Jurnal Ilmiah Sistem Informasi","issn_l":"2776-575X","issn":["2776-575X"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I3132896252","host_organization_name":"Universitas Methodist Indonesia","host_organization_lineage":["https://openalex.org/I3132896252"],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"10.46880/methosisfo.v6i2","raw_type":"info:eu-repo/semantics/article"},"volume":null,"type":"article","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://ejurnal.methodist.ac.id/index.php/methosisfo/article/download/6518/3296","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5160086755","display_name":"Dedi Royen","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I3132896252","display_name":"Universitas Methodist Indonesia","ror":"https://ror.org/01a6gjq30","country_code":"ID","type":"education","lineage":["https://openalex.org/I3132896252"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Royen, Dedi","raw_affiliation_strings":["Universitas Methodist Indonesia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universitas Methodist Indonesia","institution_ids":["https://openalex.org/I3132896252"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5021298741","display_name":"Edward Rajagukguk","orcid":"https://orcid.org/0000-0002-7505-6055","observed_orcids":["https://orcid.org/0000-0002-7505-6055"]},"institutions":[{"id":"https://openalex.org/I3132896252","display_name":"Universitas Methodist Indonesia","ror":"https://ror.org/01a6gjq30","country_code":"ID","type":"education","lineage":["https://openalex.org/I3132896252"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Rajagukguk, Edward","raw_affiliation_strings":["Universitas Methodist Indonesia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universitas Methodist Indonesia","institution_ids":["https://openalex.org/I3132896252"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5092591589","display_name":"Tamado Simon Sagala","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I3132896252","display_name":"Universitas Methodist Indonesia","ror":"https://ror.org/01a6gjq30","country_code":"ID","type":"education","lineage":["https://openalex.org/I3132896252"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Sagala, Tamado Simon","raw_affiliation_strings":["Universitas Methodist Indonesia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universitas Methodist Indonesia","institution_ids":["https://openalex.org/I3132896252"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I3132896252"],"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":null,"issue":null,"first_page":null,"last_page":null},"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.9702000021934509,"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.9702000021934509,"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/T11918","display_name":"Forecasting Techniques and Applications","score":0.01860000006854534,"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/T13373","display_name":"Data Mining and Machine Learning Applications","score":0.007400000002235174,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/star-schema","display_name":"star schema","score":0.9829999804496765},{"id":"https://openalex.org/keywords/sales-forecasting","display_name":"sales forecasting","score":0.9300000071525574},{"id":"https://openalex.org/keywords/arima","display_name":"ARIMA","score":0.972000002861023},{"id":"https://openalex.org/keywords/etl","display_name":"ETL","score":0.6890000104904175},{"id":"https://openalex.org/keywords/food-and-beverage-industry","display_name":"food and beverage industry","score":0.8799999952316284}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.4036000072956085},{"id":"https://openalex.org/C15708023","wikidata":"https://www.wikidata.org/wiki/Q80083","display_name":"Humanities","level":1,"score":0.36899998784065247},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.3619999885559082},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3310999870300293},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.31380000710487366},{"id":"https://openalex.org/C24338571","wikidata":"https://www.wikidata.org/wiki/Q2566298","display_name":"Autoregressive integrated moving average","level":3,"score":0.2556999921798706},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.24009999632835388},{"id":"https://openalex.org/C50416739","wikidata":"https://www.wikidata.org/wiki/Q181623","display_name":"Warehouse","level":2,"score":0.22030000388622284},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.19509999454021454},{"id":"https://openalex.org/C37621935","wikidata":"https://www.wikidata.org/wiki/Q3606845","display_name":"Agricultural science","level":1,"score":0.18440000712871552}],"mesh":[],"locations_count":1,"locations":[{"id":"pmh:oai:ojs.ejurnal.methodist.ac.id:article/6518","doi":"https://doi.org/10.46880/methosisfo.v6i2.6518","is_oa":true,"landing_page_url":"https://ejurnal.methodist.ac.id/index.php/methosisfo/article/view/6518","pdf_url":"https://ejurnal.methodist.ac.id/index.php/methosisfo/article/download/6518/3296","source":{"id":"https://openalex.org/S7407075959","display_name":"METHOSISFO : Jurnal Ilmiah Sistem Informasi","issn_l":"2776-575X","issn":["2776-575X"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I3132896252","host_organization_name":"Universitas Methodist Indonesia","host_organization_lineage":["https://openalex.org/I3132896252"],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"10.46880/methosisfo.v6i2","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"pmh:oai:ojs.ejurnal.methodist.ac.id:article/6518","doi":"https://doi.org/10.46880/methosisfo.v6i2.6518","is_oa":true,"landing_page_url":"https://ejurnal.methodist.ac.id/index.php/methosisfo/article/view/6518","pdf_url":"https://ejurnal.methodist.ac.id/index.php/methosisfo/article/download/6518/3296","source":{"id":"https://openalex.org/S7407075959","display_name":"METHOSISFO : Jurnal Ilmiah Sistem Informasi","issn_l":"2776-575X","issn":["2776-575X"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I3132896252","host_organization_name":"Universitas Methodist Indonesia","host_organization_lineage":["https://openalex.org/I3132896252"],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"10.46880/methosisfo.v6i2","raw_type":"info:eu-repo/semantics/article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W7224645883.pdf","grobid_xml":"https://content.openalex.org/works/W7224645883.grobid-xml"},"referenced_works_count":4,"referenced_works":["https://openalex.org/W3080209799","https://openalex.org/W4200557237","https://openalex.org/W4280561632","https://openalex.org/W4293792363"],"related_works":["https://openalex.org/W7220683653","https://openalex.org/W4401782385","https://openalex.org/W3081516365","https://openalex.org/W2932762209","https://openalex.org/W7220775431","https://openalex.org/W7023808991","https://openalex.org/W4386453360","https://openalex.org/W2504106357","https://openalex.org/W2263576845","https://openalex.org/W7223181220"],"abstract_inverted_index":{"Warkop":[0,187],"Baris":[1],"merupakan":[2],"usaha":[3],"yang":[4,19,28],"bergerak":[5],"di":[6],"bidang":[7],"food":[8],"and":[9],"beverage":[10],"dengan":[11,79,96,162],"aktivitas":[12],"penjualan":[13,45,97,113,129,181],"setiap":[14],"hari.":[15],"Salah":[16],"satu":[17,65],"permasalahan":[18],"dihadapi":[20],"adalah":[21],"ketersediaan":[22],"stok":[23,185],"menu":[24],"atau":[25],"bahan":[26],"baku":[27],"terkadang":[29],"tidak":[30],"mencukupi":[31],"karena":[32],"perencanaan":[33,183],"masih":[34],"berdasarkan":[35],"perkiraan":[36],"dan":[37,49,69,77,107,125,156,167,182],"pengalaman.":[38],"Penelitian":[39],"ini":[40],"bertujuan":[41],"merancang":[42],"data":[43,87,121,128],"warehouse":[44,62,122],"berbasis":[46],"star":[47],"schema":[48],"menerapkan":[50],"metode":[51,174],"ARIMA":[52,91,175],"(AutoRegressive":[53],"Integrated":[54],"Moving":[55],"Average)":[56],"untuk":[57,85,111,142,145,148,152,158,178],"mendukung":[58,179],"peramalan":[59,180],"penjualan.":[60,89],"Data":[61],"dirancang":[63],"menggunakan":[64,133],"tabel":[66,71],"fakta":[67],"(fact_penjualan)":[68],"empat":[70],"dimensi,":[72],"yaitu":[73,99],"dim_waktu,":[74],"dim_produk,":[75],"dim_kategori,":[76],"dim_pelanggan,":[78],"proses":[80],"ETL":[81],"(Extract,":[82],"Transform,":[83],"Load)":[84],"mengintegrasikan":[86],"historis":[88],"Metode":[90],"diterapkan":[92],"pada":[93,186],"lima":[94],"produk":[95],"tertinggi,":[98],"Kopi,":[100,143],"TST,":[101,146],"Teh":[102,149],"Manis,":[103,150],"Nasi":[104,108,153,159],"Ayam":[105,154],"Penyet,":[106,155],"Goreng":[109,160],"Telur,":[110,161],"meramalkan":[112],"periode":[114],"Januari-Desember":[115],"2026.":[116],"Hasil":[117,170],"penelitian":[118],"menunjukkan":[119,172],"bahwa":[120,173],"berhasil":[123],"dibangun":[124],"mampu":[126],"mengelola":[127],"secara":[130],"terstruktur.":[131],"Evaluasi":[132],"Mean":[134],"Absolute":[135],"Percentage":[136],"Error":[137],"(MAPE)":[138],"menghasilkan":[139],"nilai":[140],"3,60%":[141],"5,33%":[144],"10,71%":[147],"7,89%":[151],"7,57%":[157],"rata-rata":[163],"MAPE":[164],"sebesar":[165],"7,02%":[166],"akurasi":[168],"92,98%.":[169],"tersebut":[171],"layak":[176],"digunakan":[177],"kebutuhan":[184],"Baris.":[188]},"counts_by_year":[],"updated_date":"2026-11-07T11:25:07.637180","created_date":"2026-10-30T00:00:00"}