Teaching Data Quality Concepts Through Case Studies

It is estimated that as much as 75% of the effort spent on building a data warehouse can be attributed to back-end issues, such as readying the data and transporting it into the data warehouse. Data quality tools are becoming an increasingly important resource in preparing the data for the warehouse, thus enhancing the usability of the warehouse. This tutorial, based on current research in the field, will focus on a methodology for managing data quality issues. The tutorial will present a framework for identifying data quality issues and making sense of the data quality tools marketplace. A case study approach will be used. The methodology presented is applicable both as a tool to teach about data quality issues and as a tool to support practitioners as they seek mechanisms to facilitate the management of data, yet ensure appropriate data quality

EVALUASI DATA WAREHOUSE RUMAH SAKIT UNTUK DATA KUNJUNGAN PASIEN RAWAT JALAN

Hospitals as health care services (healthcare) desperately need the presence of information and communication technology in recording the activity of the business process, especially outpatient. Along with the development of business processes, the number of patients in hospitals is increasing causing the traffic data that must be managed increases. Big data is managed for use in preparing the report and decision support systems. Recording and storage are not integrated into obstacles in providing decision support information. Application of data warehouse-based Online Analytical Processing (OLAP) became solutions to these problems. The purpose of this study was to evaluate the data warehouse architecture-hospital outpatient based definition by Bill Inmon data warehouse

Rancang Bangun Real-Time Business Intelligence Untuk Subjek Kegiatan Akademik pada Universitas Menggunakan Change Data Capture

Abstract. The running of academic activities in university continuously adds more data to the existing operational system. The data are not ready for the university strategic decision making, preparing reports for accreditation purposes and academic units. Real-time business intelligence application using data warehouse can become a solution for data analysis. The process of creating a data warehouse includes designing data warehouse, retrieving academic data from multiple data sources, extracting, transforming, loading (ETL) process, creating cube; and generating report. ETL processes are conducted by using a Pull Change Data Capture approach so that data changes during a certain period can be transferred in real-time. The higher the frequency of data change requests brings us closer to real-time and requires less time than loading all the data.Keywords: real-time, business intelligence, data warehouse, academic, change data capture Abstrak.  Kegiatan akademik di universitas berjalan terus menerus dan semakin menambah banyak data pada sistem operasional yang sudah ada. Data tersebut masih belum dapat dimanfaatkan oleh pihak universitas dalam pengambilan keputusan strategis, pembuatan laporan untuk keperluan akreditasi dan unit-unit akademik. Aplikasi real-time business intelligence menggunakan data warehouse menjadi solusi untuk analisa data. Proses pembuatan data warehouse meliputi perancangan data warehouse; pengambilan data akademik dari sumber data; proses extraction, transformation, loading (ETL); pembuatan cube; dan pembuatan laporan. Proses ETL dilakukan menggunakan pendekatan Change Data Capture Pull agar perubahan data selama periode tertentu dapat dipindahkan secara real-time. Semakin tinggi frekuensi permintaan perubahan data akan semakin mendekati real-time dan semakin membutuhkan waktu yang singkat dibandingkan dengan me-load semua data.Kata Kunci: real-time, business intelligence, data warehouse, akademik, change data captur

PERANCANGAN SISTEM INFORMASI MANAJEMEN PERSEDIAAN BARANG DI PT. PERKEBUNAN NUSANTARA XI (PERSERO) PABRIK KARUNG ROSELLA BARU SURABAYA

The very rapid technological developments are accompanied by advances in technology, leading companies must devote all its resources optimally and professional company to support the company's success in confronting fierce competition in this era of globalization. The company's success is highly dependent on the success of management in carrying out his job. The success of the company's management depending on the availability of relevant information from appropriate data processing. In order for information work can be handled in a systematic and practical need for management information systems. New Pk.Rosella is a company engaged in the manufacture of plastic bags. Along with the development company the right information is necessary to accurately Pk. Rosella in handling the administration of sales and warehouse stock. To assist the decision making process by management. Unavailability of appropriate information systems, rapid and accurate lead time data processing and report maker becomes ineffective and can cause kesalahn in preparing reports that will ultimately affect the process penganbilan decision by management. The purpose of this study is to design a management information system in order to obtain the results of the election effective and efficient inventory and inventory related permasalahn overcome the design information data base, which contains information on design inputs and design outputs in the form of a report - the report. From the research results obtained that information systems designed to improve the procedure warehouse stock sales activities and becoming more effective because it can shorten the time of reporting, speed up delivery of information to managers so that production can easily control the existing inventory in warehouse

Adoption of standard ERP solution in health care sector: is SAP ERP all-in-one capable to meet specific requirements?

Objective of this experience report is to address specific issues regarding standard SAP ERP implementation in a medical institution. Target Company is a state owned health care institution from Bosnia and Herzegovina. Report will treat selected issues which could trouble standard SAP ERP implementation trough predefined ERP implementation methodology for SAP ERP. This report presents observations/ remarks based on experience of authors in particular SAP ERP implementation project in health care institution. Author’s goal is to provide useful insight into “real life” standard ERP implementation and problems that arise. Also, it should provide useful information for all stakeholders involved in the process of ERP implementation in public health care sector

Procurement System In Drug Design Pharmacies Healthy Development

Pharmacy is an important effort inhealth. Pharmacy is a community service facilities in providing medicines and supplies other information. Therefore, the above functions requires good management pharmacies and tidy in order to support the progress of these pharmacies. Such efforts will be realized when data recording is done well by a section of the warehouse, sales, purchasing and others. At the Healthy Community Pharmacy purchasing system is still done manually, especially in the issuance of purchase orders and reports. And frequent delays in ordering products.Basically every company expects the existence of a data processing is true and accurate to resolve the problems in data processing and to support decision-making on the part of the company. Therefore in this paper, the authors tried to computerize the processing of data, especially data processing, letter creation process purchase orders and preparing reports using tools for system development. The tools that are used to design the purchasing system in this paper are: FOD, context diagram, DFD, ERD, and Normalization.Given the design of the system is done, the writer tries to mengkomputerisasi purchases of data processing is a discussion of this research writing