Designing Data Warehouse Model Using Benefit Cost Ratio Analysis Method

• Дата: 2021
• Автори: Qusyairi, M., Sudarma, M., Dharma, A.
• Формат: Стаття
• Мова: English
• Опубліковано: Міжнародний науково-навчальний центр інформаційних технологій і систем НАН та МОН України 2021
• Назва видання: Control systems & computers
• Теми: Applications
• Онлайн доступ: http://dspace.nbuv.gov.ua/handle/123456789/181265
• Назва журналу: Digital Library of Periodicals of National Academy of Sciences of Ukraine
• Цитувати: Designing Data Warehouse Model Using Benefit Cost Ratio Analysis Method / M. Qusyairi, M. Sudarma, A. Dharma // Control systems & computers. — 2021. — № 2-3. — С. 84-91. — Бібліогр.: 11 назв. — англ.

Data warehouse has function to make the spreaded company’s data to be integrated and concise, thereby it helps the executives in analyzing the existing data to obtain a quick and accurate strategic decision. This research has objective to design a data warehouse within the scope of application of the benefit-cost ratio. As a solution to the feasibility of the company's business, the unity of different data enables it to be combined with the results of the company's in-depth analysis. In designing the model, this research succeeded in designing data warehouse with the application of benefit-cost-ratio method which is used to carry out in-depth analysis of financial sector by providing the feasibility and percentage results of the current business. To summarize, the source data that is processed into the process of extracting, transforming, and loading which built by the star schema will affect the quality of generated data for the process of queries. In addition, the results of the data warehouse used for the decision-making process and feasible business strategy.