Prototipe data warehouse pada instansi pelayanan pajak daerah: Studi kasus pada Badan Pendapatan Daerah Kabupaten Badung
DOI:
https://doi.org/10.21512/emacsjournal.v2i1.5955Keywords:
data warehouse, dimensional modelling, local taxAbstract
Local taxation is one of the means by which local governments secure funding for development expenditure. Local tax data is crucial as it forms the basis for local governments’ budgetary planning. An integrated system is essential for obtaining comprehensive and valid data sources for the purposes of local policy analysis. This study will propose a data warehouse design for local tax administration bodies to enable comprehensive and rapid data analysis. The data warehouse design in this study will adopt Ralph Kimball’s data warehouse design methodology. The outcome of this study is a data warehouse design utilising data sources from several existing operational applications, which can be used as a source of comprehensive and rapid analytical data. The data warehouse design is capable of providing data integration mechanisms and broader analytical capabilities.
References
Chakiri, H., & El Mohajir, M. (2016). A data warehouse for local good governance monitoring and assessement—Case study of local registry office in Morocco. 2016 4th IEEE International Colloquium on Information Science and Technology (CiSt), 52–58. https://doi.org/10.1109/CIST.2016.7804850
Giorgini, P., Rizzi, S., & Garzetti, M. (2008). GRAnD: A goal-oriented approach to requirement analysis in data warehouses. Decision Support Systems, 45(1), 4–21. https://doi.org/10.1016/j.dss.2006.12.001
Kim, G.-H., Trimi, S., & Chung, J.-H. (2014). Big-data applications in the government sector. Communications of the ACM, 57(3), 78–85. https://doi.org/10.1145/2500873
Narendra, A, A. Murpratiwi, S., Sudarma, M. (2017) design of e-grant application data warehouse.
Nasiri, A., Ahmed, W., Wrembel, R., & Zimányi, E. (2017). Requirements Engineering for Data Warehouses (RE4DW): From Strategic Goals to Multidimensional Model. In S. de Cesare & U. Frank (Eds.), Advances in Conceptual Modeling (Vol. 10651, pp. 133–143). https://doi.org/10.1007/978-3-319-70625-2_13
Paim, F., Castro, J. (2003) DWRF: An Approach for requirement definition and management of data warehouse systems.
Prakash, N., & Prakash, D. (2018). Requirements Engineering for Data Warehousing. In N. Prakash & D. Prakash, Data Warehouse Requirements Engineering (pp. 19–50). https://doi.org/10.1007/978-981-10-7019-8_2
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2020 Devriady Pratama
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License - Share Alike that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
USER RIGHTS
All articles published Open Access will be immediately and permanently free for everyone to read and download. We are continuously working with our author communities to select the best choice of license options, currently being defined for this journal as follows: Creative Commons Attribution-Share Alike (CC BY-SA)
