RANCANG BANGUN DATA WAREHOUSE UNTUK ANALISIS STRATEGI PRODUKSI PENJUALAN USULAN : PT.XYZ
DOI:
https://doi.org/10.29103/techsi.v6i1.158Abstract
Some companies convection that is often experienced by the owner of XYZ lies in the lack of information provided by each - each branch office ( lack of synchronization between the data center and branch office ). This is because the human resources available in each - each branch office is not sufficient to be able to make a more detailed report to the center. Inadequate reports of each - each branch office , also led to the management does not know for sure about their finances and inventory - each branch . System to be built is a container used to store data from various branch offices . Of these containers will be carried out such an
analysis process OLAP ( OnLine Analytical Processing ) and can also be used as reporting tools .Operational data of each branch will be entered into a central database . After that , we will perform an Extraction , Transformation , and Loading to filter the data that will be inserted into the data warehouse . Modeling the model used is the Star . Architecture that will be used is Two - Layer Architecture . The information generated from the processing of the data warehouse design waking with OLAP analysis in the form of a query . Information presented in the form of queries : goods , office and date
References
Connolly, Thomas and Carolyn Begg. (2005). Database System:
A PracticalApproach to Design, Implementation, and Management,
th Edition.Addison Wesley: Harlow, England.
McLeod, Raymond and Schell, George. (2007). Management Information Systems, 10th edition, International Edition, Pearson Prentice Hall, NewJersey.
Randy O.P. (2012). Rancang bangun data warehouse untuk analisis kinerja penjualan pada industri dengan model spa-dw Tesis, UNDIP.
R.P. Aloysius. (2011). Pembangunan Data Warehouse di CV. Saswco Perdana, Tesis,UNIKOM.
Thomas C. Hammergren and Alan R. Simon (2009) Data Warehousing for Dummies 2nd Edition, Wiley Publishing,Inc.
William H, Inmon. (2005) Building The Data Warehouse 4
Edition, John Willey & Sons, Canada.
W.H., Inmon, Richard D.H. (2005) Building The Data Warehouse 4 th Edition, Wiley Publishing,Inc.
Downloads
Published
Issue
Section
License
Authors retain copyright and grant the journal right of first publication and this work is licensed under a Creative Commons Attribution-ShareAlike 4.0 that allows others to share the work with an acknowledgement of the works authorship and initial publication in this journal.
All articles in this journal may be disseminated by listing valid sources and the title of the article should not be omitted. The content of the article is liable to the author.
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.
In the dissemination of articles by the author must declare the TECHSI Journal as the first party to publish the article.
