scholarly journals Utilization Extract, Transform, Load For Developing Data Warehouse In Education Using Pentaho Data Integration

2021 ◽  
Vol 2111 (1) ◽  
pp. 012030
Author(s):  
A D Barahama ◽  
R Wardani
Keyword(s):  
Decision Making ◽  
Information Technology ◽  
Data Warehouse ◽  
Business Process ◽  
Technology In Education ◽  
Data Warehouses ◽  
Modelling Method ◽  
Advanced Information Technology ◽  
Planning Development ◽  
Multidimensional Modelling

Abstract The utilization of data warehouses in various fields is an absolute necessity. A data warehouse is a database that contains large amounts of data that aims to help organizations, fields, and institutions specifically for decision making. Data warehouses can produce important information in the future. Loading data from various sources and processed through an ETL (Extract, Transform, Load) process that displays data consistently is the basis for creating a data warehouse architecture. The development of a data warehouse in education will provide significant benefits for the progress of education. Integration of data and processing results stored in the data warehouse can be the basis for evaluating better planning. Development of data warehouse adopt the multidimensional modelling method which consists of four stages: select the business process, declare the grain, select dimensions, and identify facts. This stage produces a data warehouse architecture and influences and contributes to the advanced information technology in education.

Data Warehouse Performance

2011 ◽  
pp. 580-585 ◽  
Author(s):  
Beixin ("Betsy") Lin ◽  
Yu Hong ◽  
Zu-Hsu Lee
Keyword(s):  
Decision Making ◽  
Data Warehouse ◽  
Business Intelligence ◽  
Performance Tuning ◽  
Data Warehouses ◽  
User Query ◽  
Data Volume ◽  
Predictive Data Mining ◽  
Support Decision Making ◽  
Over Time

A data warehouse is a large electronic repository of information that is generated and updated in a structured manner by an enterprise over time to aid business intelligence and to support decision making. Data stored in a data warehouse is non-volatile and time variant and is organized by subjects in a manner to support decision making (Inmon et al., 2001). Data warehousing has been increasingly adopted by enterprises as the backbone technology for business intelligence reporting and query performance has become the key to the successful implementation of data warehouses. According to a survey of 358 businesses on reporting and end-user query tools, conducted by Appfluent Technology, data warehouse performance significantly affects the Return on Investment (ROI) on Business Intelligence (BI) systems and directly impacts the bottom line of the systems (Appfluent Technology, 2002). Even though in some circumstances it is very difficult to measure the benefits of BI projects in terms of ROI or dollar figures, management teams are still eager to have a “single version of the truth,” better information for strategic and tactical decision making, and more efficient business processes by using BI solutions (Eckerson, 2003). Dramatic increases in data volumes over time and the mixed quality of data can adversely affect the performance of a data warehouse. Some data may become outdated over time and can be mixed with data that are still valid for decision making. In addition, data are often collected to meet potential requirements, but may never be used. Data warehouses also contain external data (e.g. demographic, psychographic, etc.) to support a variety of predictive data mining activities. All these factors contribute to the massive growth of data volume. As a result, even a simple query may become burdensome to process and cause overflowing system indices (Inmon et al., 1998). Thus, exploring the techniques of performance tuning becomes an important subject in data warehouse management.

scholarly journals The impact of information technology in decision making process of companies in Kosovo

2018 ◽  
Vol 51 (1-2) ◽  
pp. 13-23
Author(s):  
Emin Qerim Neziraj ◽  
Aferdita Berisha Shaqiri
Keyword(s):  
Decision Making ◽  
Information Technology ◽  
Decision Maker ◽  
Business Process ◽  
New Technologies ◽  
Decision Makers ◽  
Decision Making Process ◽  
Or Organization ◽  
The Impact ◽  
Future Business

Before the decision makers set much higher requirements in the decision-making than ever before due to the environment of decision-makers subject to change under the influence of progress and development of new technologies, networking individual or organization inside and the outside environment, and modern means of communication enabling continuous inflow, flow and sharing of data and information. In these modern conditions the process of collecting, analyzing, selecting data and information to make informed decisions in the context of possible restrictions and the available options, and ultimately making decisions as the basis for future business or behavior, is not simplified. The use of new technologies in the decision-making process provided numerous opportunities to facilitate decisions selection. However, the decision maker should still be able to differentiate which knowledge should be used to serve in decision making, and which models, methods, tools, systems, and procedures to be used in certain situations, with the purpose of successful decision selection. In this paper, we will examine the decision making process during the business process of the companies in Kosovo.

scholarly journals Investment Cost Model in Business Process Intelligence in Banking And Electricity Company

