DATA WAREHOUSE UNTUK PENGELOLAAN PENJUALAN PADA PT. LIPPO KARAWACI, TBK.
Abstract : The purpose of this research is to design a data warehouse in accordance with the requirements of PT. Lippo Karawaci, Tbk. The company is engaged in the field of property ranging from land acquisition through construction and its maintenance. Designing a data warehouse is limited to the sale. The use of data warehouse is expected to support the information needs of executives in business decisions quickly. The method used is the method of analysis and design. Method of analysis was done through literature study and interviews with relevant parties. Design method is done by determining the process, grain, dimensions, facts, measure, and the mapping OLTP to data warehouse, which is followed by physical design. The results of this study is a data warehouse application systems that include data warehousing, OLAP cube, and an application system that is used to access the data warehouse. Implementation of data warehouse has been evaluated by the evaluation results associated with the display, the benefits and accuracy of application data.
Keyword : Data warehouse, Cube, Measure, Dimention, Data Transformation Service (DTS)
Connolly, Thomas dan Begg, Carolyn. 2005. Database Systems: A Pratical Approach to
Design, Implementation, and Management. Fourth Edition. Eddison-Westley:
Hutabarat,Bernaridho. 2005. Datawarehousing dengan SQL Server 2005. PT Elex
Inmon, W.H. 2005. Building the Data Warehouse. Fourth Edition. John Wiley & Sons,
Kimball, Ralph. 2002. The Data Warehouse Toolkit. Second Edition. John Wiley &
Sons, Inc, Amerika.
Markus, 2007, Bussiness Intelligence dengan SQL Server 2005,
Mulyadi. 2001. Sistem Akutansi. Edisi ke-3. Salemba Empat, Jakarta.
Mundy,J.,Thornthwaite,W., dan Kimball,R. 2006. The Microsoft Data Warehouse
Toolkit: With SQL Server 2005 and the Microsoft Bussiness Inteligence
Toolset. Wiley Publishing, Inc, Indiana.
Rob,Peter dan Coronel,Carlos.2002. Database Systems : Design, Implementation, &
Management. 5th Edition. Thomson Learning.
Article MetricsAbstract view : 262 times
PDF - 1244 times
- There are currently no refbacks.
Badan Pengelola Jurnal Ilmiah Sistem Informasi dan Teknik Informatika (SISFOTENIKA) STMIK Pontianak.
Jurnal Ilmiah SISFOTENIKA terindex di :
SERTIFIKAT PENGHARGAAN :
Jurnal Ilmiah SISFOTENIKA Terakreditasi Peringkat Empat
Partners & Co-Organizers:
Jurnal Ilmiah SISFOTENIKA: STMIK Pontianak Online Journal ISSN Printed (2087-7897) - ISSN Online (2460-5344) licensed under a Lisensi Creative Commons Atribusi 4.0 Internasional.