Proses Extraction-Transformation-Loading (ETL) pada pembangunan data warehouse berperan melakukan ekstraksi data dari berbagai sumber, pengubahan data ke bentuk yang sesuai dengan kebutuhan dan pengisian ke storage data warehouse. Termasuk di dalam fungsi ETL terdapat proses data cleansing yang menangani redundansi, inkonsistensi dan integritas data. Proses ETL akan mengisikan data dari sumber ke integration layer yang merupakan tempat data dari data warehouse tergabung dan terintegrasi. Dari integration layer, data dapat dikelompokkan dengan lingkup yang lebih kecil dan sesuai kebutuhan dalam repository lain yang disebut data mart. Program reporting dari data warehouse akan berhubungan dengan data mart sebagai sumber datanya.Penelitian ini merupakan bagian dari Penelitian berbasis profesi pembangunan data warehouse. Secara khusus Penelitian menangani proses ETL. Pada Penelitian ini dibangun metadata bagi proses ETL yang menyimpan definisi data sumber, data arget (data warehouse), dePenelitian keterhubungan antara data sumber dan data target, serta dePenelitian transformasi data dari data sumber ke data target. Dibangun juga program ETL dengan teknologi DTS pada SQL Server 2000 yang menggunakan metadata tersebut. Diharapkan dengan adanya metadata bagi proses ETL dapat dibangun program ETL yang memiliki tingkat reusability tinggi. Kesimpulan utama yang dapat diambil dari Penelitian ini adalah penggunaan proses ETL yang dinamis (menggunakan metadata ETL) sangat diperlukan apabila berhubungan dengan sistem operasional yang masih labil dan berkemungkinan besar mengalami perubahan skema basis data. Proses ETL dinamis juga diperlukan untuk menangani kebutuhan pengguna akan laporan yang bertambah.

No abstract

Indonesia has an enormous number of endangered species of flora (plants) as well as fauna (animals). Several factors influence endangered species such as lack of early education in this problem. Whereas, children, especially in school ages, have the most potential role in the future to solve this problem. To influence the behavior and attitudes of children towards wildlife, Conservation Education is the solution. By providing appropriate and effective conservation education, future conservation behavior can change in a positive direction. To address this opportunity, we proposed FloNa, a mobile app to educate children about Indonesian endangered species. FloNa is empowered by augmented reality to help children imagine and observe the real form of endangered plants and animals. Furthermore, we conducted experiments to analyze the efficiency of this app to overcome this problem. The alpha testing result shows that FloNa has a robust design and implementation. Moreover, from the beta testing result, we could conclude that FloNa could significantly support and promote endangered species conservation education for children in Indonesia.

Digital media can support Micro, Small, and Medium Enterprise (MSME) businesses to increase brand awareness of their products, so they can gain competitive advantages and reach a broader market. Unfortunately, not all MSME businesses have the capabilities to utilize digital media to support their businesses. The MSMEs in Buah Batu district face problems that can not be resolved by conventional marketing methods, such as lack of brand awareness and drop in sales which results in the decrease of their revenues and profits. This Community Service aims to improve the MSME's knowledge and skills on creative digital marketing strategy and their understanding of the marketplace so they can create online stores for their businesses. Online stores make it feasible for those MSMEs to broaden their market reach. For the problems related to the IT area, the team will provide network training. The method applied was the service-learning approach. The results of this community service are that the MSMEs in Buah Batu District are capable to create their online shops, promote their products through the marketplace and social media and finally increase their revenues. The output of these community service activities is the design of MSME product packaging and website.

One of the Dewan Kemakmuran Masjid (committee to serve public service in a mosque) main task is to provide prayer facilities in a mosque, such as managing schedules for muezzin and imam salat. Most of the time, the plan is executed manually. Moreover, preparing the schedule is not easy. It needs cautious and excessive effort as DKM members should be careful not to make an unbalanced schedule for each muezzin/ khatib. It is also an error-prone process since putting the unavailable person in the schedule slot is possible. To overcome the condition, we build a mobile application for managing schedules for muezzin and imam salat. The application has been tested with usability testing and a user experience questionnaire. The results from both testing tools yield excellent results; the application could implement and comfortably used for managing schedules. From the result, it can be inferred that Al Aboor meets the criteria for a good mobile application and can be developed further.