2016 ◽  
Vol 7 (2) ◽  
pp. 113
Author(s):  
Arta Moro Sundjaja
Keyword(s):  
Decision Making ◽  
Literature Review ◽  
Data Warehouse ◽  
Business Process ◽  
Cost Model ◽  
Process Performance ◽  
Design Development ◽  
Business Process Intelligence ◽  
Investment Cost ◽  
Decision Making Processes

Higher demand from the top management in measuring business process performance causes the incremental implementation of BPM and BI in the enterprise. The problem faced by top managements is how to integrate their data from all system used to support the business and process the data become information that able to support the decision-making processes. Our literature review elaborates several implementations of BPI on companies in Australia and Germany, challenges faced by organizations in developing BPI solution in their organizations and some cost model to calculate the investment of BPI solutions. This paper shows the success in BPI application of banks and assurance companies in German and electricity work in Australia aims to give a vision about the importance of BPI application. Many challenges in BPI application of companies in German and Australia, BPI solution, and data warehouse design development have been discussed to add insight in future BPI development. And the last is an explanation about how to analyze cost associated with BPI solution investment.

Decision Support and Data Warehousing

2008 ◽  
pp. 397-407
Author(s):  
Alexander Anisimov
Keyword(s):  
Decision Making ◽  
Information Technology ◽  
Decision Support ◽  
Decision Support Systems ◽  
Support Systems ◽  
Data Warehousing ◽  
Global Information ◽  
Data Warehouses ◽  
Sources Of Information ◽  
External Sources

This chapter is dedicated to the major managerial, organizational and technological aspects of development of data warehouses in a global information environment, when different external sources of information are available and potentially may have value for decision support and managerial analysis. It summarizes the major benefits that become available for businesses if they decide to integrate information from external sources into their data warehouses. It also introduces the overall organizational framework of development of data warehouses that are based upon the information from different external sources. Furthermore the author hopes that understanding of the framework introduced will not only inform practitioners (both information technology (IT) specialists and managers in different spheres of business) of new possible approaches to design of decision support systems but also assist in the improvement of approaches to decision-making procedures.

Web Page Extension of Data Warehouses

2011 ◽  
pp. 2090-2095
Author(s):  
Anthony Scime
Keyword(s):  
Decision Making ◽  
Data Warehouse ◽  
Decision Maker ◽  
Search Engine ◽  
External Information ◽  
Data Warehouses ◽  
Strategic Decisions ◽  
Web Searches ◽  
To Come ◽  
The Web

Data warehouses are constructed to provide valuable and current information for decision-making. Typically this information is derived from the organization’s functional databases. The data warehouse is then providing a consolidated, convenient source of data for the decision-maker. However, the available organizational information may not be sufficient to come to a decision. Information external to the organization is also often necessary for management to arrive at strategic decisions. Such external information may be available on the World Wide Web; and when added to the data warehouse extends decision-making power. The Web can be considered as a large repository of data. This data is on the whole unstructured and must be gathered and extracted to be made into something valuable for the organizational decision maker. To gather this data and place it into the organization’s data warehouse requires an understanding of the data warehouse metadata and the use of Web mining techniques (Laware, 2005). Typically when conducting a search on the Web, a user initiates the search by using a search engine to find documents that refer to the desired subject. This requires the user to define the domain of interest as a keyword or a collection of keywords that can be processed by the search engine. The searcher may not know how to break the domain down, thus limiting the search to the domain name. However, even given the ability to break down the domain and conduct a search, the search results have two significant problems. One, Web searches return information about a very large number of documents. Two, much of the returned information may be marginally relevant or completely irrelevant to the domain. The decision maker may not have time to sift through results to find the meaningful information. A data warehouse that has already found domain relevant Web pages can relieve the decision maker from having to decide on search keywords and having to determine the relevant documents from those found in a search. Such a data warehouse requires previously conducted searches to add Web information.

The Research of Intelligence Data Mining Oriented to Battlefield Situation Assessment

2013 ◽  
Vol 427-429 ◽  
pp. 1662-1665
Author(s):  
Jing Xue Liu ◽  
Wei Tang
Keyword(s):  
Data Mining ◽  
Decision Making ◽  
Data Warehouse ◽  
Data Warehouses ◽  
Situation Assessment ◽  
Basic Construction ◽  
Holistic Conception

Battlefield situation assessment has a positive significance on improving the efficiency of commanding decision-making; moreover, battlefield situation assessment cannot be made successfully without the support of some integrated and exact intelligence data. In this paper, basing on the demand of identifying the battlefield situation, the corresponding knowledge context database was first discussed; on this basic, construction of the intelligence data warehouses framework was explored. Then, the study of data mining based on the intelligence data warehouse was made from the view of a holistic conception, and a detailed arithmetic was presented by making use of the tactic from data mining driven fishbone.

scholarly journals Construction and functioning for the data warehouse in the enterprise in the context of the effective decision making

