scholarly journals Data Warehouse - The Source of Business Information

10.28945/2967 ◽  
2006 ◽  
Author(s):  
Malgorzata Nycz ◽  
Barbara Smok

Recently the role and importance of database application in supporting the decision making process has been still increasing. Data warehouse can be an answer for this challenge. Data collected in a warehouse deliver different information e.g. about market, demand, selling goods, trends, anomalies on market. The paper presents data warehouse as a potential source of business information.

2020 ◽  
Vol 6 (1) ◽  
pp. 111-120
Author(s):  
Rahmat Tri Yunandar ◽  
Amir Amir ◽  
Khairul Rizal

As an Educational institutions need to have more knowledge, in evaluating, designing and making decisions. Where from such knowledge can be obtained from the data stored in the operational activities of educational institutions databases into the data warehose, so it can be used as a support in the decision making process. Data Warehouse has a major role in the provision of strategic information that can be used to meet the needs of management in a business context. This study examines the development of the data warehouse to the data of new admissions to the STIE Binaniaga Bogor, which can dig up important information that can help retrieval strategic decision to support promotional activities at the STIE Binaniaga Bogor. The final goal of this study was to produce a design of a data warehouse that can support the needs of management in making decisions by providing strategic information on new admissions, which produces a summary of information that is accurate and useful as input to determine strategies for promotion.


Author(s):  
Alysson Bolognesi Prado ◽  
Carmen Freitas ◽  
Thiago Ricardo Sbrici

In the growing challenge of managing people, Human Resources need effective artifacts to support decision making. On Line Analytical Processing is intended to make business information available for managers, and HR departments can now encompass this technology. This paper describes a project in which the authors built a Data Warehouse containing actual Human Resource data. This paper provides data models and shows their use through OLAP software and their presentation to end-users using a web portal. The authors also discuss the progress, and some obstacles of the project, from the IT staff’s viewpoint.


2020 ◽  
Vol 4 (2) ◽  
pp. 80
Author(s):  
Zhang Xiangxiang ◽  
Gao Gengjun

Inventory pledge financing not only solves the financing difficulties of small and medium-sized enterprises, but also opens up business channels for banks. Under the random market demand, this article studies the pledge decision-making of perishable pledges in the inventory pledge business, and establishes that banks do not adopt and adopt the Internet of Things. The pledge rate decision-making model in the two technical situations aims at maximizing the profit at the end of the pledge period. The factors in the model such as the pledge rate, end-of-period income, and IoT technology coverage rate are analyzed respectively, and finally the decision-making process is verified through calculation examples. Studies have shown that, within a certain range, banks can use IoT technology to supervise pledges to obtain greater benefits. However, as the coverage of IoT technology increases, bank revenues continue to decrease, so to obtain greater benefits requires the Internet of Things technology set by the bank Invest.


Author(s):  
Eka Miranda

The increasing competition in hotel business forces every hotel to be equiped with analysis tools that can maximize its marketing performance. This paper discusses the development of a data warehouse model and analytic tools to enhance the company's competitive advantage through the utilization of a variety of data, information and knowledge held by the company as a raw material in the decision making process. A study is done at ABC Hotel which uses a database to save the transactional record. However, the database cannot be directly used to support analysis and decision making process. Based on this issue, the company needs a data warehouse model and analytic tools that can be used to store large amounts of data and also potentially to gain a new perspective of data distribution which allows to provide reporting and answers of ad hoc users questions and assist managers in making decisions. Further data warehouse model and analytic tools can be used to help manager to formulate planning and marketing strategies. Data are collected through interviews and literature study, followed by data analysis to analyze business processes, to identify the problems and the information to support analysis process. Furthermore, data warehouse is designed using analysis of records related to the activities in hotel's marketing area and data warehouse model. The result of this paper is data warehouse model and analytic tools to analyze the external and transactional data and to support decision making process in marketing area.


Author(s):  
Tino Feri Efendi ◽  
Mutiya Krisanty

