Implementasi Data Warehouse Dan Penerapannya Pada PHI-Minimart Dengan Menggunakan Tools Pentaho dan Power BI

2021 ◽  
Vol 10 (1) ◽  
pp. 163
Author(s):  
Gede Acintia Udayana ◽  
I Made Yoga Mahendra ◽  
I Kadek Anom Sukawirasa ◽  
Gde Deva Dimastawan Saputra ◽  
Ida Bagus Made Mahendra
Keyword(s):  
Data Warehouse ◽  
On Line ◽  
Analytical Processing ◽  
On Line Analytical Processing

Seorang pemilik toko membutuhkan sebuah sistem informasi untuk melihat kondisi penjualan Namun pada PHI Minimart hanya menyediakan informasi penjualan yang disimpan dalam database sehingga tidak dapat menyediakan atau menyajikan informasi dengan cepat. Untuk mengatasi permasalahan tersebut dibangun sebuah data warehouse di PHI Mart untuk mendapatkan informasi yang cepat. Penelitian ini akan melakukan Implementasi data Warehouse penjualan dari sumber data, proses extraction, transformation, loading (ETL) menggunakan tools Pentaho, pembuatan Starschema berupa dimensi cabang, dimensi produk, dimensi karyawan, dimensi waktu yang terhubung dengan fact table penjualan, dashboard menggunakan power BI. Kemudian hasil data warehouse dianalisa melalui proses OLAP (On-line Analytical Processing),pembuatan cube atau schema workbench, dan pembuatan dashboard untuk Visualisasi dalam penyajian informasi yang diharapkan dari PHI Minimart. Hasil dalam penelitian ini mencangkup data penjualan yang digunakan tahun 2008 berupa tampilan grafik atau dashboard penjualan , barang yang laku terjual, dan total penjualan tiap cabang, yang didapat sebagai penyampaian informasi penjualan pada toko tersebut.

scholarly journals Perancangan Data Warehouse pada Laporan PDPT di Kopertis Wilayah V

2016 ◽  
Vol 3 (3) ◽  
pp. 255
Author(s):  
Sukarsono Windu Kumoro ◽  
Abidarin Rosidi ◽  
Armadyah Amborowati
Keyword(s):  
Higher Education ◽  
Data Warehouse ◽  
Teaching And Learning ◽  
Private Higher Education ◽  
Faculty Teaching ◽  
Star Schema ◽  
On Line ◽  
Analytical Processing ◽  
On Line Analytical Processing ◽  
Academic Year

Evaluasi terhadap Program Studi pada Perguruan Tinggi Swasta (PTS) yang memperoleh Ijin Penyelenggaraan dari Dirjen Dikti dibutuhkan oleh Koordinator Kopertis Wilayah V. Laporan PDPT telah terkumpul sejak tahun akademik 2002 semester ganjil (2002-1) sampai dengan tahun akademik 2013 semester genap (2013-2) yang terdiri dari data transaksi yang terkait dengan proses belajar mengajar di PTS. Laporan PDPT dari PTS dikerjakan atas dasar “Culture Trust”. Untuk mengatasi permasalahan tersebut dibangun sebuah data warehouse di Kopertis Wilayah V DIY. Data warehouse ini dikembangkan dengan menggunakan Foxpro dan Clipper dikarenakan data yang dilaporkan menggunakan file berekstendi DBF. Foxpro dan Clipper adalah sebuah paket basisdata dan dapat didistribusikan.Dalam pengerjaan pembangunan data warehouse ini akan melalui proses ETL dan pembuatan Star Schema (Skema Bintang) berupa dimensi-dimensi yang terhubung dengan tabel fakta berupa tabel aktifitas perkuliahan mahasiswa, evaluasi program studi dan aktifitas dosen mengajar di seluruh program studi pada PTS yang menjadi binaan Kopertis Wilayah V. Kemudian hasil data warehouse akan dianalisa melalui proses OLAP (On-line Analytical Processing).The evaluation of the Program on Private Higher Education (PTS) which derive from the Operating Licence required by the Coordinator General of Higher Education Kopertis Region V. PDPT reports have been collected since 2002 semester of the academic year (2002-1) until the second semester of academic year 2013 (2013-2), which consists of transaction data associated with the teaching and learning process in the PTS. PDPT reports of PTS is done on the basis of "Culture Trust".To overcome these problems built a data warehouse in Kopertis Region V DIY. The data warehouse was developed using FoxPro and Clipper because the data reported using a DBF file extension. FoxPro and Clipper is a package database and can be distributed. In the execution of data warehouse development is going through the ETL process and the making of Star Schema (Star Schema) in the form of dimensions that are connected with the fact table in the form of table activity lecturing students, evaluation of courses and activities throughout the faculty teaching courses at private universities being built Kopertis region V. Then the results will be analyzed data warehouse through a process of OLAP (On-line Analytical Processing).

Enhancing the Diamond Document Warehouse Model

2020 ◽  
Vol 16 (4) ◽  
pp. 1-25
Author(s):  
Maha Azabou ◽  
Ameen Banjar ◽  
Jamel Omar Feki
Keyword(s):  
Data Warehouse ◽  
Decision Makers ◽  
Main Concern ◽  
Multidimensional Model ◽  
On Line ◽  
Analytical Processing ◽  
On Line Analytical Processing

The data warehouse community has paid particular attention to the document warehouse (DocW) paradigm during the last two decades. However, some important issues related to the semantics are still pending and therefore need a deep research investigation. Indeed, the semantic exploitation of the DocW is not yet mature despite it representing a main concern for decision-makers. This paper aims to enhancing the multidimensional model called Diamond Document Warehouse Model with semantics aspects; in particular, it suggests semantic OLAP (on-line analytical processing) operators for querying the DocW.

scholarly journals Uma proposta de aplicação de business intelligence no chão-de-fábrica

2005 ◽  
Vol 12 (1) ◽  
pp. 55-66 ◽  
Author(s):  
Marcos Roberto Fortulan ◽  
Eduardo Vila Gonçalves Filho
Keyword(s):  
Data Warehouse ◽  
Business Intelligence ◽  
On Line ◽  
Analytical Processing ◽  
On Line Analytical Processing

A evolução do chão-de-fábrica tem sido significativa nas últimas décadas, quando grandes investimentos têm sido realizados em infra-estrutura, automação, treinamento e sistemas de informação, transformando-o numa área estratégica para as empresas. O chão-de-fábrica gera hoje grande quantidade de dados que, por estarem dispersos ou desorganizados, não são utilizados em todo o seu potencial como fonte de informação. Com vistas nessa deficiência, este trabalho propõe a implantação de um sistema de Business Intelligence por meio do uso de ferramentas de Data Warehouse e OLAP (On-Line Analytical Processing), aplicadas especificamente ao chão-de-fábrica. O objetivo é desenvolver um sistema que utilize os dados resultantes do processo produtivo e os transforme em informações que auxiliem o gerente na tomada de decisões, de forma a garantir a competitividade da empresa. Um protótipo foi construído com dados simulados para testar a proposta.

scholarly journals On-line Analytical Processing (OLAP) Operation for Outpatient Healthcare

2021 ◽  
pp. 225-231
Author(s):  
Talib M. J. Al Taleb ◽  
Sami Hasan ◽  
Yaqoob Yousif Mahd
Keyword(s):  
Data Warehouse ◽  
Business Intelligence ◽  
Decision Makers ◽  
Data Repository ◽  
Managerial Decision ◽  
High Quality Information ◽  
On Line ◽  
Analytical Processing ◽  
On Line Analytical Processing ◽  
Different Sources

This paper presents an architecture for the data warehouse of outpatient healthcare (DWOP) as a data repository collects data from two different sources (Databases of outpatient healthcare and Excel files from hospitals) and provides storage, functionality and responsiveness to queries to meet decision makers requirements.Successfully supporting managerial decision-making is critically dependent upon the availability of integrated, high quality information organized and presented in a timely and easily understood manner. “On-Line Analytical Processing (OLAP) is utilized for decision support to get interesting information” from the data warehouse with a rapid execution time. OLAP is considered one of Business Intelligence tools.

scholarly journals IMPLEMENTASI OLAP (ON-LINE ANALYTICAL PROCESSING) UNTUK PENGOLAHAN TRANSAKSI PENJUALAN BERBASIS WEB (STUDI KASUS: LILOLA BOUTIQUE)

2018 ◽  
Vol 4 (1) ◽  
Author(s):  
Ni Putu Manik Ardiyanti ◽  
Aniek Suryanti Kusuma ◽  
I Kadek Budi Sandika
Keyword(s):  
Decision Making ◽  
Data Warehouse ◽  
Black Box ◽  
Web Based ◽  
Processing Application ◽  
Sales Data ◽  
Black Box Testing ◽  
On Line ◽  
Analytical Processing ◽  
On Line Analytical Processing

ABSTRACT<br />Information on sales data required by the owner at Lilola Boutique as a basis for decision making and strategy . On the other hand, the large amount of transactional sales data that occurs at any time causes problems in these analyze process. To solve these problem, an OLAP (On-Line Analytical Processing) application was built. OLAP application is designed using the CodeIgniter framework which produces a fast and reliable web-based application and data warehouse as its database. To produce a good data warehouse, the Nine Step Kimball method were used. Stages of this method produced a snowflake scheme as a storage place for data warehouse. The implementation of the system design could produced the OLAP report required by Lilola Boutique. Testing the system using black box testing method that showed the performance of applications that run well. From the results of this study can be concluded that OLAP application made the process of sales transaction data analysis to produce reports as the basis of the decision-making process.<br />Keywords: Sales, OLAP, Data Warehouse, Nine Step Kimball<br />ABSTRAK<br />Informasi mengenai data penjualan dibutuhkan oleh owner pada Lilola Boutique sebagai dasar untuk pengambilan keputusan dan penentuan strategi perusahaan. Di sisi lain, banyaknya data transaksi penjualan yang terjadi setiap harinya menyebabkan kesulitan dalam proses analisa dan pengambilan keputusan. Untuk mengatasi permasalahan tersebut, dibangun sebuah aplikasi OLAP (On-Line Analytical Processing). Perancangan aplikasi OLAP dirancang menggunakan framework CodeIgniter yang menghasilkan aplikasi berbasis web yang handal dan cepat dan data warehouse sebagai basis datanya. Untuk menghasilkan data warehouse yang baik, digunakan metode perancangan Nine Step Kimball. Tahapan metode ini menghasilkan rancangan snowflake schema sebagai tempat penampungan data warehouse. Implementasi rancangan sistem dapat menghasilkan laporan OLAP yang dibutuhkan oleh pihak Lilola Boutique. Pengujian sistem menggunakan metode black box testing yang menghasilkan unjuk kerja aplikasi yang berjalan dengan baik. Dari hasil penelitian ini dapat disimpulkan bahwa sistem aplikasi OLAP dapat membantu proses pengolahan data transaksi penjualan untuk menghasilkan laporan yang berkualitas sebagai dasar dalam pengambilan keputusan.<br />Kata Kunci: Penjualan, OLAP, Data Warehouse, Nine Step Kimball

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.

Sign in / Sign up

Export Citation Format

Share Document