Equilibrium ◽  
2009 ◽  
Vol 2 (1) ◽  
pp. 171-180
Author(s):  
Michał Kukliński
Keyword(s):  
Decision Making ◽  
Data Processing ◽  
Data Warehouse ◽  
Business Intelligence ◽  
Data Warehouses ◽  
Economic Decisions ◽  
Business Intelligence Systems ◽  
Effective Decision ◽  
Effective Decision Making ◽  
Answering Questions

In the twenty-four hours of computerised enterprises, recruiting huge amounts of data, processing them in the traditional way would be highly ineffective and it will not deliver to us so much interesting information, forecasts and the relation, as Business Intelligence systems, of which Data Warehouses are a basis. The publication is answering questions: what the data warehouse is what is serving for and what are examples of applying. Stages of the build of the Data Warehouse and factors assuring achieving success in taking economic decisions will be introduced.

scholarly journals Decision making based on data analyses using data warehouses

2018 ◽  
Vol 6 (3) ◽  
pp. 1-6
Author(s):  
Valdrin Haxhiu
Keyword(s):  
Decision Making ◽  
Data Warehouse ◽  
Relational Databases ◽  
Daily Basis ◽  
Transformation Process ◽  
Sql Server ◽  
Data Warehouses ◽  
Data Analyses ◽  
Weak Points ◽  
Using Data

Data warehouses are a collection of several databases, whose goal is to help different companies and corporations make important decisions about their activities. These decisions are taken from the analyses that are made to the data within the data warehouse. These data are taken from data that companies and corporations collect on daily basis from their branches that may be located in different cities, regions, states and continents. Data that are entered to data warehouses are historical data and they represent that part of data that is important for making decisions. These data go under a transformation process in order to accommodate with the structure of the objects within the databases in the data warehouse. This is done because the structure of the relational databases is not similar with the structure of the databases (multidimensional databases) within the data warehouse. The first ones are optimized for transactions on daily basis like: entering, changing, deleting and retrieving data through simple queries, the second ones are optimized for retrieving data through multidimensional queries, which enable us to extract important information. This information helps to make important decisions by learning which are the weak points and the strong points of the company, in order to invest more on the weak points and to strengthen the strong points, increasing the profits of the company. The goal of this paper is to treat data analyses for decision making from a data warehouse by using OLAP (online analytical processing) analysis. For this treatment we used the Analysis Services of Microsoft SQL Server 2016 platform. We analyzed the data of an IT Store with branches in different cities in Kosovo and came to a conclusion for some sales trends. This paper emphasizes the role of data warehouses in decision making.

The Research of Intelligence Data Mining Oriented to Battlefield Situation Assessment

2013 ◽  
Vol 380-384 ◽  
pp. 1282-1285
Author(s):  
Jing Xue Liu ◽  
Wei Tang
Keyword(s):  
Data Mining ◽  
Decision Making ◽  
Data Warehouse ◽  
Data Warehouses ◽  
Situation Assessment ◽  
Basic Construction ◽  
Holistic Conception

Battlefield situation assessment (BSA) has a positive significance on improving the efficiency of commanding decision-making, moreover, BSA cannot be made successfully without the support of some integrated and exact intelligence data. In this paper, basing on the demand of identifying the battlefield situation, the corresponding knowledge context database is first discussed; on this basic, construction of the intelligence data warehouses framework is explored. Then, from the view of a holistic conception, the study of data mining based on the intelligence data warehouse is made, and a detailed arithmetic is presented by making use of the tactic from data mining driven fishbone (DMDF).

scholarly journals Analysis of Data Warehouse for Transactional Analysis Methods Online Analytical Processing (OLAP) at Company XYZ Silver

2017 ◽  
Vol 2 (1) ◽  
pp. 72
Author(s):  
Putu Widiadnyana ◽  
M. Azman Maricar ◽  
I Nyoman Arnawan ◽  
Sri Ariyani
Keyword(s):  
Decision Making ◽  
Information Technology ◽  
Data Warehouse ◽  
Production Costs ◽  
Transactional Analysis ◽  
Web Based ◽  
Analytical Processing ◽  
A Company ◽  
Processing Mechanisms ◽  
Sales Increase

Utilization of information technology is a necessity in looking at opportunities available for decision making by the management. With the ability of information technology to analyze existing used the data into useful information for a company. OLAP is Able to Overcome problems in the data processing mechanisms guided to know various information from different angles. By utilizing transactional analysis, then we know the reaction of customers in choosing the products that we will market. The result of Web-based sales has Decreased for the Gianyar and Denpasar regions but has Increased for the Ubud and online areas so as to give a benefit in terms of production costs. With the training for a sales increase of sales can evenly across locations and need input from customers related to minimize returns.

Sign in / Sign up

Export Citation Format

Share Document