Business Intelligence Design for Data Visualization and Drug Stock Forecasting

Klinik Pratama is one form of service provided by the Ministry of Communication and Information of the Republic of Indonesia in protect employees from health disorders that could affect employee productivity. In its development, the clinic often finds problems, one of them is often a shortage or excess the drug stock on a running period. Therefore, it be required a design of an Business Intelligence that manages complex data into a data visualization forecasting of the future stock of drugs. Historical data processing of the drug is done with process of Extract, Transform and Load (ETL) using the Spoon Pentaho Data Integration tools. While the visualization of drug stock data and forecast results is done using Microsoft Power BI (Business Intelligence) tools and for forecasting is done with Artificial Neural Network method by RStudio tools. The results of forecasting the amount of stock out of drug samples using the Artificial Neural Network method obtained an MSE value of 67.72 and RMSE 8.22 which means that this forecast has a good ability with the resulting error rate is relatively small. From this research, the Klinik Pratama of the Ministry of Communication and Information can easily understand and analyze drug stock data and can support operational decision making The results of forecasting the amount of stock out of drug samples using the Artificial Neural Network method obtained an MSE value of 67.72 and RMSE 8.22 which means that this forecast has a good ability because the resulting error rate is relatively small. From this research, Klinik Pratama of the Ministry of Communication and Information can easily understand and analyze drug stock data and can support operational decision making The results of forecasting the amount of stock out of drug samples using the Artificial Neural Network method obtained an MSE value of 67.72 and RMSE 8.22 which means that this forecast has a good ability with the resulting error rate is relatively small. From this research, Klinik Pratama of the Ministry of Communication and Information can easily understand and analyze drug stock data and can support operational decision making.

KNOWLEDGE MANAGEMENT SYSTEM PROVISIONS ON THE IMPORT OF CONSIGNMENTS AT CUSTOMS AND EXCISE SUPERVISION AND SERVICE OFFICE PASAR BARU

<p class="Text"><span lang="EN-US">The activity of importing goods has the potential to experience obstacles or problems in the processing through Customs and Excise due to various kinds of requirements that must be met. So that knowledge management is needed by importers who will carry out import activities because it can increase knowledge in the process and delivery requirements. In order to maximize knowledge, efforts need to be made to create a website-based knowledge management system that is expected to be a solution to these needs. The method used in this study is the Becerra-Fernandez framework method for data collection and processing in determining knowledge management solutions. It also uses the waterfall method for system development using the System Development Life Cycle (SDLC) approach.</span></p>

Odoo ERP Implementation Point of Sale Module at Mc Cake

<p class="Abstract"><strong>Mc Cake is one of the business people in the food industry. Which was founded in Bekasi, West Java. Mc Cake has constraints and problems including the lack of a system that streamlines the time and division of job desk at the company. It also shows that the sales order business process has not been integrated with the sales system at Mc Cake. The process that is currently running from the sale transaction is still done manually.</strong></p><strong> In this problem, the solution considered to be able to handle the problem is by applying the concept of ERP (Enterprise Resource Planning) using the Odoo application with a point of sales module, because the advantages that can be obtained are speed, accuracy, and relatively lower costs compared to other methods. . Odoo is a modular application which means it consists of separate modules but can be integrated with each other. The modules in Odoo include sales, purchase, accounting, point of sale, CRM and marketing. In addition, the business processes carried out on each Odoo module are best practices for the open source class and in general Odoo covers the business processes of MSME trading companies such as Mc Cake.</strong>

VISUALIZATION OF FORECASTING NUMBER OF PATIENTS VISITING IN PRATAMA CLINIC USING ARIMA METHOD

<p><strong>The Primary Clinic of the Ministry of Communication and Information of the Republic of Indonesia </strong><strong>had </strong><strong>a problem that is difficulty in predicting the number of patient visits resulting in a buildup of patients in the clinic. For this reason, it is necessary to forecast patient visits in order to be the basis for planning for the next period and become a material consideration for decisions in clinical development. The research method was conducted using ARIMA by utilizing historical data on clinic visits from 2014-2019. The processed results in RStudio in the form of prediction data for patient visits in 2020-2021 are visualized on a website that uses the PHP Codeigniter framework and is integrated with RStudio. The results of visit forecasting based on services using the ARIMA method have good forecasting abilities, because the MAPE values are in the range of &lt;10% and 10-20%, namely 19.58% and 9.62%.</strong></p>

DESIGN OF FISH SALES INFORMATION SYSTEM IN PT XYZ USING LARAVEL FRAMEWORK

<p>Development of sales information systems is built to produce an information system that includes various procedures that record, calculate, and make documents in the form of reports for management needs in making decisions, ranging from purchase orders from suppliers, recording inventory of goods, to selling goods to consumers. Information on sales recording activities is still manual so there can be a possibility of entry errors and the presence of branch companies that are late or have not provided a sales report. With the existing problems in this company, then this final project research will create a sales system. Based on these problems, a sales information system was made at PT XYZ. PT XYZ Sales Information System Design uses the waterfall method with php laravel framework in producing a system that will record and update purchase order data, item data, and sales order data and can print reports according to the desired date, month and year.</p>

Implementation of the Odoo Point of Sale ERP Module at Gordio Store

<p class="Abstract">Gordio Store is a UMKM that is engaged in developing clothing convection in Tanah Abang Market, Central Jakarta. Operational business processes This business is still done manually and not yet computerized, so the transfer of information about sales is done manually.</p><p class="Abstract">The ongoing sales business process at Gordio Store has become inefficient and the owner has experienced some difficulties, especially information on sales and sales transactions last week or month.</p>Therefore, it is necessary to apply Enterprise Resource Planning (ERP) technology with the aim of resolving these problems. The selection of software used is Odoo software, because it is considered open source and is easy to use and can also keep pace with changes and is integrated as a whole to meet the company's most complex operational needs. From the implementation results show that the Odoo application can overcome the problem of sales data information using the Point of Sale module in Gordio Store. It is expected that with this ERP system business operations can be more effective and efficient so that it is expected to provide more benefits for business owners.

MVC Implementation In Laravel Framework For Development Web-Based E-Commerce Applications

<p class="Abstract">MVC is a concept that separates three main logical components namely model, view and controller. The model represents the database, the view controls the user interface and controller connecting the model and view. The MVC concept makes coding work more structured. Laravel is a PHP framework that uses the concept of MVC so that the use of Laravel to develop an application greatly facilitates the programmer. Besides other facilities offered by Laravel, Laravel provides lightweight layout templates, provides a lot of object oriented libraries and has artistic tools for carrying out commands at the command line that can help programmers build a website or web-based application. With the many conveniences offered by Laravel, the process of developing a large website becomes easier and faster. In this research the development of web-based e-commerce applications is made using the Laravel framework.</p>