PERANCANGAN DASHBOARD UNTUK VISUALISASI HARGA DAN PASOKAN BERAS DI PASAR INDUK BERAS CIPINANG

Jurnal Teknologi Industri Pertanian Pub Date : 2021-07-01 DOI:10.24961/j.tek.ind.pert.2021.31.1.12

Dedi Sugiarto, Is Mardianto, M. Najih, Dani Adrian, Dimas Adi Pratama

{"title":"PERANCANGAN DASHBOARD UNTUK VISUALISASI HARGA DAN PASOKAN BERAS DI PASAR INDUK BERAS CIPINANG","authors":"Dedi Sugiarto, Is Mardianto, M. Najih, Dani Adrian, Dimas Adi Pratama","doi":"10.24961/j.tek.ind.pert.2021.31.1.12","DOIUrl":null,"url":null,"abstract":"Food Station is a city-owned enterprise owned by the Jakarta Provincial Government whose tasks include monitoring and publication of supply data and rice price through Cipinang Rice Market so that it is useful as a guide for traders and policy makers in relevant government institutions. This study aims to design a dashboard to visualize the price and supply of rice through Cipinang Rice Market. The research stages consist of identification of information requirement, data warehouse design and On-line Analytical Processing (OLAP) database, transfer of operational data from excel file and web scrapping into OLAP database through Extract, Transform, Load (ETL) process and create dashboard using PowerBI application. The result of this research is a data warehouse that can facilitate the analysis with some fact table that is price, quantity of rice enter, quantity of rice out and stock and some dimension table that is place dimension (city of origin / destination), dimension time, dimension of rice type and dimension market and dashboard of various price and supply charts that can be selected based on available dimensions. \nKeywords: dashboard, data warehouse, rice price, rice supply, visualization","PeriodicalId":17735,"journal":{"name":"Jurnal Teknologi Industri Pertanian","volume":"43 1","pages":""},"PeriodicalIF":0.0000,"publicationDate":"2021-07-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"6","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"Jurnal Teknologi Industri Pertanian","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.24961/j.tek.ind.pert.2021.31.1.12","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 6

Abstract

Food Station is a city-owned enterprise owned by the Jakarta Provincial Government whose tasks include monitoring and publication of supply data and rice price through Cipinang Rice Market so that it is useful as a guide for traders and policy makers in relevant government institutions. This study aims to design a dashboard to visualize the price and supply of rice through Cipinang Rice Market. The research stages consist of identification of information requirement, data warehouse design and On-line Analytical Processing (OLAP) database, transfer of operational data from excel file and web scrapping into OLAP database through Extract, Transform, Load (ETL) process and create dashboard using PowerBI application. The result of this research is a data warehouse that can facilitate the analysis with some fact table that is price, quantity of rice enter, quantity of rice out and stock and some dimension table that is place dimension (city of origin / destination), dimension time, dimension of rice type and dimension market and dashboard of various price and supply charts that can be selected based on available dimensions. Keywords: dashboard, data warehouse, rice price, rice supply, visualization

查看原文本刊更多论文

食品站是雅加达省政府拥有的市属企业，其任务包括通过Cipinang大米市场监测和公布供应数据和大米价格，以便为相关政府机构的贸易商和政策制定者提供有用的指导。本研究的目的是设计一个仪表盘，通过浙江大米市场可视化大米的价格和供应。研究阶段包括信息需求识别、数据仓库设计和联机分析处理(OLAP)数据库，通过ETL (Extract, Transform, Load)流程将excel文件和web抓取中的操作数据转移到OLAP数据库中，并使用PowerBI应用程序创建仪表板。本研究的结果是一个数据仓库，可以方便地分析一些事实表，如价格，大米进口量，大米出口量和库存，一些维度表，如地点维度(原产/目的地城市)，维度时间，大米类型维度和市场维度，以及各种价格和供应图表的仪表板，可以根据可用的维度选择。关键词:仪表板，数据仓库，大米价格，大米供应，可视化

本文章由计算机程序翻译，如有差异，请以英文原文为准。

求助全文

约1分钟内获得全文求助全文

来源期刊

Jurnal Teknologi Industri Pertanian

自引率

0.00%

发文量