Model Data Warehouse dan Business Intelligence untuk Meningkatkan Penjualan pada PT. S


  • Rudy Rudy Bina Nusantara University
  • Natalia Limantara Bina Nusantara University



data warehouse, sales, business intelligence, database


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


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.






Abstract 429  .
PDF downloaded 559  .