Sonia Alwi Perancangan Data Warehouse pada Gerai Kita Mart Duri
Perancangan Data Warehouse pada Gerai Kita Mart Duri
Keywords:
Kita Mart, Sales, Stock, Data Warehouse, DashboardAbstract
The design of the data warehouse at Kita Mart functions to provide data to meet the information needs of sales of goods and stock of goods. Kita Mart is a daily merchandise outlet spread across several main roads in the Duri area. These outlets have separate systems and have not been integrated with each other, so they need a system that can integrate data from existing outlets and can provide summarized and fast information presentation. In addition, Kita Mart outlets are still stored in excel data, so to see information on sales of goods, we still use excel data in the form of columns and rows. This of course takes a long time to get information about sales developments. Leaders also have difficulty in making decisions related to sales because the data displayed is not summarized. Data warehouse design is one solution to process data and displayed in the form of a dashboard that contains information needed by Kita Mart management. Based on the tests that have been carried out, namely black box testing that all features can run and according to the expected results, ETL testing shows that the processed data is in accordance with the specified format, and testing user satisfaction with the interview method and filling out questionnaires measured by the linkert scale is obtained result that the system created meets the needs of the user and the user agrees with the system.References
Eckerson, W. W. (2006). Deploying Dashboards and Scorecards. Unites States: Media, Inc.
Hariyanti, E. (2008). Diambil kembali dari Perpustakaan Digital ITB:https://digilib.itb.ac.id/index.php/gdl/view/7843
Scheps, S. (2007). Business Intelligence for Dummies. United States: Wiley Publishing, Inc.
Published
Issue
Section
License
Copyright info for authors
1. Authors hold the copyright in any process, procedure, or article described in the work and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
2. Authors retain publishing rights to re-use all or portion of the work in different work but can not granting third-party requests for reprinting and republishing the work.
3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) as it can lead to productive exchanges, as well as earlier and greater citation of published work.