Model Data Warehouse dan Business Intelligence untuk Meningkatkan Penjualan pada PT. S
DOI:
https://doi.org/10.21512/comtech.v2i1.2774Keywords:
data warehouse, sales, business intelligence, databaseAbstract
Today a lot of companies use information system in every business activity. Every transaction is stored electronically in the database transaction. The transactional database does not help much to assist the executives in making strategic decisions to improve the company competitiveness. The objective of this research is to analyze the operational database system and the information needed by the management to design a data warehouse model which fits the executive information needs in PT. S. The research method uses the Nine-Step Methodology data warehouse design by Ralph Kimball. The result is a data warehouse featuring business intelligence applications to display information of historical data in tables, graphs, pivot tables, and dashboards and has several points of view for the management. This research concludes that a data warehouse which combines multiple database transactions with business intelligence application can help executives to understand the reports in order to accelerate decision-making processes.
Plum Analytics
References
Connolly, T. & Begg, C. (2005). Database Systems: A Practical Approach to Design, Implementation, and Management, (4th ed.). Boston: Addison Wesley.
Hollander, Anita S., Denna, Eric L., and Cherrington, J Owen. (2000). Accounting, Information Technology, and Business Solutions, (2nd ed.). Raffles, Singapore: McGraw Hill International.
Inmon, W. H. (2005). Building the Data Warehouse, (4th ed.). Indianapolis: Wiley Publishing.
Kimball, Ralph, and Ross, Margy. (2002). The data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, (2nd ed.). Toronto, Canada: John Wiley and Sons.
Whalen, E., Garcia, M., Thompson, D. (2001). Microsoft SQL Server 2000 Performance Tuning Technical Reference. Washington: Microsoft Press.
Downloads
Published
Issue
Section
License
Authors who publish with this journal agree to the following terms:
a. 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.
b. 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.
c. 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:
