Data Warehouse Design with Kimball Method: Case Study of Fahrenheit Manufacturing Systems
Keywords:Kimball method, datawarehouse design
Competition in the business world that increasingly stringent requires management to make decisions accurately and quickly. It is also felt by Farhenheit as entrepreneurs. To achieve thier forte in competing in the
global competition, he needs systems like strategic decision makers which is up-to-date reliable and fast. Then the solution of area manufatur datawarehouse design is necessary to support the above objectives,i.e. : the right and fast decisions. However, Fahrenheit only has ERP as their core system currently and they do not have management support system. They have some difficulty to understand some problems and do better analysis. There are some datawarehouse development methodologies. Methods that will be used for the development of datawarehouse design is Kimball Method. Kimball method was chosen because of its development process that follows the business process is very suitable for the development of datawarehouse gradually to a company.
Kimball's method gives a mart for the related business processes.This study is conducted by interview and survey from several senior managers and directors in Fahrenheit to know about their requirement and how they do analysis currently.
Breslin, Mary. (2004). Datawarehousing Battle of The Giant: Comparing the Basic of the Kimball and Inmon Models . Business Intelligent Journal, 9 (1).
Kim, Aekyung., Kim, Kyuri. (2012). Business Process Warehouse For Manufacturing Collaboration. 41th International Conference on Computers & Industrial Engineering.
Kimball, R., Margy, R. (2002). The Data Warehouse Toolkit: The Complete Guide to Dimensional Modelling. Second edition. New York: John Wiley & Sons.
Kimball, R., Ross, M., Thornthwaite, W., Mundy, J., & Becker, B. (2008). The Data Warehouse Lifecycle Toolkit. Second edition. New York: John Wiley & Sons.
Marketa, H., Hana. (2013). Business Intelligence and Implementation in a Small Enterprise. Journal of System Information, 4(2):1804-2724.
Saxena, S., Mathur, S. (2014). A Lifecycle based Testing of Data Warehouse. International Journal of Advanced Research in Computer Science and Software Engineering, 4(12), 518-523.
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.
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: