Implementasi Data Warehouse Menggunakan Pentaho BI di Hartaning House Homestay

2021 ◽  
Vol 10 (1) ◽  
pp. 153
Author(s):  
Made Rusdinda Hartani ◽  
Ida Bagus Made Mahendra
Keyword(s):  
Open Source ◽  
Data Warehouse ◽  
Business Intelligence ◽  
Equal Distribution ◽  
Warehouse Design ◽  
System Designs ◽  
Made In

Hartaning House is one of the homestays in Ubud Gianyar that rents out homestay rooms to foreign and local tourists, but currently does not have a data-based system that facilitates business reports. This research aims to provide a proposed solution in the form of designing and implementing data related to room rental, to facilitate the determination of the promotion of equal distribution of all homestay rooms. The implementation will use an open source application, namely (Pentaho Business Intelligence) for making reports that are used to facilitate analysis. The data is made in a multi-dimensional design to facilitate the application of the data warehouse design and system designs that have been made.

Evolutionary Intelligent Data Warehousing Approach to Knowledge Discovery Systems: Dynamic Cubing

2019 ◽  
Vol 13 ◽  
Author(s):  
Harkiran Kaur ◽  
Kawaljeet Singh ◽  
Tejinder Kaur
Keyword(s):  
Knowledge Discovery ◽  
Data Warehouse ◽  
Business Intelligence ◽  
End Users ◽  
Processing Stage ◽  
Information Update ◽  
On Line ◽  
Analytical Processing ◽  
Warehouse Operations ◽  
Made In

Background: Numerous E – Migrants databases assist the migrants to locate their peers in various countries; hence contributing largely in communication of migrants, staying overseas. Presently, these traditional E – Migrants databases face the issues of non – scalability, difficult search mechanisms and burdensome information update routines. Furthermore, analysis of migrants’ profiles in these databases has remained unhandled till date and hence do not generate any knowledge. Objective: To design and develop an efficient and multidimensional knowledge discovery framework for E - Migrants databases. Method: In the proposed technique, results of complex calculations related to most probable On-Line Analytical Processing operations required by end users, are stored in the form of Decision Trees, at the pre- processing stage of data analysis. While browsing the Cube, these pre-computed results are called; thus offering Dynamic Cubing feature to end users at runtime. This data-tuning step reduces the query processing time and increases efficiency of required data warehouse operations. Results: Experiments conducted with Data Warehouse of around 1000 migrants’ profiles confirm the knowledge discovery power of this proposal. Using the proposed methodology, authors have designed a framework efficient enough to incorporate the amendments made in the E – Migrants Data Warehouse systems on regular intervals, which was totally missing in the traditional E – Migrants databases. Conclusion: The proposed methodology facilitate migrants to generate dynamic knowledge and visualize it in the form of dynamic cubes. Applying Business Intelligence mechanisms, blending it with tuned OLAP operations, the authors have managed to transform traditional datasets into intelligent migrants Data Warehouse.

Commercial and Open Source Business Intelligence Platforms for Big Data Warehousing

2019 ◽  
pp. 158-181 ◽  
Author(s):  
Jorge Bernardino ◽  
Joaquim Lapa ◽  
Ana Almeida
Keyword(s):  
Decision Making ◽  
Big Data ◽  
Decision Support ◽  
Comparative Analysis ◽  
Open Source ◽  
Data Warehouse ◽  
Business Intelligence ◽  
Selection Process ◽  
Decision Making Processes ◽  
Big Data Warehouse

A big data warehouse enables the analysis of large amounts of information that typically comes from the organization's transactional systems (OLTP). However, today's data warehouse systems do not have the capacity to handle the massive amount of data that is currently produced. Business intelligence (BI) is a collection of decision support technologies that enable executives, managers, and analysts to make better and faster decisions. Organizations must make good use of business intelligence platforms to quickly acquire desirable information from the huge volume of data to reduce the time and increase the efficiency of decision-making processes. In this chapter, the authors present a comparative analysis of commercial and open source BI tools capabilities, in order to aid organizations in the selection process of the most suitable BI platform. They also evaluated and compared six major open source BI platforms: Actuate, Jaspersoft, Jedox/Palo, Pentaho, SpagoBI, and Vanilla; and six major commercial BI platforms: IBM Cognos, Microsoft BI, MicroStrategy, Oracle BI, SAP BI, and SAS BI & Analytics.

scholarly journals RANCANGAN DATA WAREHOUSE AKADEMIK POLITEKNIK PARIWISATA BALI BERBASIS LINUX OPENSUSE

2021 ◽  
Vol 4 (1) ◽  
pp. 18-25
Author(s):  
I Gusti Agung Made Wirautama ◽  
I Made Candiasa ◽  
Gede Rasben Dantes ◽  
I Putu Agus Eka Pratama
Keyword(s):  
Information System ◽  
Information Systems ◽  
Open Source ◽  
Data Warehouse ◽  
Literature Study ◽  
Research Information ◽  
Warehouse Design ◽  
Academic Information ◽  
The Right ◽  
Open Source Hardware

This study aims to design an academic data warehouse at Politeknik Pariwisata Bali because there are several information systems that require a system capable of handling databases of several existing information system applications and perform analysis. A data warehouse is the right solution for handling databases of several information systems that are not yet integrated. The research method begins with literature study, identification of problems, determining research objectives, designing solutions, namely designing an academic data warehouse, determining the hardware and software specifications needed, and ending with discussions and drawing conclusions. The result of this research is an academic data warehouse design that can be implemented properly. Besides, the results of this study are also accompanied by specifications for open-source hardware and software to save costs. The data warehouse design produced in this study uses a database of 3 information systems which is the main business process of a college, namely: Academic Information System, Information System for New Student Admissions, Research Information System. The three databases of the information system are internal data sources using the MySQL DBMS. The resulting academic data warehouse design uses open source software, namely: openSUSE, Pentaho Data Integration, MySQL DBMS.

Business Intelligence-as-a-Service

2011 ◽  
pp. 199-221 ◽  
Author(s):  
Moez Essaidi ◽  
Aomar Osmani
Keyword(s):  
Open Source ◽  
Data Warehouse ◽  
Business Intelligence ◽  
Data Warehousing ◽  
Software As A Service ◽  
Architecture Model ◽  
Model Driven ◽  
Industry Standards ◽  
Service Deployment ◽  
Methodological Aspects

In recent years, the data warehousing infrastructures have undergone many changes in various aspects. This is usually due to many factors: the emergence of Software-as-a-Service (SaaS) architecture model; the success of agile and iterative Data Warehouse (DW) development approaches; the introduction of new approaches based on the Model Driven Architecture (MDA); the changing needs of organizations and the extension of the DW into new application areas; and the evolving of standards and open-source technologies. This chapter explores several aspects that may influence the next-generation of data warehousing platforms: the architectural aspects for business intelligence-as-a-service deployment, the promising open industry standards and technologies recommended for use, and the emerging methodological aspects for DW components engineering.

The quantitative comparison of experimental and simulated diffraction contrast images

1995 ◽  
Vol 53 ◽  
pp. 102-103
Author(s):  
Stuart McKernan
Keyword(s):  
Image Processing ◽  
Personal Computer ◽  
Close Agreement ◽  
Quantitative Comparison ◽  
Image Simulation ◽  
Computing Power ◽  
Diffraction Contrast ◽  
Simulated Images ◽  
Made In

For many years the concept of quantitative diffraction contrast experiments might have consisted of the determination of dislocation Burgers vectors using a g.b = 0 criterion from several different 2-beam images. Since the advent of the personal computer revolution, the available computing power for performing image-processing and image-simulation calculations is enormous and ubiquitous. Several programs now exist to perform simulations of diffraction contrast images using various approximations. The most common approximations are the use of only 2-beams or a single systematic row to calculate the image contrast, or calculating the image using a column approximation. The increasing amount of literature showing comparisons of experimental and simulated images shows that it is possible to obtain very close agreement between the two images; although the choice of parameters used, and the assumptions made, in performing the calculation must be properly dealt with. The simulation of the images of defects in materials has, in many cases, therefore become a tractable problem.

Science of Ahangyol and Its Importance for Modern Scientific Thought

2019 ◽  
Vol 10 (5) ◽  
pp. 473-478
Author(s):  
Ahmad Gashamoglu ◽  
Keyword(s):  
Modern Science ◽  
Scientific Basis ◽  
New Paradigm ◽  
Islamic Philosophy ◽  
Scientific Thought ◽  
Religious Books ◽  
Strategic Approach ◽  
Scientific Potential ◽  
Made In

The Article briefly discusses the need for generation of the Science of Ahangyol, and this science’s scientific basis, object and subject, category system, scientific research methods and application options. Ahangyol is a universal science and may be useful in any sphere. It may assist in problem solving in peacemaking process and in many areas such as ecology, economics, politics, culture, management and etc. This science stipulates that any activity and any decision made in the life may only and solely be successful when they comply with harmony principles more, which are the principles of existence and activity of the world. A right strategic approach of the Eastern Philosophy and the Middle Age Islamic Philosophy and scientific thought has an important potential. This strategic approach creates opportunities to also consider irrational factors in addition to rational ones comprehensively in scientific researches. The modern scientific thought contributes to implementation of these opportunities. Ahangyol is a science of determination of ways to achieve harmony in any sphere and of creation of special methods to make progress in these ways through assistance of the modern science. Methods of the System Theory, Mathematics, IT, Astronomy, Physics, Biology, Sociology, Statistics and etc. are more extensively applied. Information is given on some of these methods. Moreover, the Science of Ahangyol, which is a new philosophical worldview and a new paradigm contributes to clarification of metaphysic views considerably and discovery of the scientific potential of religious books.

scholarly journals Determination of Environmental Factors for the Implementation of the Exploitability Index in Industrial Aggregate Mining Using Multi-Criteria Analysis

2021 ◽  
Vol 10 (4) ◽  
pp. 196
Author(s):  
Julio Manuel de Luis-Ruiz ◽  
Benito Ramiro Salas-Menocal ◽  
Gema Fernández-Maroto ◽  
Rubén Pérez-Álvarez ◽  
Raúl Pereda-García
Keyword(s):  
Environmental Factors ◽  
Environmental Factor ◽  
Human Life ◽  
Accurate Estimation ◽  
Analytic Hierarchy ◽  
Main Components ◽  
Hierarchy Process ◽  
Made In

The quality of human life is linked to the exploitation of mining resources. The Exploitability Index (EI) assesses the actual possibilities to enable a mine according to several factors. The environment is one of the most constraining ones, but its analysis is made in a shallow way. This research is focused on its determination, according to a new preliminary methodology that sets the main components of the environmental impact related to the development of an exploitation of industrial minerals and its weighting according to the Analytic Hierarchy Process (AHP). It is applied to the case of the ophitic outcrops in Cantabria (Spain). Twelve components are proposed and weighted with the AHP and an algorithm that allows for assigning a normalized value for the environmental factor to each deposit. Geographic Information Systems (GISs) are applied, allowing us to map a large number of components of the environmental factors. This provides a much more accurate estimation of the environmental factor, with respect to reality, and improves the traditional methodology in a substantial way. It can be established as a methodology for mining spaces planning, but it is suitable for other contexts, and it raises developing the environmental analysis before selecting the outcrop to be exploited.

Sign in / Sign up

Export Citation Format

Share Document