Data Warehouse is a computer system for archiving and analyzing historical data of an organization. An organization copies information from its operational systems to a warehouse. The purpose of this research is to help provide information in supporting the decision-making process in the field of sales, purchasing and material inventory control at PT Kanaan Global Indonesia. PT Kanaan Global Indonesia previously presented the data warehouse manually. By designing a data warehouse system, company leaders can be more assisted in making decisions that are faster and more precise. The research method used includes analysis of observations, interviews, documentation and literature study. The result of this research is the availability of a data warehouse that can produce fast and precise information, thus helping the company in making decisions.Keywords— Data, Information, Warehouse


Author(s):  
Choirul Huda ◽  
Rita Puspita Sari ◽  
Muharram Hasein Haekal ◽  
Tri Agustaria

One rapidly evolving technology today is information technology, which can help decision-making in an organization or a company. The data warehouse is one form of information technology that supports those needs, as one of the right solutions for companies in decision-making. The objective of this research is the development of a data warehouse at PT JKL in order to support executives in analyzing the organization and support the decision-making process. Methodology of this research is conducting interview with related units, literature study and document examination. This research also used the Nine Step Methodology developed by Kimball to design the data warehouse. The results obtained is an application that can summarize the data warehouse, integrating and presenting historical data in multidimensional. The conclusion from this research is the data warehouse can help companies to analyze data in a flexible, fast, and effective data access.Keywords: Data Warehouse; Inventory; Contract Approval; Inventory; Dashboard


2012 ◽  
Author(s):  
Samuel Otero Schmidt ◽  
Edmir P. Vasques Prado ◽  
Hiroo Takaoka

The organizations are investing more in information technology to collect, store and process vast amounts of information. Generally this information has no standard and repeated data, which hinders the decision making process. The cause of the difficulties is related to Information Quality (IQ) that has technical characteristics related to the architecture used in Data Warehouse (DW) and Business Intelligence (BI) environments. Based on the existing literature and insights from the author a research model was created to identify the relations between components of DW/BI architecture and IQ dimensions. We used the case study as research method. This research makes contributions to better understand IT architecture for DW/BI.


2019 ◽  
Vol 8 (4) ◽  
pp. 12365-12372

In the modern era, technology plays a vital role by contributing in the development of business by providing various tools and techniques to enhance the business decision-making process. Data warehouse is an important entity that contributes to the decision-making process, which can be seen in the literature available over the years. Data warehouse provides the basis for quality analysis of available data by deriving accurate information from data. Like many other industries, banking sector is also facing challenges due to various reasons like large over-dues, non-performing assets, changing customer demographics, matching customer expectation levels, increased competition from financial technological companies and banking competitors, etc. Thus data warehouse system serves to be the best solution for the banks to overcome challenges as data warehouse system integrates all the data at one place and provides a consolidated view of the past transactions which can be used for report generation and performing analytical analysis in order to help the management to maximize business performance. In addition to making strategic decisions, data warehouse also assist in helping the banks to improve customer retention, optimize discounting, market segmentation, business performance, customer deposits, etc. Thus, a data warehouse system provides a solution to all data management problem and generate patterns and reports for analytical end users for enhancing decision making processes. In this research paper, we shall be representing a bank model that focuses on the loan department of a bank data warehouse and shall be explaining how business intelligence plays a role in improving the loan analysis for the banks. Loan analysis may include summarizing the classified loans, analyzing loans within and exceeding the threshold limits of Loan-To-Value (LTV) ratio, analysis of loan rejections and other analysis pertaining to loans.


2010 ◽  
Vol 6 (4) ◽  
pp. 49-62 ◽  
Author(s):  
Alysson Bolognesi Prado ◽  
Carmen Freitas ◽  
Thiago Ricardo Sbrici

In the growing challenge of managing people, Human Resources need effective artifacts to support decision making. On Line Analytical Processing is intended to make business information available for managers, and HR departments can now encompass this technology. This paper describes a project in which the authors built a Data Warehouse containing actual Human Resource data. This paper provides data models and shows their use through OLAP software and their presentation to end-users using a web portal. The authors also discuss the progress, and some obstacles of the project, from the IT staff’s viewpoint.


Sign in / Sign up

Export Citation Format

Share Document